List all pilot names with there team name.
select pilot_name, team from pilot
Among those, which are from the Team "Bradley"?
select pilot_name from pilot where team = "Bradley"
What about "Eau Claire High School"?
select pilot_name from pilot where team = "Eau claire high School"
What about "Bradley" or "Fordham"?
select pilot_name from pilot where team = "Bradley" or team = "Fordham"