text: CREATE TABLE Aircraft (aid VARCHAR, name VARCHAR, distance VARCHAR) -- Show the id and name of the aircraft with the maximum distance. SELECT aid, name FROM Aircraft ORDER BY distance DESC LIMIT 1 CREATE TABLE Aircraft (name VARCHAR, distance VARCHAR) -- Show the name of aircrafts with top three lowest distances. SELECT name FROM Aircraft ORDER BY distance LIMIT 3 CREATE TABLE Aircraft (name VARCHAR, distance INTEGER) -- Show names for all aircrafts with distances more than the average. SELECT name FROM Aircraft WHERE distance > (SELECT AVG(distance) FROM Aircraft) CREATE TABLE Employee (Id VARCHAR) -- How many employees do we have? SELECT COUNT(*) FROM Employee CREATE TABLE Employee (name VARCHAR, salary VARCHAR) -- Show name and salary for all employees sorted by salary. SELECT name, salary FROM Employee ORDER BY salary CREATE TABLE Employee (eid VARCHAR, salary INTEGER) -- Show ids for all employees with at least 100000 salary. SELECT eid FROM Employee WHERE salary > 100000 CREATE TABLE Employee (salary INTEGER) -- How many employees have salary between 100000 and 200000? SELECT COUNT(*) FROM Employee WHERE salary BETWEEN 100000 AND 200000 CREATE TABLE Employee (name VARCHAR, salary VARCHAR, eid VARCHAR) -- What is the name and salary for employee with id 242518965? SELECT name, salary FROM Employee WHERE eid = 242518965 CREATE TABLE Employee (salary INTEGER) -- What is average and maximum salary of all employees. SELECT AVG(salary), MAX(salary) FROM Employee