#31 Finding Employees by Total Payments

Companies:

Itone

Themes:

SQLJoinsAggregationPractice

The following tables are given:

Persons
id | name
1 Petya
2 Ivan
3 Misha
...

Payments
id | Person_id | Value
1 1 9
2 1 20
3 3 15...

The relationship between the tables is one-to-many, and an employee may have several payments or none at all. Find employees whose total payment amount is greater than 20.

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.