Database: pilot_1
Question: Count the number of entries for each plane name.
SQL:
SELECT count(*) ,  plane_name FROM pilotskills GROUP BY plane_name