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
Hello, how many different nationalities of pilots are there?
assistant
SELECT COUNT( distinct Nationality ) FROM pilot;
human
What are the pilot names of those 3 nationalities?
assistant
SELECT Nationality , Pilot_name FROM pilot;
human
What is the most common nationality of the 3 nationalities?
assistant
SELECT Nationality FROM pilot GROUP BY Nationality ORDER BY COUNT( * ) DESC LIMIT 1 ;