text: CREATE TABLE Flight (flno VARCHAR, distance INTEGER) -- Show flight number for all flights with more than 2000 distance. SELECT flno FROM Flight WHERE distance > 2000 CREATE TABLE Flight (price INTEGER, origin VARCHAR, destination VARCHAR) -- What is the average price for flights from Los Angeles to Honolulu. SELECT AVG(price) FROM Flight WHERE origin = "Los Angeles" AND destination = "Honolulu" CREATE TABLE Flight (origin VARCHAR, destination VARCHAR, price INTEGER) -- Show origin and destination for flights with price higher than 300. SELECT origin, destination FROM Flight WHERE price > 300 CREATE TABLE Flight (flno VARCHAR, distance VARCHAR, price VARCHAR) -- Show the flight number and distance of the flight with maximum price. SELECT flno, distance FROM Flight ORDER BY price DESC LIMIT 1 CREATE TABLE Flight (flno VARCHAR, distance VARCHAR) -- Show the flight number of flights with three lowest distances. SELECT flno FROM Flight ORDER BY distance LIMIT 3 CREATE TABLE Flight (distance INTEGER, price INTEGER, origin VARCHAR) -- What is the average distance and average price for flights from Los Angeles. SELECT AVG(distance), AVG(price) FROM Flight WHERE origin = "Los Angeles" CREATE TABLE Flight (origin VARCHAR) -- Show all origins and the number of flights from each origin. SELECT origin, COUNT(*) FROM Flight GROUP BY origin CREATE TABLE Flight (destination VARCHAR) -- Show all destinations and the number of flights to each destination. SELECT destination, COUNT(*) FROM Flight GROUP BY destination