#101 Total Order Amount by City

Companies:

Sberbank

Themes:

SQLJoinsAggregationPractice

Display the total order amount by city:

cities
city_id | city_name
...

orders
order_id | city_id | total
...

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.