Show all the pilot names and positions
select pilot_name, position from pilot
Show all the names and their age?
select pilot_name, age from pilot
Keep those who are 37 years old.
select pilot_name, age from pilot where age = 37
Show the distinct positions of pilots older than 30.
select distinct position from pilot where age > 30