What are the different nationalities of pilots? Show each nationality and the number of pilots of each nationality.
SELECT Nationality ,  COUNT(*) FROM pilot GROUP BY Nationality
different nationalities of pilots refers to GROUP BY Nationality; number of pilots of each nationality refers to COUNT(*);