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 operate_company (id NUMBER, name CLOB, Type CLOB, Principal_activities CLOB, Incorporated_in CLOB, Group_Equity_Shareholding FLOAT)
CREATE TABLE airport (id NUMBER, City CLOB, Country CLOB, IATA CLOB, ICAO CLOB, name CLOB)

How many companies that have ever operated a flight for each type? Draw a bar chart, and display in desc by the total number.
SELECT Type, COUNT(Type) FROM operate_company AS T1 JOIN flight AS t2 ON T1.id = T2.company_id GROUP BY Type ORDER BY COUNT(Type) DESC
SELECT "Type", COUNT("Type") FROM "operate_company" "T1" JOIN "flight" "t2" ON "T1"."id" = "T2"."company_id" GROUP BY "Type" ORDER BY COUNT("Type") DESC