Solved programming problem

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

Source code

SELECT COUNTRY_ID, COUNT(LOCATION_ID)

FROM locations

GROUP BY COUNTRY_ID;
Join the discussion

Add your comment