Database: pilot_record
Question: What are the different nationalities of pilots? Show each nationality and the number of pilots of each nationality.
SQL:
SELECT Nationality ,  COUNT(*) FROM pilot GROUP BY Nationality