CREATE TABLE airport (id INT, City TEXT, Country TEXT, IATA TEXT, ICAO TEXT, name TEXT)
CREATE TABLE operate_company (id INT, name TEXT, Type TEXT, Principal_activities TEXT, Incorporated_in TEXT, Group_Equity_Shareholding FLOAT)
CREATE TABLE flight (id INT, Vehicle_Flight_number TEXT, Date TEXT, Pilot TEXT, Velocity FLOAT, Altitude FLOAT, airport_id INT, company_id INT)

Show how many flights each pilot has flied in a bar chart.
SELECT Pilot, COUNT(Pilot) FROM flight GROUP BY Pilot ORDER BY Altitude
SELECT "Pilot", COUNT("Pilot") FROM "flight" GROUP BY "Pilot" ORDER BY "Altitude" NULLS FIRST