Database: pilot_1
Question: Count the number of planes Smith owns.
SQL:
SELECT count(plane_name) FROM pilotskills WHERE pilot_name  =  'Smith'