Database: pilot_1
Question: Find pilots who own planes Piper Cub and B-52 Bomber.
SQL:
SELECT pilot_name FROM pilotskills WHERE plane_name  =  'Piper Cub' INTERSECT SELECT pilot_name FROM pilotskills WHERE plane_name  =  'B-52 Bomber'