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

Create a pie chart showing how many pilot across pilot.
SELECT Pilot, COUNT(Pilot) FROM flight GROUP BY Pilot
SELECT "Pilot", COUNT("Pilot") FROM "flight" GROUP BY "Pilot"