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

A bar chart showing the number of flights with price higher than 300 for each destination city, show from low to high by the bar.
SELECT destination, COUNT(destination) FROM flight WHERE price > 300 GROUP BY destination ORDER BY destination
SELECT "destination", COUNT("destination") FROM "flight" WHERE "price" > 300 GROUP BY "destination" ORDER BY "destination"