#234 Total Payments by Shop

Companies:

Aston

Themes:

SQLAggregationPractice

Write a query that displays the total payment amount for each shop if the total is greater than 1000:

id | shopId | amount | date
1 shop1 1000.00 2023.01.01 15:17:01
2 shop2 700.00 2023.01.01 15:13:02
3 shop2 330.00 2023.01.01 15:10:03
4 ...

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.