#65 Deals and Products Aggregation

Companies:

Sberbank

Themes:

SQLJoinsAggregationPractice

Select the names of all deals and the average product amount across all deals where the number of products is greater than 10, the product currency is RUR, and the total product amount is greater than 1,000,000.

Deal
id | name
...

Product
id | amount | currency | deal_id
...

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.