human
Schema:
aircraft (Aircraft_ID, Order_Year, Manufacturer, Model, Fleet_Series, Powertrain, Fuel_Propulsion)
pilot (Pilot_ID, Pilot_name, Rank, Age, Nationality, Position, Join_Year, Team)
pilot_record (Record_ID, Pilot_ID, Aircraft_ID, Date)
Please answer with SQL.
assistant
Sure, I understand.
human
List all pilot names with there team name.
assistant
SELECT Pilot_name , Team FROM pilot;
human
Among those, which are from the Team 'Bradley'?
assistant
SELECT Pilot_name FROM pilot WHERE Team = 'Bradley';
human
What about 'Eau Claire High School'?
assistant
SELECT Pilot_name FROM pilot WHERE Team = "Eau Claire High School" ;