For each origin, how many flights came from there?
CREATE TABLE certificate (
    eid number,
    aid number
)

CREATE TABLE aircraft (
    aid number,
    name text,
    distance number
)

CREATE TABLE employee (
    eid number,
    name text,
    salary number
)

CREATE TABLE flight (
    flno number,
    origin text,
    destination text,
    distance number,
    departure_date time,
    arrival_date time,
    price number,
    aid number
)
SELECT origin, COUNT(*) FROM flight GROUP BY origin
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: For each origin, how many flights came from there? ### Input: CREATE TABLE certificate (
    eid number,
    aid number
)

CREATE TABLE aircraft (
    aid number,
    name text,
    distance number
)

CREATE TABLE employee (
    eid number,
    name text,
    salary number
)

CREATE TABLE flight (
    flno number,
    origin text,
    destination text,
    distance number,
    departure_date time,
    arrival_date time,
    price number,
    aid number
) ### Response: SELECT origin, COUNT(*) FROM flight GROUP BY origin