Coding Exercise: Find Top Cities by Order Count
Explore how to write SQL queries that join tables and aggregate order data by city. Learn to count orders, group results, and sort them to identify the top cities by order volume. This exercise builds your basic skills in querying and manipulating data to support business decisions.
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 ...