human
Schema:
airport (id, City, Country, IATA, ICAO, name)
operate_company (id, name, Type, Principal_activities, Incorporated_in, Group_Equity_Shareholding)
flight (id, Vehicle_Flight_number, Date, Pilot, Velocity, Altitude, airport_id, company_id)
Please answer with SQL.
assistant
Sure, I understand.
human
Which flight has the least velocity in the list? | What info do you want about that flight? id? date? number? or something else? | I want the number
assistant
SELECT Vehicle_Flight_number FROM flight ORDER by Velocity LIMIT 1;
human
State the principal activities of Air Hong Kong?
assistant
SELECT distinct Principal_activities FROM operate_company WHERE name = "Air Hong Kong" ;