Solved programming problem

Show each region_id and corresponding no of countries in that region from countries table

Source code

SELECT REGION_ID, COUNT(COUNTRY_ID)

FROM countries

GROUP BY REGION_ID;
Join the discussion

Add your comment