Solved programming problem

For each city, show the total no of locations in that city from the locations table

Source code

SELECT CITY, COUNT(*)

FROM locations

GROUP BY CITY;
Join the discussion

Add your comment