SELECT Nationality ,  COUNT(*) FROM HOST GROUP BY Nationality
How many hosts does each nationality have? List the nationality and the count.
SELECT Nationality , COUNT ( * ) FROM HOST GROUP BY Nationality
select nationality , count ( * ) from host group by nationality
How many hosts does each nationality have ? List the nationality and the count .