Write the query,
unlock the insight.
SQL · FoundationsCustomers by city
Easy1SELECT city, COUNT(*) AS customers
2FROM customers
3GROUP BY city
4ORDER BY customers DESC;That’s correct3 rows · 24 ms
1SELECT city, COUNT(*) AS customers
2FROM customers
3GROUP BY city
4ORDER BY customers DESC;