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

Show the number of flights in each destination city with a bar chart, I want to order in desc by the Y.
SELECT destination, COUNT(destination) FROM flight GROUP BY destination ORDER BY COUNT(destination) DESC
SELECT "destination", COUNT("destination") FROM "flight" GROUP BY "destination" ORDER BY COUNT("destination") DESC