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;
[{'ContId': 1, 'Continent': 'america', 'count(*)': 3}, {'ContId': 2, 'Continent': 'europe', 'count(*)': 6}, {'ContId': 3, 'Continent': 'asia', 'count(*)': 2}, {'ContId': 4, 'Continent': 'africa', 'count(*)': 2}, {'ContId': 5, 'Continent': 'australia', 'count(*)': 2}]