CREATE TABLE employee (eid DECIMAL, name TEXT, salary DECIMAL)
CREATE TABLE aircraft (aid DECIMAL, name TEXT, distance DECIMAL)
CREATE TABLE flight (flno DECIMAL, origin TEXT, destination TEXT, distance DECIMAL, departure_date TIME, arrival_date TIME, price DECIMAL, aid DECIMAL)
CREATE TABLE certificate (eid DECIMAL, aid DECIMAL)

Show all destinations and the number of flights to each destination.
SELECT destination, COUNT(*) FROM flight GROUP BY destination
SELECT "destination", COUNT(*) FROM "flight" GROUP BY "destination"