Coding Exercise: Find Top Cities by Order Count
Practice using SQL to fetch and aggregate relational data.
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 with two tables:
Customers
Customer_id | Name | City |
1 | Ayesha | Lahore |
2 | Bilal | Karachi |
3 | Zara | Lahore |
4 | Ahmed | Islamabad |
5 | Hira | Lahore |
...