text: CREATE TABLE Catalogs (date_of_latest_revision VARCHAR) -- Find the dates on which more than one revisions were made. SELECT date_of_latest_revision FROM Catalogs GROUP BY date_of_latest_revision HAVING COUNT(*) > 1 CREATE TABLE catalog_contents (Id VARCHAR) -- How many products are there in the records? SELECT COUNT(*) FROM catalog_contents CREATE TABLE catalog_contents (catalog_entry_name VARCHAR, next_entry_id INTEGER) -- Name all the products with next entry ID greater than 8. SELECT catalog_entry_name FROM catalog_contents WHERE next_entry_id > 8 CREATE TABLE Aircraft (Id VARCHAR) -- How many aircrafts do we have? SELECT COUNT(*) FROM Aircraft CREATE TABLE Aircraft (name VARCHAR, distance VARCHAR) -- Show name and distance for all aircrafts. SELECT name, distance FROM Aircraft CREATE TABLE Aircraft (aid VARCHAR, distance INTEGER) -- Show ids for all aircrafts with more than 1000 distance. SELECT aid FROM Aircraft WHERE distance > 1000 CREATE TABLE Aircraft (distance INTEGER) -- How many aircrafts have distance between 1000 and 5000? SELECT COUNT(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000 CREATE TABLE Aircraft (name VARCHAR, distance VARCHAR, aid VARCHAR) -- What is the name and distance for aircraft with id 12? SELECT name, distance FROM Aircraft WHERE aid = 12 CREATE TABLE Aircraft (distance INTEGER) -- What is the minimum, average, and maximum distance of all aircrafts. SELECT MIN(distance), AVG(distance), MAX(distance) FROM Aircraft