Show the country of each person.
select country from people
Count the number of people from each country.
select count(*) from people group by country
Also show the country name.
select country, count(*) from people group by country