CREATE TABLE aircraft (aircraft_id DECIMAL, order_year DECIMAL, manufacturer TEXT, model TEXT, fleet_series TEXT, powertrain TEXT, fuel_propulsion TEXT)
CREATE TABLE pilot (pilot_id DECIMAL, pilot_name TEXT, rank DECIMAL, age DECIMAL, nationality TEXT, position TEXT, join_year DECIMAL, team TEXT)
CREATE TABLE pilot_record (record_id DECIMAL, pilot_id DECIMAL, aircraft_id DECIMAL, date TEXT)

Show the names of pilots from team 'Bradley' or 'Fordham'.
SELECT pilot_name FROM pilot WHERE team = "Bradley" OR team = "Fordham"
SELECT "pilot_name" FROM "pilot" WHERE "Bradley" = "team" OR "Fordham" = "team"