-- Database schema
| aircraft : Aircraft_ID [ INT ] primary_key , Order_Year [ INT ] , Manufacturer [ TEXT ] , Model [ TEXT ] , Fleet_Series [ TEXT ] , Powertrain [ TEXT ] , Fuel_Propulsion [ TEXT ] | pilot : Pilot_ID [ INT ] primary_key , Pilot_name [ TEXT ] , Rank [ INT ] , Age [ INT ] , Nationality [ TEXT ] , Position [ TEXT ] , Join_Year [ INT ] , Team [ TEXT ] | pilot_record : Record_ID [ INT ] , Pilot_ID [ INT ] primary_key pilot_record.Pilot_ID = pilot.Pilot_ID , Aircraft_ID [ INT ] pilot_record.Aircraft_ID = aircraft.Aircraft_ID , Date [ TEXT ] |
-- -- What are the positions and teams of pilots?

SELECT POSITION ,  Team FROM pilot;