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)
CREATE TABLE employee (eid NUMBER, name VARCHAR2, salary NUMBER)

Draw a bar chart of destination versus the total number, sort Y in asc order.
SELECT destination, COUNT(*) FROM flight GROUP BY destination ORDER BY COUNT(*)
SELECT "destination", COUNT(*) FROM "flight" GROUP BY "destination" ORDER BY COUNT(*)