Coding Exercise: Find Top Cities by Order Count
Explore how to query and combine data from multiple tables to find cities with the highest order counts. Learn to join tables, aggregate with COUNT and GROUP BY, and sort results using ORDER BY, building practical SQL skills for data analysis.
We'll cover the following...
We'll cover the following...
Scenario
You’ve just joined a food delivery company as a junior data analyst. Management wants to know which cities are generating the most orders so they can allocate more delivery drivers.
Dataset
You’ll be working ...