CREATE TABLE employee (eid NUMBER, name VARCHAR2, salary NUMBER)
CREATE TABLE aircraft (aid NUMBER, name VARCHAR2, distance NUMBER)
CREATE TABLE flight (flno NUMBER, origin VARCHAR2, destination VARCHAR2, distance NUMBER, departure_date DATE, arrival_date DATE, price NUMBER, aid NUMBER)
CREATE TABLE certificate (eid NUMBER, aid NUMBER)

Show all origins and the number of flights from each origin Show bar chart, and rank in desc by the x axis.
SELECT origin, COUNT(*) FROM flight GROUP BY origin ORDER BY origin DESC
SELECT "origin", COUNT(*) FROM "flight" GROUP BY "origin" ORDER BY "origin" DESC