Database: pilot_1
Question: Find the number of planes for each type.
SQL:
SELECT count(*) ,  plane_name FROM pilotskills GROUP BY plane_name