38

Customer Order Count

MediumJOINCOUNTGROUP BY

Problem Description

Write a SQL query to count how many orders each customer has placed.

Expected Columns

customer_name
order_count

Example Output

| customer_name | order_count | |---------------|-------------| | Rajesh Kumar | 3 | | Sunita Devi | 2 | | Amit Sharma | 2 | | ... | ... |

Hints

Unlocks after 2 more attempts

Submit your solution to unlock hints

//#38 Customer Order Count

Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results