All Problems
55

Cities with Multiple Customers

MediumGROUP BYHAVINGCOUNT

Problem Description

Write a SQL query to find cities with more than 1 customer.

Expected Columns

  • city
  • customer_count

Example Output

| city | customer_count | |------|----------------| | Mumbai | 2 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#55 Cities with Multiple Customers
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results