#21 Clients with the Highest Total Purchase Amount

Companies:

Wildberries

Themes:

SQLJoinsAggregationSubqueriesPractice

The following tables are given

Orders
id | client_id | amount
...

Client
id | name
...

Return the clients with the highest total purchase amount.

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.