CREATE TABLE Flight (origin VARCHAR)

Show all origins and the number of flights from each origin.
SELECT origin, COUNT(*) FROM Flight GROUP BY origin
SELECT "origin", COUNT(*) FROM "Flight" GROUP BY "origin"