SELECT T1.ContId ,  T1.Continent ,  count(*) FROM CONTINENTS AS T1 JOIN COUNTRIES AS T2 ON T1.ContId  =  T2.Continent GROUP BY T1.ContId;
How many countries does each continent have? List the continent id, continent name and the number of countries.
SELECT T1.ContId , T1.Continent , count ( * ) FROM CONTINENTS AS T1 JOIN COUNTRIES AS T2 ON T1.ContId = T2.Continent GROUP BY T1.ContId ;
select t1 . contid , t1 . continent , count ( * ) from continents as t1 join countries as t2 on t1 . contid = t2 . continent group by t1 . contid
How many countries does each continent have ? List the continent id , continent name and the number of countries .