human
Schema:
pilot (Pilot_Id, Name, Age)
aircraft (Aircraft_ID, Aircraft, Description, Max_Gross_Weight, Total_disk_area, Max_disk_Loading)
match (Round, Location, Country, Date, Fastest_Qualifying, Winning_Pilot, Winning_Aircraft)
airport (Airport_ID, Airport_Name, Total_Passengers, %_Change_2007, International_Passengers, Domestic_Passengers, Transit_Passengers, Aircraft_Movements, Freight_Metric_Tonnes)
airport_aircraft (ID, Airport_ID, Aircraft_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
In which country Swan River ' Perth located ?
assistant
SELECT country FROM MATCH WHERE Location = 'Swan River , Perth';
human
How old is Mr. Cristian Halvorson II?
assistant
SELECT age FROM pilot WHERE name = 'Mr. Cristian Halvorson II';
human
In which country Mina' Zayid , Abu Dhabi located ?
assistant
SELECT country FROM match WHERE Location = "Mina Zayid , Abu Dhabi" ;