Cities With Most Loyal Customers

Unsolved

For 2025-01-01 through 2025-03-31, count orders in each city placed by customers with at least two orders in that period. Sort by qualifying order count descending, then city.

Learn the concept: GROUP BYWHERE, ORDER BY & LIMIT

SQL Query Editor (Ctrl+Enter to run)

0 characters · Valid

Canonical Solution Official

Official Solution is Hidden

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Community Q&A & Discussion

Ask questions, share alternate queries, and explore solutions

0 comments

Asked By:

🏢 Flipkart🏢 Swiggy🏢 Zomato

Submission History

Your recent query executions and answer checks

Execution Pipeline:

FROM CustomerOrders

Full source dataset

8 rows total

This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.

Cities With Most Loyal Customers

Official Solution is Hidden

Approach & Explanation

Community Q&A & Discussion

Submission History