What are the names of the pilots with IDs 1 and 2?
select pilot_name from pilot where pilot_id = 1 or pilot_id = 2
How many records do they have?
select t2.pilot_id, count ( * ) from pilot_record as t1 join pilot as t2 on t1.pilot_id = t2.pilot_id where t2.pilot_id = 1 or t2.pilot_id = 2 group by t2.pilot_id
Which year did they join?
select pilot_id, join_year from pilot where pilot_id = 1 or pilot_id = 2
Which are their teams?
select pilot_id, team from pilot where pilot_id = 1 or pilot_id = 2