Show all the pilot names and positions.
select pilot_name, position from pilot
What about the pilot names and their teams?
select position, team from pilot