#336 Employees with Total Payments Greater Than 100

Companies:

Itone

Themes:

SQLJoinsAggregationPractice

The person table contains a list of employees:

id | name
1 Petya
2 Vasya
3 Kolya

The payment table contains salary payments:

id | person_id | payment_value
1 1 70
2 1 60
3 3 15

Write a query that selects the names of employees whose total payments are greater than 100.

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.