How many flights with price higher than 300 for each destination city? Return a bar chart, and order in ascending by the total number.
CREATE TABLE employee (
    eid number(9,0),
    name varchar2(30),
    salary number(10,2)
)

CREATE TABLE certificate (
    eid number(9,0),
    aid number(9,0)
)

CREATE TABLE flight (
    flno number(4,0),
    origin varchar2(20),
    destination varchar2(20),
    distance number(6,0),
    departure_date date,
    arrival_date date,
    price number(7,2),
    aid number(9,0)
)

CREATE TABLE aircraft (
    aid number(9,0),
    name varchar2(30),
    distance number(6,0)
)
SELECT destination, COUNT(destination) FROM flight WHERE price > 300 GROUP BY destination ORDER BY COUNT(destination)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many flights with price higher than 300 for each destination city? Return a bar chart, and order in ascending by the total number. ### Input: CREATE TABLE employee (
    eid number(9,0),
    name varchar2(30),
    salary number(10,2)
)

CREATE TABLE certificate (
    eid number(9,0),
    aid number(9,0)
)

CREATE TABLE flight (
    flno number(4,0),
    origin varchar2(20),
    destination varchar2(20),
    distance number(6,0),
    departure_date date,
    arrival_date date,
    price number(7,2),
    aid number(9,0)
)

CREATE TABLE aircraft (
    aid number(9,0),
    name varchar2(30),
    distance number(6,0)
) ### Response: SELECT destination, COUNT(destination) FROM flight WHERE price > 300 GROUP BY destination ORDER BY COUNT(destination)