Show city and customers (the number of customers who live there) for every city with
at least 2 customers.
End your query with ORDER BY customers DESC, city.
| customers |
|---|
| customer_id (PK) |
| full_name |
| city |
Show city and customers (the number of customers who live there) for every city with
at least 2 customers.
End your query with ORDER BY customers DESC, city.
| customers |
|---|
| customer_id (PK) |
| full_name |
| city |
| city | customers |
|---|---|
| Chennai | 3 |
| Delhi | 3 |
| Kochi | 3 |
| Bengaluru | 2 |
| Hyderabad | 2 |
| Kolkata | 2 |
| Lucknow | 2 |
| Mumbai | 2 |
| Pune | 2 |
Run query to see output