What are different nationalities of people and the corresponding number of people from each nation?
create table people (nationality varchar, PRIMARY KEY (nationality))
select nationality, count(*) from people group by nationality