SELECT
COUNT("CUST_ID"),
"CUST_CITY"
FROM SH."CUSTOMERS"
GROUP BY "CUST_CITY"
ORDER BY COUNT("CUST_ID") DESC
FETCH FIRST 10 ROWS ONLY
| COUNT("CUST_ID") | CUST_CITY | 932 | Los Angeles | 695 | Greenwich | 637 | Killarney | 612 | Montara | 585 | Noma | 582 | Hiseville | 576 | Arbuckle | 557 | Wolverhampton | 549 | Mackville | 532 | Koeln |
|---|