SELECT Count(*) FROM stadium SELECT Count(*) FROM stadium SELECT singer.Name, singer.Country, singer.Age FROM singer ORDER BY singer.Age Desc SELECT singer.Name, singer.Country, singer.Age FROM singer ORDER BY singer.Age Desc SELECT Avg(singer.Age), Min(singer.Age), Max(singer.Age) FROM singer WHERE singer.Country = 'terminal' SELECT Avg(singer.Age), Min(singer.Age), Max(singer.Age) FROM singer WHERE singer.Country = 'terminal' SELECT singer.Name, singer.Song_release_year FROM singer ORDER BY singer.Age Asc LIMIT 1 SELECT singer.Name, singer.Song_release_year FROM singer ORDER BY singer.Age Asc LIMIT 1 SELECT DISTINCT singer.Country FROM singer WHERE singer.Age > 'terminal' SELECT DISTINCT singer.Country FROM singer WHERE singer.Age > 'terminal' SELECT singer.Country, Count(*) FROM singer GROUP BY singer.Country SELECT singer.Country, Count(*) FROM singer GROUP BY singer.Country SELECT singer.Song_Name FROM singer WHERE singer.Age > (SELECT Avg(singer.Age) FROM singer) SELECT singer.Name FROM singer WHERE singer.Age > (SELECT Avg(singer.Age) FROM singer) SELECT stadium.Location, stadium.Name FROM stadium WHERE stadium.Capacity BETWEEN 'terminal' AND 'terminal' SELECT stadium.Location, stadium.Name FROM stadium WHERE stadium.Capacity BETWEEN 'terminal' AND 'terminal' SELECT Max(stadium.Capacity), Avg(stadium.Capacity) FROM stadium SELECT Avg(stadium.Capacity), Max(stadium.Capacity) FROM stadium SELECT stadium.Name, stadium.Capacity FROM stadium GROUP BY stadium.Stadium_ID ORDER BY Avg(stadium.Average) Desc LIMIT 1 SELECT stadium.Name, stadium.Capacity FROM stadium GROUP BY stadium.Stadium_ID ORDER BY Avg(stadium.Average) Desc LIMIT 1 SELECT Count(*) FROM concert WHERE concert.Year = 'terminal' OR concert.Year = 'terminal' SELECT Count(*) FROM concert WHERE concert.Year = 'terminal' OR concert.Year = 'terminal' SELECT stadium.Name, Count(*) FROM stadium JOIN concert GROUP BY concert.Stadium_ID SELECT stadium.Stadium_ID, Count(*) FROM stadium JOIN concert GROUP BY stadium.Stadium_ID SELECT stadium.Name, stadium.Capacity FROM stadium JOIN concert WHERE stadium.Highest >= 'terminal' GROUP BY concert.Stadium_ID ORDER BY Count(*) Desc LIMIT 1 SELECT stadium.Name, stadium.Capacity FROM stadium JOIN concert WHERE concert.Year > 'terminal' GROUP BY concert.Stadium_ID ORDER BY Count(*) Desc LIMIT 1 SELECT concert.Year FROM concert GROUP BY concert.Year ORDER BY Count(*) Desc LIMIT 1 SELECT concert.Year FROM concert GROUP BY concert.Year ORDER BY Count(*) Desc LIMIT 1 SELECT stadium.Name FROM stadium WHERE stadium.Stadium_ID NOT IN (SELECT concert.Stadium_ID FROM concert) SELECT stadium.Name FROM stadium WHERE stadium.Stadium_ID NOT IN (SELECT concert.Stadium_ID FROM concert) SELECT singer.Country FROM singer WHERE singer.Age > 'terminal' INTERSECT SELECT singer.Country FROM singer WHERE singer.Age < 'terminal' SELECT stadium.Name FROM stadium EXCEPT SELECT stadium.Name FROM stadium JOIN concert WHERE concert.Year = 'terminal' SELECT stadium.Name FROM stadium EXCEPT SELECT stadium.Name FROM stadium JOIN concert WHERE concert.Year = 'terminal' SELECT concert.concert_Name, concert.Theme, Count(*) FROM singer_in_concert JOIN concert GROUP BY singer_in_concert.concert_ID SELECT concert.Theme, concert.concert_Name, Count(*) FROM singer_in_concert JOIN concert GROUP BY singer_in_concert.concert_ID SELECT singer.Name, Count(*) FROM singer_in_concert JOIN singer GROUP BY singer.Name SELECT concert.concert_Name, Count(*) FROM singer_in_concert JOIN singer GROUP BY singer.Name SELECT singer.Name FROM singer JOIN concert WHERE concert.Year = 'terminal' SELECT singer.Name FROM singer JOIN concert WHERE concert.Year = 'terminal' SELECT singer.Name, singer.Country FROM singer WHERE singer.Song_Name LIKE 'terminal' SELECT singer.Name, singer.Country FROM singer WHERE singer.Song_Name LIKE 'terminal' SELECT stadium.Name, stadium.Location FROM stadium JOIN concert WHERE concert.Year = 'terminal' INTERSECT SELECT stadium.Name, stadium.Location FROM stadium JOIN concert WHERE concert.Year = 'terminal' SELECT stadium.Name, stadium.Location FROM stadium JOIN concert WHERE concert.Year = 'terminal' INTERSECT SELECT stadium.Name, stadium.Location FROM stadium JOIN concert WHERE concert.Year = 'terminal' SELECT Count(*) FROM stadium WHERE stadium.Capacity = (SELECT Max(stadium.Capacity) FROM stadium) SELECT stadium.Capacity FROM stadium ORDER BY stadium.Capacity Desc LIMIT 1 SELECT Count(*) FROM Pets WHERE Pets.weight > 'terminal' SELECT Count(*) FROM Pets WHERE Pets.weight > 'terminal' SELECT Pets.weight FROM Has_Pet JOIN Pets JOIN Student WHERE Student.Age = (SELECT Min(Student.Age) FROM Student) SELECT Student.Age FROM Student WHERE Student.Age = (SELECT Min(Student.Age) FROM Student) SELECT Max(Pets.weight), Pets.PetType FROM Pets GROUP BY Pets.PetType SELECT Max(Pets.weight), Min(Pets.weight), Pets.PetType FROM Pets GROUP BY Pets.PetType SELECT Count(*) FROM Has_Pet JOIN Student JOIN Pets WHERE Student.Age > 'terminal' SELECT Count(*) FROM Has_Pet JOIN Student WHERE Student.Age > 'terminal' SELECT Count(*) FROM Student JOIN Has_Pet WHERE Student.Sex = 'terminal' SELECT Count(*) FROM Has_Pet JOIN Student WHERE Student.Sex = 'terminal' SELECT Count(DISTINCT Pets.PetType) FROM Pets SELECT Count(DISTINCT Pets.PetType) FROM Pets SELECT Student.Fname FROM Student JOIN Has_Pet JOIN Pets WHERE Has_Pet.PetID = 'terminal' OR Pets.PetType = 'terminal' SELECT Student.Fname FROM Has_Pet JOIN Pets JOIN Student WHERE Student.city_code = 'terminal' OR Pets.PetType = 'terminal' SELECT Student.Fname FROM Has_Pet JOIN Student INTERSECT SELECT Student.Fname FROM Has_Pet JOIN Student SELECT Student.Fname FROM Has_Pet JOIN Pets JOIN Student WHERE Pets.PetType = 'terminal' INTERSECT SELECT Student.Fname FROM Has_Pet JOIN Pets JOIN Student WHERE Pets.PetType = 'terminal' SELECT Student.Major, Student.Age FROM Student WHERE Student.StuID NOT IN (SELECT Has_Pet.StuID FROM Has_Pet) SELECT Student.Major, Student.Age FROM Student WHERE Student.StuID NOT IN (SELECT Has_Pet.StuID FROM Has_Pet) SELECT Student.StuID FROM Student EXCEPT SELECT Has_Pet.StuID FROM Has_Pet SELECT Student.StuID FROM Student EXCEPT SELECT Has_Pet.StuID FROM Has_Pet SELECT Student.Fname, Student.Age FROM Student WHERE Student.StuID NOT IN (SELECT Has_Pet.StuID FROM Has_Pet) SELECT Student.Fname FROM Student WHERE Student.StuID IN (SELECT Has_Pet.StuID FROM Has_Pet) EXCEPT SELECT Student.Fname FROM Student JOIN Has_Pet JOIN Pets SELECT Pets.PetType, Pets.weight FROM Has_Pet JOIN Pets JOIN Student WHERE Student.Age = (SELECT Max(Student.Age) FROM Student) SELECT Pets.PetType, Pets.weight FROM Has_Pet JOIN Pets JOIN Student ORDER BY Student.Age Asc LIMIT 1 SELECT Pets.PetID, Pets.weight FROM Has_Pet JOIN Student JOIN Pets WHERE Student.Age > 'terminal' SELECT Pets.PetID, Pets.weight FROM Pets WHERE Pets.pet_age > 'terminal' SELECT Avg(Student.Age), Max(Student.Age), Max(Pets.weight) FROM Has_Pet JOIN Student JOIN Pets SELECT Avg(Student.Age), Max(Student.Age), Max(Student.Age) FROM Student SELECT Pets.PetType, Avg(Pets.weight) FROM Pets GROUP BY Pets.PetType SELECT Avg(Pets.weight), Pets.PetType FROM Pets GROUP BY Pets.PetType SELECT Student.Fname, Student.Age FROM Student JOIN Has_Pet SELECT DISTINCT Student.Fname, Student.Age FROM Has_Pet JOIN Student JOIN Pets SELECT Has_Pet.PetID FROM Has_Pet JOIN Student JOIN Pets WHERE Student.LName = 'terminal' SELECT Has_Pet.PetID FROM Has_Pet JOIN Student WHERE Student.LName = 'terminal' SELECT Count(*), Has_Pet.StuID FROM Has_Pet GROUP BY Has_Pet.StuID SELECT Count(*), Has_Pet.StuID FROM Has_Pet GROUP BY Has_Pet.StuID SELECT Student.Fname, Student.Sex FROM Has_Pet JOIN Student GROUP BY Has_Pet.StuID HAVING Count(*) > 'terminal' SELECT Student.Fname, Student.Sex FROM Has_Pet JOIN Student GROUP BY Has_Pet.StuID HAVING Count(*) > 'terminal' SELECT Student.LName FROM Student WHERE Student.StuID IN (SELECT Has_Pet.StuID FROM Has_Pet WHERE Student.Age = 'terminal') SELECT Student.LName FROM Student WHERE Student.StuID IN (SELECT Has_Pet.StuID FROM Has_Pet JOIN Pets WHERE Pets.pet_age = 'terminal') SELECT Avg(Student.Age) FROM Student WHERE Student.StuID NOT IN (SELECT Has_Pet.StuID FROM Has_Pet) SELECT Avg(Student.Age) FROM Student WHERE Student.StuID NOT IN (SELECT Has_Pet.StuID FROM Has_Pet) SELECT Count(*) FROM countries SELECT Count(*) FROM continents SELECT countries.CountryId, countries.CountryName, Count(*) FROM countries GROUP BY countries.CountryId SELECT countries.CountryId, countries.CountryName, Count(*) FROM countries GROUP BY countries.CountryId SELECT Count(*) FROM countries SELECT Count(*) FROM countries SELECT countries.CountryName, countries.CountryName, Count(*) FROM model_list JOIN countries GROUP BY countries.CountryName SELECT car_makers.FullName, car_makers.FullName, Count(*) FROM model_list JOIN car_makers GROUP BY car_makers.Id SELECT model_list.Model FROM cars_data JOIN model_list ORDER BY cars_data.Accelerate Asc LIMIT 1 SELECT model_list.Model FROM model_list JOIN cars_data ORDER BY cars_data.Accelerate Asc LIMIT 1 SELECT model_list.Model FROM model_list WHERE cars_data.Weight < (SELECT Avg(cars_data.Weight) FROM cars_data) SELECT model_list.Model FROM model_list WHERE cars_data.Weight < (SELECT Avg(cars_data.Weight) FROM cars_data) SELECT countries.CountryName FROM cars_data JOIN countries WHERE cars_data.Year = 'terminal' SELECT DISTINCT continents.Continent FROM cars_data JOIN continents WHERE cars_data.Year = 'terminal' SELECT countries.CountryName, cars_data.Accelerate FROM cars_data JOIN countries ORDER BY cars_data.Year Asc LIMIT 1 SELECT continents.Continent, cars_data.Year FROM cars_data JOIN continents ORDER BY cars_data.Year Asc LIMIT 1 SELECT DISTINCT model_list.Model FROM model_list JOIN cars_data WHERE cars_data.Year > 'terminal' SELECT DISTINCT model_list.Model FROM model_list JOIN cars_data WHERE cars_data.Year > 'terminal' SELECT countries.CountryName, Count(*) FROM car_makers JOIN countries GROUP BY car_makers.Country SELECT countries.CountryName, Count(*) FROM countries JOIN car_makers GROUP BY car_makers.Country SELECT countries.CountryName FROM countries GROUP BY countries.CountryName ORDER BY Count(*) Desc LIMIT 1 SELECT countries.CountryName FROM countries JOIN car_makers GROUP BY car_makers.Country ORDER BY Count(*) Desc LIMIT 1 SELECT Count(*), countries.CountryName FROM car_names JOIN countries GROUP BY countries.CountryName SELECT Count(*), car_makers.Id, car_makers.FullName FROM model_list JOIN car_makers GROUP BY car_makers.Id SELECT cars_data.MPG FROM car_names JOIN cars_data WHERE car_names.Make = 'terminal' SELECT cars_data.MPG FROM car_names JOIN cars_data WHERE car_names.Make = 'terminal' SELECT Count(*) FROM car_makers WHERE car_makers.Country = 'terminal' SELECT Count(*) FROM countries WHERE countries.CountryName = 'terminal' SELECT Count(DISTINCT model_list.Model) FROM model_list JOIN car_makers WHERE car_makers.Country = 'terminal' SELECT Count(DISTINCT model_list.Model) FROM model_list JOIN car_makers WHERE car_makers.Country = 'terminal' SELECT Avg(cars_data.MPG) FROM cars_data JOIN car_names WHERE car_names.Make LIKE 'terminal' SELECT Avg(cars_data.Cylinders), cars_data.Cylinders FROM cars_data WHERE cars_data.Horsepower = 'terminal' GROUP BY cars_data.Cylinders SELECT cars_data.Weight FROM cars_data WHERE cars_data.Year = 'terminal' SELECT Min(cars_data.Weight) FROM cars_data WHERE cars_data.Year = 'terminal' SELECT DISTINCT car_makers.Maker, model_list.Model FROM model_list JOIN car_makers SELECT car_makers.FullName, model_list.Model FROM model_list JOIN car_makers SELECT countries.CountryName, countries.CountryId FROM countries JOIN continents GROUP BY countries.CountryId HAVING Count(*) >= 'terminal' SELECT countries.CountryName, countries.CountryId FROM countries JOIN continents GROUP BY countries.CountryName HAVING Count(*) >= 'terminal' SELECT Count(*) FROM cars_data WHERE cars_data.Horsepower > 'terminal' SELECT Count(*) FROM cars_data WHERE cars_data.Horsepower > 'terminal' SELECT Avg(cars_data.Weight), cars_data.Year FROM cars_data GROUP BY cars_data.Year SELECT Avg(cars_data.Horsepower), cars_data.Year FROM cars_data GROUP BY cars_data.Year SELECT car_makers.Country FROM car_makers GROUP BY car_makers.Country HAVING Count(*) >= 'terminal' SELECT countries.CountryName FROM countries JOIN car_makers GROUP BY countries.CountryName HAVING Count(*) >= 'terminal' SELECT Max(cars_data.Horsepower), Max(cars_data.Accelerate) FROM cars_data SELECT Max(cars_data.Cylinders), countries.CountryName FROM car_makers JOIN countries GROUP BY countries.CountryName SELECT car_names.Model FROM cars_data JOIN car_names ORDER BY cars_data.Cylinders Desc LIMIT 1 SELECT model_list.Model FROM model_list JOIN cars_data ORDER BY cars_data.MPG Desc LIMIT 1 SELECT Avg(cars_data.Horsepower) FROM cars_data WHERE cars_data.Year < 'terminal' SELECT Avg(cars_data.Horsepower) FROM cars_data WHERE cars_data.Year < 'terminal' SELECT Avg(cars_data.Edispl) FROM model_list JOIN cars_data WHERE model_list.Model = 'terminal' SELECT Avg(cars_data.Edispl) FROM cars_data SELECT Max(cars_data.Horsepower), cars_data.Weight FROM cars_data GROUP BY cars_data.Weight SELECT Max(cars_data.Accelerate), cars_data.Weight FROM cars_data GROUP BY cars_data.Weight SELECT model_list.Model, Count(*) FROM model_list GROUP BY model_list.Model ORDER BY Count(*) Desc LIMIT 1 SELECT model_list.Model FROM model_list GROUP BY model_list.Model ORDER BY Count(*) Desc LIMIT 1 SELECT Count(*) FROM model_list WHERE model_list.ModelId > 'terminal' SELECT Count(*) FROM model_list WHERE model_list.ModelId > 'terminal' SELECT Count(*) FROM cars_data WHERE cars_data.Year = 'terminal' SELECT Count(*) FROM cars_data WHERE cars_data.Year = 'terminal' SELECT Count(*) FROM car_makers JOIN model_list WHERE car_makers.FullName = 'terminal' SELECT Count(*) FROM model_list JOIN car_makers WHERE car_makers.FullName = 'terminal' SELECT car_makers.FullName, car_makers.Id FROM model_list JOIN car_makers GROUP BY car_makers.Id HAVING Count(*) > 'terminal' SELECT car_makers.FullName, car_makers.Id FROM model_list JOIN car_makers GROUP BY model_list.Maker HAVING Count(*) > 'terminal' SELECT DISTINCT cars_data.MPG FROM continents JOIN countries WHERE car_makers.FullName = 'terminal' OR continents.Continent > 'terminal' SELECT model_list.Model FROM model_list JOIN car_makers JOIN cars_data WHERE car_makers.FullName = 'terminal' OR cars_data.Horsepower > 'terminal' SELECT cars_data.Year FROM cars_data WHERE cars_data.Horsepower < 'terminal' INTERSECT SELECT cars_data.Year FROM cars_data WHERE cars_data.Weight > 'terminal' SELECT DISTINCT cars_data.Year FROM cars_data WHERE cars_data.Horsepower < 'terminal' INTERSECT SELECT cars_data.Year FROM cars_data WHERE cars_data.Weight > 'terminal' SELECT cars_data.Accelerate FROM cars_data ORDER BY cars_data.Accelerate Desc LIMIT 1 SELECT cars_data.Horsepower FROM cars_data ORDER BY cars_data.Accelerate Desc LIMIT 1 SELECT model_list.Model, Count(*) FROM car_names JOIN model_list GROUP BY model_list.Model ORDER BY Count(*) Asc LIMIT 1 SELECT Count(*), car_makers.FullName FROM car_names JOIN car_makers GROUP BY car_makers.FullName ORDER BY Count(*) Asc LIMIT 1 SELECT Count(*) FROM cars_data WHERE cars_data.Cylinders > (SELECT Max(cars_data.Cylinders) FROM cars_data) SELECT Count(*) FROM cars_data WHERE cars_data.Cylinders > (SELECT Max(cars_data.Accelerate) FROM cars_data) SELECT Count(*) FROM car_makers SELECT Count(*) FROM (SELECT car_makers.Country FROM car_makers GROUP BY car_makers.Country HAVING Count(*) > 'terminal') SELECT Count(*) FROM car_makers WHERE car_makers.FullName > 'terminal' SELECT Count(*) FROM model_list WHERE model_list.ModelId > 'terminal' SELECT model_list.Model FROM cars_data WHERE cars_data.Cylinders = (SELECT Max(cars_data.Accelerate) FROM cars_data) SELECT model_list.Model FROM cars_data WHERE cars_data.Cylinders = (SELECT Max(cars_data.Accelerate) FROM cars_data) SELECT car_makers.Maker FROM car_makers WHERE cars_data.Weight > (SELECT Min(cars_data.Weight) FROM cars_data) SELECT car_makers.Id, continents.Continent FROM continents WHERE car_makers.Id NOT IN (SELECT cars_data.Id FROM cars_data WHERE cars_data.Horsepower < 'terminal') SELECT Max(cars_data.Cylinders) FROM cars_data WHERE cars_data.Year > 'terminal' OR cars_data.Year < 'terminal' SELECT Max(cars_data.MPG) FROM cars_data WHERE cars_data.Year = 'terminal' OR cars_data.Year < 'terminal' SELECT cars_data.Weight FROM cars_data WHERE cars_data.Weight < (SELECT Max(cars_data.Weight) FROM car_makers WHERE car_makers.FullName = 'terminal') SELECT DISTINCT cars_data.Weight FROM cars_data WHERE cars_data.Weight < (SELECT Max(cars_data.Weight) FROM car_makers WHERE car_makers.FullName = 'terminal') SELECT countries.CountryName FROM countries EXCEPT SELECT countries.CountryName FROM countries SELECT countries.CountryName FROM countries WHERE countries.CountryId NOT IN (SELECT car_makers.Country FROM car_makers) SELECT continents.ContId, continents.Continent FROM continents GROUP BY continents.ContId HAVING Count(*) >= 'terminal' INTERSECT SELECT continents.ContId, continents.Continent FROM model_list JOIN countries GROUP BY continents.ContId HAVING Count(*) >= 'terminal' SELECT car_makers.Id, car_makers.Country FROM continents GROUP BY car_makers.Id HAVING Count(*) > 'terminal' INTERSECT SELECT car_makers.Id, car_makers.Country FROM model_list GROUP BY model_list.ModelId HAVING Count(*) > 'terminal' SELECT countries.CountryId, countries.CountryName FROM countries JOIN car_makers WHERE countries.CountryId > 'terminal' OR countries.CountryName > 'terminal' SELECT countries.CountryId, countries.CountryName FROM countries JOIN model_list GROUP BY countries.CountryId HAVING Count(*) > 'terminal' UNION SELECT countries.CountryId, countries.CountryName FROM countries JOIN car_makers WHERE model_list.Model = 'terminal' SELECT airlines.Country FROM airlines WHERE airlines.Airline = 'terminal' SELECT airlines.Country FROM airlines WHERE airlines.Airline = 'terminal' SELECT airports.AirportName FROM airlines JOIN airports WHERE airlines.Airline = 'terminal' SELECT airlines.Airline FROM airlines WHERE airlines.Airline = 'terminal' SELECT airlines.Airline, airlines.Airline FROM airlines WHERE airlines.Country = 'terminal' SELECT airlines.Airline, airlines.Airline FROM airlines WHERE airlines.Country = 'terminal' SELECT airports.AirportCode, airports.AirportName FROM airports WHERE airports.City = 'terminal' SELECT airports.AirportCode, airports.AirportName FROM airports WHERE airports.City = 'terminal' SELECT Count(*) FROM airlines SELECT Count(*) FROM airlines SELECT Count(*) FROM airports SELECT Count(*) FROM airports SELECT Count(*) FROM flights SELECT Count(*) FROM flights SELECT airlines.Airline FROM airlines WHERE airlines.Airline LIKE 'terminal' SELECT airlines.Airline FROM airlines WHERE airlines.Airline = 'terminal' SELECT Count(*) FROM airlines WHERE airlines.Country = 'terminal' SELECT Count(*) FROM airlines WHERE airlines.Country = 'terminal' SELECT airports.City, airports.Country FROM airports WHERE airports.AirportName = 'terminal' SELECT airports.City, airports.Country FROM airports WHERE airports.AirportName = 'terminal' SELECT airports.AirportName FROM airports WHERE airports.AirportCode = 'terminal' SELECT airports.AirportName FROM airports WHERE airports.AirportCode = 'terminal' SELECT airports.AirportName FROM airports WHERE airports.City = 'terminal' SELECT airports.AirportName FROM airports WHERE airports.City = 'terminal' SELECT Count(*) FROM flights WHERE flights.SourceAirport = 'terminal' SELECT Count(*) FROM flights WHERE flights.SourceAirport = 'terminal' SELECT Count(*) FROM flights WHERE flights.DestAirport = 'terminal' SELECT Count(*) FROM flights WHERE flights.DestAirport = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' AND airports.City = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' AND airports.City = 'terminal' SELECT Count(*) FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' SELECT Count(*) FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' SELECT Count(*) FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' AND flights.SourceAirport = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.AirportName = 'terminal' AND airports.AirportCode = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.AirportName = 'terminal' AND flights.SourceAirport = 'terminal' SELECT Count(*) FROM airports JOIN flights JOIN airlines WHERE airlines.Airline = 'terminal' AND airports.AirportName = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' AND airports.City = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' AND airports.City = 'terminal' SELECT airports.City FROM airports JOIN flights GROUP BY airports.City ORDER BY Count(*) Desc LIMIT 1 SELECT airports.City FROM airports JOIN flights GROUP BY airports.City ORDER BY Count(*) Desc LIMIT 1 SELECT airports.City FROM airports JOIN flights GROUP BY airports.City ORDER BY Count(*) Desc LIMIT 1 SELECT airports.City FROM airports GROUP BY airports.City ORDER BY Count(*) Desc LIMIT 1 SELECT airports.AirportCode FROM airports JOIN flights GROUP BY flights.SourceAirport ORDER BY Count(*) Desc LIMIT 1 SELECT flights.SourceAirport FROM flights GROUP BY flights.SourceAirport ORDER BY Count(*) Desc LIMIT 1 SELECT airports.AirportCode FROM airports JOIN flights GROUP BY flights.SourceAirport ORDER BY Count(*) Asc LIMIT 1 SELECT airports.AirportCode FROM airports JOIN flights GROUP BY flights.SourceAirport ORDER BY Count(*) Asc LIMIT 1 SELECT airlines.Airline FROM airlines JOIN flights GROUP BY airlines.Airline ORDER BY Count(*) Desc LIMIT 1 SELECT airlines.Airline FROM airlines JOIN flights GROUP BY airlines.Airline ORDER BY Count(*) Desc LIMIT 1 SELECT airlines.Airline, airlines.Country FROM airlines JOIN flights GROUP BY airlines.Airline ORDER BY Count(*) Asc LIMIT 1 SELECT airports.AirportName, airports.Country FROM airports WHERE airports.AirportName = 'terminal' SELECT airlines.Airline FROM airlines JOIN flights WHERE flights.SourceAirport = 'terminal' SELECT airlines.Airline FROM airlines JOIN airports WHERE airports.AirportCode = 'terminal' SELECT airlines.Airline FROM airlines JOIN flights WHERE flights.SourceAirport = 'terminal' SELECT airlines.Airline FROM airlines JOIN airports WHERE airports.AirportCode = 'terminal' SELECT airlines.Airline FROM airlines JOIN airports JOIN flights WHERE airports.AirportCode = 'terminal' INTERSECT SELECT airlines.Airline FROM airlines JOIN airports WHERE airports.AirportCode = 'terminal' SELECT airlines.Airline FROM airlines JOIN flights JOIN airports WHERE airports.AirportCode = 'terminal' INTERSECT SELECT airlines.Airline FROM airlines JOIN airports WHERE airports.AirportCode = 'terminal' SELECT airlines.Airline FROM airlines JOIN airports WHERE flights.SourceAirport = 'terminal' EXCEPT SELECT airlines.Airline FROM airlines JOIN flights WHERE flights.SourceAirport = 'terminal' SELECT airlines.Airline FROM airlines WHERE airports.City = 'terminal' EXCEPT SELECT airlines.Airline FROM airlines JOIN airports WHERE airports.City = 'terminal' SELECT airlines.Airline FROM airlines JOIN flights GROUP BY airlines.Airline HAVING Count(*) >= 'terminal' SELECT airlines.Airline FROM airlines JOIN flights GROUP BY airlines.Airline HAVING Count(*) >= 'terminal' SELECT airlines.Airline FROM airlines WHERE airlines.Abbreviation < 'terminal' SELECT airlines.Airline FROM airlines GROUP BY airlines.Airline HAVING airlines.Abbreviation < 'terminal' SELECT flights.FlightNo FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' SELECT flights.FlightNo FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' SELECT flights.FlightNo FROM flights WHERE flights.SourceAirport = 'terminal' SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.City = 'terminal' SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.AirportName = 'terminal' SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.AirportName = 'terminal' SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.City = 'terminal' SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.City = 'terminal' SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.City = 'terminal' SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.City = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' OR airports.City = 'terminal' SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' OR flights.Airline = 'terminal' SELECT airports.AirportName FROM airports EXCEPT SELECT airports.AirportName FROM airports JOIN flights SELECT airports.AirportName FROM airports EXCEPT SELECT airports.AirportName FROM airports JOIN flights WHERE flights.FlightNo = 'terminal' SELECT Count(*) FROM employee SELECT Count(*) FROM employee SELECT employee.Name FROM employee ORDER BY employee.Age Asc SELECT employee.Name FROM employee ORDER BY employee.Age Asc SELECT employee.City, Count(*) FROM employee GROUP BY employee.City SELECT Count(*), employee.City FROM employee GROUP BY employee.City SELECT employee.City FROM employee WHERE employee.Age > (SELECT Min(employee.Age) FROM employee) SELECT employee.City FROM employee WHERE employee.Age < 'terminal' GROUP BY employee.City ORDER BY Count(*) Desc LIMIT 1 SELECT shop.Location, Count(*) FROM shop GROUP BY shop.Location SELECT shop.Location, Count(*) FROM shop GROUP BY shop.Location SELECT shop.Manager_name, shop.District FROM shop GROUP BY shop.Shop_ID ORDER BY shop.Number_products Desc LIMIT 1 SELECT shop.Manager_name, shop.District FROM shop JOIN hiring GROUP BY shop.Shop_ID ORDER BY Count(*) Desc LIMIT 1 SELECT Min(shop.Number_products), Max(shop.Number_products) FROM shop SELECT Min(shop.Number_products), Max(shop.Number_products) FROM shop SELECT shop.Name, shop.Location, shop.District FROM shop ORDER BY shop.Number_products Desc SELECT shop.Name, shop.Location, shop.District FROM shop ORDER BY shop.Number_products Desc SELECT shop.Name FROM shop WHERE shop.Number_products > (SELECT Avg(shop.Number_products) FROM shop) SELECT shop.Name FROM shop WHERE shop.Number_products > (SELECT Avg(shop.Number_products) FROM shop) SELECT employee.Name FROM employee JOIN evaluation ORDER BY evaluation.Year_awarded Desc LIMIT 1 SELECT employee.Name FROM employee JOIN hiring GROUP BY hiring.Employee_ID ORDER BY Count(*) Desc LIMIT 1 SELECT employee.Name FROM employee JOIN evaluation ORDER BY evaluation.Bonus Desc LIMIT 1 SELECT employee.Name FROM employee JOIN evaluation ORDER BY evaluation.Bonus Desc LIMIT 1 SELECT employee.Name FROM employee WHERE employee.Employee_ID NOT IN (SELECT evaluation.Employee_ID FROM evaluation) SELECT employee.Name FROM employee WHERE employee.Employee_ID NOT IN (SELECT evaluation.Employee_ID FROM evaluation) SELECT shop.Name FROM shop JOIN hiring GROUP BY hiring.Shop_ID ORDER BY Count(*) Desc LIMIT 1 SELECT shop.Name FROM shop ORDER BY shop.Number_products Desc LIMIT 1 SELECT shop.Name FROM shop WHERE shop.Shop_ID NOT IN (SELECT hiring.Shop_ID FROM hiring) SELECT shop.Name FROM shop WHERE shop.Shop_ID NOT IN (SELECT hiring.Shop_ID FROM hiring) SELECT Count(*), employee.Employee_ID FROM employee JOIN hiring GROUP BY employee.Employee_ID SELECT Count(*), shop.Name FROM shop JOIN hiring GROUP BY shop.Shop_ID SELECT Sum(evaluation.Bonus) FROM evaluation SELECT Sum(evaluation.Bonus) FROM evaluation SELECT * FROM employee SELECT * FROM employee SELECT shop.District FROM shop WHERE shop.Number_products < 'terminal' INTERSECT SELECT shop.District FROM shop WHERE shop.Number_products > 'terminal' SELECT shop.District FROM shop WHERE shop.Number_products < 'terminal' INTERSECT SELECT shop.District FROM shop WHERE shop.Number_products > 'terminal' SELECT Count(DISTINCT shop.Location) FROM shop SELECT Count(DISTINCT shop.Location) FROM shop SELECT Count(*) FROM Documents SELECT Count(*) FROM Documents SELECT Documents.Document_ID, Documents.Document_Name, Documents.Document_Description FROM Documents SELECT Documents.Document_ID, Documents.Document_Name, Documents.Document_Description FROM Documents SELECT Documents.Document_Name, Documents.Document_ID FROM Documents WHERE Documents.Document_Description LIKE 'terminal' SELECT Documents.Document_Name, Documents.Document_ID FROM Documents WHERE Documents.Document_Description LIKE 'terminal' SELECT Documents.Document_ID, Documents.Template_ID, Documents.Document_Description FROM Documents WHERE Documents.Document_Name = 'terminal' SELECT Documents.Document_ID, Documents.Template_ID, Documents.Document_Description FROM Documents WHERE Documents.Document_Name = 'terminal' SELECT Count(DISTINCT Documents.Document_Description) FROM Documents SELECT Count(DISTINCT Documents.Document_Name) FROM Documents SELECT Count(*) FROM Documents JOIN Templates WHERE Templates.Template_Type_Code = 'terminal' SELECT Count(*) FROM Documents JOIN Templates WHERE Templates.Template_Type_Code = 'terminal' SELECT Documents.Template_ID, Count(*) FROM Documents GROUP BY Documents.Template_ID SELECT Documents.Template_ID, Count(*) FROM Documents GROUP BY Documents.Template_ID SELECT Templates.Template_Type_Code, Templates.Template_Type_Code FROM Documents JOIN Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Desc LIMIT 1 SELECT Documents.Template_ID, Templates.Template_Type_Code FROM Documents JOIN Templates GROUP BY Documents.Template_ID ORDER BY Count(*) Desc LIMIT 1 SELECT Documents.Template_ID FROM Documents GROUP BY Documents.Template_ID HAVING Count(*) > 'terminal' SELECT Documents.Template_ID FROM Documents GROUP BY Documents.Template_ID HAVING Count(*) > 'terminal' SELECT Templates.Template_ID FROM Templates EXCEPT SELECT Documents.Template_ID FROM Documents SELECT Templates.Template_ID FROM Templates EXCEPT SELECT Documents.Template_ID FROM Documents SELECT Count(*) FROM Templates SELECT Count(*) FROM Documents SELECT Templates.Template_ID, Templates.Version_Number, Templates.Template_Type_Code FROM Templates SELECT Templates.Template_ID, Templates.Version_Number, Templates.Template_Type_Code FROM Templates SELECT DISTINCT Templates.Template_Type_Code FROM Templates SELECT Ref_Template_Types.Template_Type_Code FROM Ref_Template_Types SELECT Templates.Template_ID FROM Templates WHERE Templates.Template_Type_Code = 'terminal' OR Templates.Template_Type_Code = 'terminal' SELECT Templates.Template_ID FROM Templates WHERE Templates.Template_Type_Code = 'terminal' OR Templates.Template_Type_Code = 'terminal' SELECT Count(*) FROM Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Code = 'terminal' SELECT Count(*) FROM Templates WHERE Templates.Template_Type_Code = 'terminal' SELECT Templates.Version_Number, Templates.Template_Type_Code FROM Templates WHERE Templates.Date_Effective_To > 'terminal' SELECT Templates.Version_Number, Templates.Template_Type_Code FROM Templates WHERE Templates.Template_Type_Code > 'terminal' SELECT Templates.Template_Type_Code, Count(*) FROM Templates GROUP BY Templates.Template_Type_Code SELECT Templates.Template_Type_Code, Count(*) FROM Templates GROUP BY Templates.Template_Type_Code SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Desc LIMIT 1 SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Desc LIMIT 1 SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code HAVING Count(*) < 'terminal' SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code HAVING Count(*) < 'terminal' SELECT Templates.Version_Number, Templates.Template_Type_Code FROM Templates ORDER BY Templates.Version_Number Asc LIMIT 1 SELECT Templates.Version_Number, Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Asc LIMIT 1 SELECT Templates.Template_Type_Code FROM Documents JOIN Templates WHERE Documents.Document_Name = 'terminal' SELECT Templates.Template_Type_Code FROM Documents JOIN Templates WHERE Documents.Document_Name = 'terminal' SELECT Documents.Document_Name FROM Documents JOIN Templates WHERE Templates.Template_Type_Code = 'terminal' SELECT Documents.Document_Name FROM Documents JOIN Templates WHERE Templates.Template_Type_Code = 'terminal' SELECT Templates.Template_Type_Code, Count(*) FROM Documents JOIN Templates GROUP BY Templates.Template_Type_Code SELECT Templates.Template_Type_Code, Count(*) FROM Templates GROUP BY Templates.Template_Type_Code SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Desc LIMIT 1 SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Desc LIMIT 1 SELECT Templates.Template_Type_Code FROM Templates EXCEPT SELECT Templates.Template_Type_Code FROM Templates SELECT Templates.Template_Type_Code FROM Templates EXCEPT SELECT Templates.Template_Type_Code FROM Templates SELECT Ref_Template_Types.Template_Type_Code, Ref_Template_Types.Template_Type_Description FROM Ref_Template_Types SELECT Ref_Template_Types.Template_Type_Code, Ref_Template_Types.Template_Type_Description FROM Ref_Template_Types SELECT Ref_Template_Types.Template_Type_Description FROM Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Code = 'terminal' SELECT Ref_Template_Types.Template_Type_Description FROM Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Code = 'terminal' SELECT Ref_Template_Types.Template_Type_Code FROM Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Description = 'terminal' SELECT Ref_Template_Types.Template_Type_Code FROM Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Description = 'terminal' SELECT DISTINCT Ref_Template_Types.Template_Type_Description FROM Ref_Template_Types JOIN Templates SELECT DISTINCT Documents.Document_Description FROM Documents SELECT Ref_Template_Types.Template_Type_Code FROM Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Description = 'terminal' SELECT Documents.Template_ID FROM Documents WHERE Documents.Document_Description = 'terminal' SELECT Count(*) FROM Documents SELECT Count(*) FROM Documents SELECT Count(*) FROM Documents WHERE Documents.Document_Name = 'terminal' SELECT Count(*) FROM Documents WHERE Documents.Document_Name = 'terminal' SELECT Templates.Template_Details FROM Documents JOIN Templates WHERE Documents.Document_Name LIKE 'terminal' SELECT Templates.Template_Details FROM Documents JOIN Templates WHERE Documents.Document_Name LIKE 'terminal' SELECT Documents.Document_ID, Templates.Template_Details FROM Documents JOIN Templates WHERE Documents.Document_Name = 'terminal' SELECT Documents.Document_ID, Documents.Template_ID FROM Documents WHERE Documents.Document_Name = 'terminal' SELECT Documents.Document_Description FROM Documents WHERE Documents.Document_Name = 'terminal' SELECT Documents.Document_Description FROM Documents JOIN Paragraphs WHERE Documents.Document_Name = 'terminal' SELECT Documents.Document_ID, Count(*) FROM Paragraphs JOIN Documents GROUP BY Documents.Document_ID SELECT Documents.Document_ID, Count(*) FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID ORDER BY Count(*) Asc SELECT Documents.Document_ID, Documents.Document_Name, Documents.Document_Name FROM Documents JOIN Paragraphs SELECT Documents.Document_ID, Documents.Document_Name, Count(*) FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID SELECT Documents.Document_ID FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID HAVING Count(*) >= 'terminal' SELECT Documents.Document_ID FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID HAVING Count(*) >= 'terminal' SELECT Documents.Document_ID, Documents.Document_Name FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID ORDER BY Count(*) Desc LIMIT 1 SELECT Documents.Document_ID, Documents.Document_Name FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID ORDER BY Count(*) Desc LIMIT 1 SELECT Documents.Document_ID FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID ORDER BY Count(*) Asc LIMIT 1 SELECT Documents.Document_ID FROM Paragraphs JOIN Documents GROUP BY Paragraphs.Document_ID ORDER BY Count(*) Asc LIMIT 1 SELECT Documents.Document_ID FROM Documents GROUP BY Documents.Document_ID HAVING Count(*) BETWEEN 'terminal' AND 'terminal' SELECT Documents.Document_ID FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID HAVING Count(*) BETWEEN 'terminal' AND 'terminal' SELECT Documents.Document_ID FROM Documents WHERE Documents.Document_Name LIKE 'terminal' INTERSECT SELECT Documents.Document_ID FROM Documents JOIN Paragraphs WHERE Documents.Document_Name LIKE 'terminal' SELECT Documents.Document_ID FROM Documents WHERE Documents.Document_Name LIKE 'terminal' INTERSECT SELECT Documents.Document_ID FROM Documents WHERE Documents.Document_Name LIKE 'terminal' SELECT Count(*) FROM teacher SELECT Count(*) FROM teacher SELECT teacher.Name FROM teacher ORDER BY teacher.Age Asc SELECT teacher.Name FROM teacher ORDER BY teacher.Age Asc SELECT teacher.Age, teacher.Hometown FROM teacher SELECT teacher.Age, teacher.Hometown FROM teacher SELECT teacher.Name FROM teacher WHERE teacher.Hometown != 'terminal' SELECT teacher.Name FROM teacher WHERE teacher.Hometown != 'terminal' SELECT teacher.Name FROM teacher WHERE teacher.Age = 'terminal' OR teacher.Age = 'terminal' SELECT teacher.Name FROM teacher WHERE teacher.Age = 'terminal' OR teacher.Age = 'terminal' SELECT teacher.Hometown FROM teacher ORDER BY teacher.Age Asc LIMIT 1 SELECT teacher.Hometown FROM teacher WHERE teacher.Age = (SELECT Min(teacher.Age) FROM teacher) SELECT teacher.Hometown, Count(*) FROM teacher GROUP BY teacher.Hometown SELECT teacher.Hometown, Count(*) FROM teacher GROUP BY teacher.Hometown SELECT teacher.Hometown FROM teacher GROUP BY teacher.Hometown ORDER BY Count(*) Desc LIMIT 1 SELECT teacher.Hometown FROM teacher GROUP BY teacher.Hometown ORDER BY Count(*) Desc LIMIT 1 SELECT teacher.Hometown FROM teacher GROUP BY teacher.Hometown HAVING Count(*) >= 'terminal' SELECT teacher.Hometown FROM teacher GROUP BY teacher.Hometown HAVING Count(*) >= 'terminal' SELECT teacher.Name, course.Course FROM course_arrange JOIN course JOIN teacher SELECT teacher.Name, course.Course FROM course_arrange JOIN teacher JOIN course SELECT teacher.Name, course.Course FROM course_arrange JOIN teacher JOIN course ORDER BY teacher.Name Asc SELECT teacher.Name, course.Course FROM course_arrange JOIN course JOIN teacher ORDER BY teacher.Name Asc SELECT teacher.Name FROM course_arrange JOIN teacher WHERE course_arrange.Grade = 'terminal' SELECT teacher.Name FROM course_arrange JOIN teacher WHERE course_arrange.Grade = 'terminal' SELECT teacher.Name, Count(*) FROM course_arrange JOIN teacher GROUP BY course_arrange.Teacher_ID SELECT teacher.Name, Count(*) FROM course_arrange JOIN teacher GROUP BY course_arrange.Teacher_ID SELECT teacher.Name FROM course_arrange JOIN teacher GROUP BY course_arrange.Teacher_ID HAVING Count(*) >= 'terminal' SELECT teacher.Name FROM course_arrange JOIN teacher GROUP BY course_arrange.Teacher_ID HAVING Count(*) >= 'terminal' SELECT teacher.Name FROM teacher WHERE teacher.Teacher_ID NOT IN (SELECT course_arrange.Teacher_ID FROM course_arrange) SELECT teacher.Name FROM teacher WHERE teacher.Teacher_ID NOT IN (SELECT course_arrange.Teacher_ID FROM course_arrange) SELECT Count(*) FROM visitor WHERE visitor.Age < 'terminal' SELECT visitor.Name FROM visitor WHERE visitor.Level_of_membership > 'terminal' ORDER BY visitor.Level_of_membership Asc SELECT Avg(visitor.Age) FROM visitor WHERE visitor.ID NOT IN (SELECT visit.visitor_ID FROM visit GROUP BY visit.visitor_ID HAVING Max(visitor.Level_of_membership) > 'terminal') SELECT visitor.Name, visitor.Age FROM visitor WHERE visitor.Age > 'terminal' ORDER BY visitor.Age Asc SELECT museum.Museum_ID, museum.Name FROM museum ORDER BY museum.Num_of_Staff Desc LIMIT 1 SELECT Avg(museum.Num_of_Staff) FROM museum WHERE museum.Open_Year < 'terminal' SELECT museum.Open_Year, museum.Num_of_Staff FROM museum WHERE museum.Name = 'terminal' SELECT museum.Name FROM museum WHERE museum.Num_of_Staff > (SELECT Min(museum.Num_of_Staff) FROM museum WHERE museum.Open_Year > 'terminal') SELECT visitor.ID, visitor.Name, visitor.Age FROM visitor JOIN visit GROUP BY visitor.ID HAVING Count(*) > 'terminal' SELECT visit.visitor_ID, visitor.Name, Sum(visit.Total_spent) FROM visit JOIN visitor GROUP BY visit.visitor_ID ORDER BY Sum(visit.Total_spent) Desc LIMIT 1 SELECT museum.Museum_ID, museum.Name FROM visit JOIN museum GROUP BY visit.Museum_ID ORDER BY Count(*) Desc LIMIT 1 SELECT museum.Name FROM museum WHERE museum.Museum_ID NOT IN (SELECT visit.Museum_ID FROM visit) SELECT visitor.Name, visitor.Age FROM visitor JOIN visit GROUP BY visit.visitor_ID ORDER BY Count(*) Desc LIMIT 1 SELECT Avg(visit.Num_of_Ticket), Max(visit.Total_spent) FROM visit SELECT Sum(visit.Total_spent) FROM visit WHERE visit.Museum_ID = 'terminal' SELECT museum.Name FROM museum WHERE museum.Open_Year < 'terminal' INTERSECT SELECT museum.Name FROM museum WHERE museum.Open_Year > 'terminal' SELECT Count(*) FROM museum WHERE museum.Museum_ID NOT IN (SELECT museum.Museum_ID FROM museum WHERE museum.Open_Year > 'terminal') SELECT Count(*) FROM museum WHERE museum.Open_Year > 'terminal' OR museum.Open_Year < 'terminal' SELECT Count(*) FROM players SELECT Count(*) FROM players SELECT Count(*) FROM players SELECT Count(*) FROM players SELECT players.first_name, players.birth_date FROM players WHERE players.country_code = 'terminal' SELECT players.first_name, players.birth_date FROM players WHERE players.country_code = 'terminal' SELECT Avg(matches.winner_age), matches.loser_age FROM matches SELECT Avg(matches.winner_age), matches.loser_age FROM matches SELECT Avg(matches.score) FROM matches SELECT Avg(matches.score) FROM matches SELECT rankings.ranking FROM rankings SELECT matches.score FROM matches SELECT Count(DISTINCT players.country_code) FROM players SELECT Count(DISTINCT players.country_code) FROM players SELECT Count(DISTINCT players.first_name) FROM players SELECT Count(DISTINCT players.first_name) FROM players SELECT matches.winner_name FROM matches GROUP BY matches.winner_name HAVING Count(*) > 'terminal' SELECT rankings.tours FROM rankings JOIN matches GROUP BY rankings.tours HAVING Count(*) > 'terminal' SELECT players.first_name FROM players JOIN matches WHERE matches.year = 'terminal' UNION SELECT matches.winner_name FROM matches WHERE matches.year = 'terminal' SELECT players.first_name FROM players JOIN matches WHERE matches.year LIKE 'terminal' UNION SELECT players.first_name FROM players JOIN matches WHERE matches.year = 'terminal' SELECT Count(*) FROM matches WHERE matches.year = 'terminal' OR matches.year = 'terminal' SELECT Count(*) FROM matches WHERE matches.year = 'terminal' OR matches.year = 'terminal' SELECT players.country_code, matches.loser_name FROM players JOIN matches WHERE matches.tourney_name = 'terminal' INTERSECT SELECT players.country_code, matches.loser_name FROM players JOIN matches WHERE matches.tourney_name = 'terminal' SELECT players.first_name, players.country_code FROM players JOIN matches WHERE matches.tourney_name = 'terminal' INTERSECT SELECT players.first_name, players.country_code FROM players JOIN matches WHERE players.last_name = 'terminal' SELECT players.first_name, players.country_code FROM players JOIN matches ORDER BY matches.year Asc LIMIT 1 SELECT players.first_name, players.country_code FROM players JOIN matches ORDER BY matches.year Asc LIMIT 1 SELECT players.first_name, players.last_name FROM players ORDER BY players.birth_date Asc SELECT players.first_name, players.last_name FROM players ORDER BY players.birth_date Asc SELECT players.first_name, players.last_name FROM players WHERE players.hand = 'terminal' ORDER BY players.birth_date Asc SELECT players.first_name, players.birth_date FROM players WHERE players.country_code = 'terminal' ORDER BY players.birth_date Asc SELECT players.first_name, players.country_code FROM players JOIN matches GROUP BY matches.loser_id ORDER BY Count(*) Desc LIMIT 1 SELECT players.first_name, players.country_code FROM players JOIN matches GROUP BY matches.winner_id ORDER BY Count(*) Desc LIMIT 1 SELECT matches.year FROM matches GROUP BY matches.year ORDER BY Count(*) Desc LIMIT 1 SELECT matches.year FROM matches GROUP BY matches.year ORDER BY Count(*) Desc LIMIT 1 SELECT players.first_name, matches.score FROM players JOIN matches GROUP BY matches.winner_id ORDER BY Count(*) Desc LIMIT 1 SELECT players.first_name, matches.score FROM players JOIN matches GROUP BY matches.loser_id ORDER BY Count(*) Desc LIMIT 1 SELECT players.first_name FROM matches JOIN players ORDER BY matches.score Desc LIMIT 1 SELECT matches.winner_name FROM players JOIN matches WHERE players.last_name = 'terminal' ORDER BY matches.minutes Desc LIMIT 1 SELECT players.first_name, matches.winner_name FROM matches JOIN players ORDER BY matches.minutes Desc LIMIT 1 SELECT players.first_name, players.last_name FROM matches JOIN players ORDER BY matches.minutes Desc LIMIT 1 SELECT Avg(matches.score), players.first_name FROM matches JOIN players GROUP BY players.first_name SELECT players.first_name, Avg(matches.score) FROM rankings JOIN players GROUP BY rankings.player_id SELECT Sum(matches.minutes), players.first_name FROM matches JOIN players GROUP BY players.first_name SELECT players.first_name, rankings.ranking_points FROM rankings JOIN players SELECT Count(*), players.country_code FROM players GROUP BY players.country_code SELECT players.country_code, Count(*) FROM players GROUP BY players.country_code SELECT players.country_code FROM players GROUP BY players.country_code ORDER BY Count(*) Desc LIMIT 1 SELECT players.country_code FROM players GROUP BY players.country_code ORDER BY Count(*) Desc LIMIT 1 SELECT players.country_code FROM players GROUP BY players.country_code HAVING Count(*) > 'terminal' SELECT players.country_code FROM players GROUP BY players.country_code HAVING Count(*) > 'terminal' SELECT Count(*), matches.score FROM matches GROUP BY matches.score SELECT Sum(rankings.tours), rankings.ranking FROM rankings GROUP BY rankings.ranking SELECT Count(*), matches.year FROM matches GROUP BY matches.year SELECT matches.year, Count(*) FROM matches GROUP BY matches.year SELECT matches.winner_name, matches.score FROM matches ORDER BY matches.loser_age Asc LIMIT 1 SELECT players.first_name, matches.score FROM players JOIN matches ORDER BY matches.loser_age Asc LIMIT 1 SELECT Count(DISTINCT players.player_id) FROM players WHERE players.first_name = 'terminal' SELECT Count(*) FROM players JOIN matches WHERE players.country_code = 'terminal' SELECT matches.winner_name, players.country_code, players.birth_date FROM matches JOIN players ORDER BY matches.score Desc LIMIT 1 SELECT players.first_name, players.country_code, matches.minutes FROM players JOIN matches ORDER BY matches.minutes Desc LIMIT 1 SELECT Count(*), players.country_code FROM players GROUP BY players.country_code SELECT players.country_code, Count(*) FROM players GROUP BY players.country_code SELECT Count(*) FROM ship SELECT ship.name, ship.tonnage FROM ship ORDER BY ship.name Desc SELECT battle.name, battle.date, battle.result FROM battle SELECT Max(death.killed), Min(death.killed), death.note FROM death GROUP BY death.note SELECT Avg(death.injured), death.caused_by_ship_id FROM death GROUP BY death.caused_by_ship_id SELECT battle.name, ship.disposition_of_ship FROM ship JOIN battle WHERE ship.tonnage = 'terminal' SELECT battle.name, battle.result FROM battle WHERE battle.bulgarian_commander != 'terminal' SELECT DISTINCT battle.id, battle.name FROM battle JOIN ship WHERE ship.ship_type = 'terminal' SELECT ship.id, battle.name FROM death JOIN battle JOIN ship WHERE death.killed > 'terminal' SELECT ship.id, ship.name FROM ship JOIN death GROUP BY ship.id ORDER BY death.injured Desc LIMIT 1 SELECT DISTINCT battle.name FROM battle WHERE battle.bulgarian_commander = 'terminal' AND battle.latin_commander = 'terminal' SELECT Count(DISTINCT battle.result) FROM battle SELECT Count(*) FROM ship WHERE ship.tonnage != 'terminal' SELECT battle.name, battle.date FROM ship JOIN battle WHERE ship.name = 'terminal' INTERSECT SELECT battle.name, battle.date FROM ship JOIN battle WHERE ship.name = 'terminal' SELECT battle.name, battle.result, battle.bulgarian_commander FROM battle WHERE battle.bulgarian_commander != 'terminal' SELECT death.killed FROM death WHERE death.killed LIKE 'terminal' SELECT Addresses.address_id, Addresses.zip_postcode FROM Addresses SELECT Addresses.line_1, Addresses.line_3 FROM Addresses SELECT Count(*) FROM Courses SELECT Count(*) FROM Courses SELECT Courses.course_description FROM Courses WHERE Courses.course_name = 'terminal' SELECT Courses.course_description FROM Courses WHERE Courses.course_name = 'terminal' SELECT Addresses.zip_postcode FROM Addresses WHERE Addresses.city = 'terminal' SELECT Addresses.zip_postcode FROM Addresses WHERE Addresses.city = 'terminal' SELECT Departments.department_name, Departments.department_id FROM Departments JOIN Courses GROUP BY Departments.department_id ORDER BY Count(*) Desc LIMIT 1 SELECT Departments.department_name, Degree_Programs.department_id FROM Departments JOIN Degree_Programs GROUP BY Degree_Programs.department_id ORDER BY Count(*) Desc LIMIT 1 SELECT Count(DISTINCT Degree_Programs.department_id) FROM Degree_Programs SELECT Count(DISTINCT Departments.department_name) FROM Departments SELECT Count(DISTINCT Degree_Programs.degree_summary_name) FROM Degree_Programs SELECT Count(DISTINCT Courses.course_name) FROM Courses SELECT Count(*) FROM Courses JOIN Departments WHERE Departments.department_name = 'terminal' SELECT Count(*) FROM Departments JOIN Degree_Programs WHERE Departments.department_name = 'terminal' SELECT Courses.course_name, Courses.course_description FROM Courses SELECT Courses.course_name, Courses.course_description FROM Courses SELECT Courses.course_name, Courses.course_id FROM Courses JOIN Sections GROUP BY Courses.course_id HAVING Count(*) <= 'terminal' SELECT Courses.course_name, Courses.course_id FROM Courses JOIN Sections GROUP BY Courses.course_id HAVING Count(*) < 'terminal' SELECT Sections.section_name FROM Sections WHERE Sections.section_name = 'terminal' ORDER BY Sections.section_name Asc SELECT Departments.department_name FROM Departments ORDER BY Departments.department_name Asc SELECT Students.first_name, Student_Enrolment.degree_program_id FROM Student_Enrolment JOIN Students GROUP BY Student_Enrolment.degree_program_id ORDER BY Count(*) Desc LIMIT 1 SELECT Courses.course_name, Student_Enrolment.degree_program_id FROM Courses JOIN Student_Enrolment GROUP BY Student_Enrolment.degree_program_id ORDER BY Count(*) Desc LIMIT 1 SELECT Departments.department_description FROM Departments WHERE Departments.department_name LIKE 'terminal' SELECT Departments.department_description FROM Departments WHERE Departments.department_name LIKE 'terminal' SELECT Students.first_name, Students.middle_name, Student_Enrolment.student_id FROM Students JOIN Student_Enrolment GROUP BY Student_Enrolment.student_id SELECT Students.first_name, Students.middle_name, Student_Enrolment.student_id FROM Students JOIN Student_Enrolment GROUP BY Student_Enrolment.student_id SELECT Students.first_name, Students.middle_name, Students.last_name FROM Courses JOIN Students WHERE Courses.course_name = 'terminal' SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students JOIN Student_Enrolment WHERE Students.ssn = (SELECT Max(Students.ssn) FROM Students) SELECT Degree_Programs.degree_summary_name FROM Student_Enrolment JOIN Degree_Programs GROUP BY Student_Enrolment.degree_program_id ORDER BY Count(*) Desc LIMIT 1 SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses GROUP BY Courses.course_id ORDER BY Count(*) Desc LIMIT 1 SELECT Courses.course_id, Courses.course_description FROM Courses JOIN Student_Enrolment_Courses GROUP BY Courses.course_id ORDER BY Count(*) Desc LIMIT 1 SELECT Student_Enrolment_Courses.course_id, Courses.course_name FROM Courses JOIN Student_Enrolment_Courses GROUP BY Student_Enrolment_Courses.course_id ORDER BY Count(*) Desc LIMIT 1 SELECT Student_Enrolment.student_enrolment_id, Students.middle_name, Students.middle_name, Student_Enrolment.student_enrolment_id FROM Students JOIN Student_Enrolment GROUP BY Student_Enrolment.student_enrolment_id ORDER BY Count(*) Desc LIMIT 1 SELECT Students.first_name, Students.middle_name, Student_Enrolment.student_id FROM Students JOIN Student_Enrolment GROUP BY Students.student_id ORDER BY Count(*) Desc LIMIT 1 SELECT Courses.course_name FROM Courses WHERE Departments.department_id NOT IN (SELECT Student_Enrolment.degree_program_id FROM Student_Enrolment) SELECT Courses.course_name FROM Semesters EXCEPT SELECT Student_Enrolment.semester_id FROM Student_Enrolment SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses GROUP BY Courses.course_id ORDER BY Count(*) Desc LIMIT 1 SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses GROUP BY Courses.course_id ORDER BY Count(*) Desc LIMIT 1 SELECT Students.last_name FROM Addresses JOIN Students WHERE Addresses.state_province_county = 'terminal' EXCEPT SELECT Students.last_name FROM Addresses JOIN Students WHERE Addresses.state_province_county = 'terminal' SELECT Students.last_name FROM Students EXCEPT SELECT Students.last_name FROM Addresses JOIN Students WHERE Addresses.state_province_county = 'terminal' SELECT Transcripts.transcript_date, Courses.course_id FROM Courses JOIN Transcripts GROUP BY Courses.course_name HAVING Count(*) >= 'terminal' SELECT Transcripts.transcript_date, Courses.course_id FROM Courses JOIN Transcripts GROUP BY Courses.course_id HAVING Count(*) >= 'terminal' SELECT Students.cell_mobile_number FROM Students WHERE Students.first_name = 'terminal' AND Students.last_name = 'terminal' SELECT Students.cell_mobile_number FROM Students WHERE Students.first_name = 'terminal' AND Students.last_name = 'terminal' SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students ORDER BY Students.ssn Asc LIMIT 1 SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students ORDER BY Students.date_first_registered Asc LIMIT 1 SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students ORDER BY Students.date_left Asc LIMIT 1 SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students ORDER BY Students.date_left Asc LIMIT 1 SELECT DISTINCT Students.first_name FROM Students SELECT Students.first_name FROM Students WHERE Students.email_address = 'terminal' SELECT Addresses.address_id, Students.email_address FROM Addresses JOIN Students GROUP BY Addresses.address_id ORDER BY Count(*) Desc LIMIT 1 SELECT Addresses.address_id, Addresses.line_2, Addresses.city FROM Addresses JOIN Students GROUP BY Students.current_address_id ORDER BY Count(*) Desc LIMIT 1 SELECT Avg(Transcripts.transcript_date) FROM Transcripts SELECT Avg(Transcripts.transcript_date) FROM Transcripts SELECT Transcripts.transcript_date, Transcripts.other_details FROM Transcripts ORDER BY Transcripts.transcript_date Asc LIMIT 1 SELECT Transcripts.transcript_date, Transcripts.other_details FROM Transcripts SELECT Count(*) FROM Transcripts SELECT Count(*) FROM Transcripts SELECT Transcripts.transcript_date FROM Transcripts ORDER BY Transcripts.transcript_date Desc LIMIT 1 SELECT Students.date_first_registered FROM Students ORDER BY Students.date_first_registered Desc LIMIT 1 SELECT Count(*), Student_Enrolment.degree_program_id FROM Student_Enrolment JOIN Student_Enrolment_Courses GROUP BY Student_Enrolment_Courses.course_id SELECT Count(*), Student_Enrolment_Courses.course_id FROM Courses JOIN Student_Enrolment_Courses GROUP BY Student_Enrolment_Courses.course_id SELECT Transcripts.transcript_date, Transcripts.transcript_id FROM Transcripts GROUP BY Transcripts.transcript_date ORDER BY Count(*) Asc LIMIT 1 SELECT Transcripts.transcript_date, Transcripts.transcript_id FROM Transcripts JOIN Transcript_Contents GROUP BY Transcript_Contents.transcript_id ORDER BY Count(*) Asc LIMIT 1 SELECT Students.date_left FROM Courses JOIN Students WHERE Student_Enrolment_Courses.course_id = 'terminal' INTERSECT SELECT Students.date_left FROM Courses JOIN Student_Enrolment_Courses WHERE Student_Enrolment_Courses.course_id = 'terminal' SELECT Courses.course_id FROM Courses JOIN Student_Enrolment_Courses WHERE Courses.course_name = 'terminal' INTERSECT SELECT Student_Enrolment_Courses.course_id FROM Student_Enrolment_Courses WHERE Student_Enrolment_Courses.student_enrolment_id = 'terminal' SELECT Count(DISTINCT Students.email_address) FROM Students SELECT DISTINCT Addresses.zip_postcode FROM Addresses JOIN Students SELECT Student_Enrolment.other_details FROM Student_Enrolment WHERE Student_Enrolment.other_details = 'terminal' ORDER BY Student_Enrolment.other_details Asc SELECT Students.other_student_details FROM Students ORDER BY Students.other_student_details Asc SELECT Courses.course_description FROM Courses SELECT Courses.course_description FROM Courses WHERE Courses.course_name = 'terminal' SELECT Students.first_name FROM Students JOIN Addresses WHERE Addresses.country = 'terminal' OR Students.cell_mobile_number = 'terminal' SELECT Students.first_name FROM Addresses JOIN Students WHERE Addresses.country = 'terminal' OR Students.cell_mobile_number = 'terminal' SELECT Cartoon.Title FROM Cartoon ORDER BY Cartoon.Title Asc SELECT Cartoon.Title FROM Cartoon ORDER BY Cartoon.Title Asc SELECT Cartoon.Title FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' SELECT Cartoon.Title FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' SELECT Count(*) FROM Cartoon WHERE Cartoon.Written_by = 'terminal' SELECT Count(*) FROM Cartoon WHERE Cartoon.Written_by = 'terminal' SELECT Cartoon.Title, Cartoon.Directed_by FROM Cartoon ORDER BY Cartoon.Original_air_date Asc SELECT Cartoon.Title, Cartoon.Directed_by FROM Cartoon JOIN TV_series SELECT Cartoon.Title FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' OR Cartoon.Directed_by = 'terminal' SELECT Cartoon.Title FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' OR Cartoon.Directed_by = 'terminal' SELECT TV_Channel.Country, Count(*) FROM TV_Channel GROUP BY TV_Channel.Country ORDER BY Count(*) Desc LIMIT 1 SELECT TV_Channel.Country, Count(*) FROM TV_Channel GROUP BY TV_Channel.Country ORDER BY Count(*) Desc LIMIT 1 SELECT Count(DISTINCT TV_Channel.Content), TV_Channel.Content FROM TV_Channel SELECT Count(DISTINCT TV_Channel.Content), Count(DISTINCT TV_Channel.Content) FROM TV_Channel SELECT TV_Channel.Content FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' SELECT TV_Channel.Content FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' SELECT TV_Channel.Package_Option FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' SELECT TV_Channel.Hight_definition_TV FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' SELECT Count(*) FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' SELECT Count(*) FROM TV_Channel WHERE TV_Channel.Language = 'terminal' SELECT TV_Channel.Language, Count(*) FROM TV_Channel JOIN TV_series GROUP BY TV_Channel.Language ORDER BY Count(*) Asc LIMIT 1 SELECT TV_Channel.Language, Count(*) FROM TV_Channel GROUP BY TV_Channel.Language ORDER BY Count(*) Asc LIMIT 1 SELECT TV_Channel.Language, Count(*) FROM TV_Channel GROUP BY TV_Channel.Language SELECT TV_Channel.Language, Count(*) FROM TV_Channel GROUP BY TV_Channel.Language SELECT TV_Channel.series_name FROM TV_Channel JOIN Cartoon WHERE Cartoon.Title = 'terminal' SELECT TV_Channel.Content FROM Cartoon JOIN TV_Channel WHERE Cartoon.Title = 'terminal' SELECT Cartoon.Title FROM Cartoon JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' SELECT Cartoon.Title FROM Cartoon JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' SELECT TV_series.Rating FROM TV_series ORDER BY TV_series.Rating Asc SELECT TV_series.Rating FROM TV_series ORDER BY TV_series.Rating Asc SELECT TV_series.Channel, TV_series.Rating FROM TV_series ORDER BY TV_series.Rating Desc LIMIT 1 SELECT TV_series.Weekly_Rank, TV_series.Share FROM TV_series ORDER BY TV_series.Rating Desc LIMIT 1 SELECT Min(TV_series.Share), Max(TV_series.Share) FROM TV_series SELECT Max(TV_series.Share), Min(TV_series.Share) FROM TV_series SELECT TV_series.Air_Date FROM TV_series JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' SELECT TV_series.Air_Date FROM TV_series WHERE TV_series.Episode = 'terminal' SELECT TV_series.Rating FROM TV_series WHERE TV_series.Episode = 'terminal' SELECT TV_series.Rating FROM TV_series WHERE TV_series.Episode = 'terminal' SELECT TV_Channel.Language FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' SELECT TV_Channel.series_name FROM TV_series JOIN TV_Channel WHERE TV_series.Episode = 'terminal' SELECT TV_series.Episode FROM TV_Channel JOIN TV_series WHERE TV_Channel.series_name = 'terminal' SELECT TV_Channel.Hight_definition_TV FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' SELECT Count(*), Cartoon.Directed_by FROM Cartoon GROUP BY Cartoon.Directed_by SELECT Count(*), Cartoon.Directed_by FROM Cartoon GROUP BY Cartoon.Directed_by SELECT Cartoon.Production_code, Cartoon.Channel FROM Cartoon ORDER BY Cartoon.Original_air_date Desc LIMIT 1 SELECT Cartoon.Production_code, Cartoon.Channel FROM Cartoon ORDER BY Cartoon.Original_air_date Desc LIMIT 1 SELECT TV_Channel.Country, TV_Channel.series_name FROM TV_Channel WHERE TV_Channel.Hight_definition_TV = 'terminal' SELECT TV_Channel.series_name, TV_Channel.series_name FROM TV_Channel WHERE TV_Channel.Hight_definition_TV = 'terminal' SELECT TV_Channel.Country FROM Cartoon JOIN TV_Channel WHERE Cartoon.Written_by = 'terminal' SELECT TV_Channel.Country FROM Cartoon JOIN TV_Channel WHERE Cartoon.Written_by = 'terminal' SELECT TV_Channel.Hight_definition_TV FROM TV_Channel EXCEPT SELECT TV_Channel.Hight_definition_TV FROM TV_Channel JOIN Cartoon WHERE Cartoon.Written_by = 'terminal' SELECT TV_Channel.Country FROM TV_Channel EXCEPT SELECT TV_Channel.Country FROM TV_Channel JOIN Cartoon WHERE Cartoon.Written_by = 'terminal' SELECT TV_Channel.series_name, TV_Channel.Country FROM TV_Channel JOIN Cartoon WHERE Cartoon.Directed_by = 'terminal' AND Cartoon.Directed_by = 'terminal' SELECT TV_Channel.series_name, TV_Channel.Country FROM TV_Channel JOIN Cartoon WHERE Cartoon.Directed_by = 'terminal' AND Cartoon.Directed_by = 'terminal' SELECT TV_Channel.Pixel_aspect_ratio_PAR, TV_Channel.Country FROM TV_Channel WHERE TV_Channel.Language != 'terminal' SELECT TV_Channel.Pixel_aspect_ratio_PAR, TV_Channel.Country FROM TV_Channel WHERE TV_Channel.Language != 'terminal' SELECT TV_Channel.id FROM TV_Channel GROUP BY TV_Channel.id HAVING Count(*) > 'terminal' SELECT TV_Channel.id FROM TV_Channel GROUP BY TV_Channel.id HAVING Count(*) > 'terminal' SELECT TV_Channel.id FROM TV_Channel EXCEPT SELECT Cartoon.Channel FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' SELECT TV_Channel.id FROM TV_Channel EXCEPT SELECT Cartoon.Channel FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' SELECT TV_Channel.Hight_definition_TV FROM TV_Channel EXCEPT SELECT TV_Channel.Hight_definition_TV FROM Cartoon JOIN TV_Channel WHERE Cartoon.Directed_by = 'terminal' SELECT TV_Channel.Hight_definition_TV FROM TV_Channel EXCEPT SELECT TV_Channel.Hight_definition_TV FROM Cartoon JOIN TV_Channel WHERE Cartoon.Directed_by = 'terminal' SELECT Count(*) FROM poker_player SELECT Count(*) FROM poker_player SELECT poker_player.Money_Rank FROM poker_player ORDER BY poker_player.Earnings Desc SELECT poker_player.Money_Rank FROM poker_player ORDER BY poker_player.Best_Finish Desc SELECT poker_player.Final_Table_Made, poker_player.Final_Table_Made FROM poker_player SELECT poker_player.Final_Table_Made, poker_player.Final_Table_Made FROM poker_player SELECT Avg(poker_player.Money_Rank) FROM poker_player SELECT Avg(poker_player.Money_Rank) FROM poker_player SELECT poker_player.Money_Rank FROM poker_player ORDER BY poker_player.Earnings Desc LIMIT 1 SELECT poker_player.Money_Rank FROM poker_player ORDER BY poker_player.Earnings Desc LIMIT 1 SELECT Max(poker_player.Final_Table_Made) FROM poker_player WHERE poker_player.Best_Finish < 'terminal' SELECT Max(poker_player.Final_Table_Made) FROM poker_player WHERE poker_player.Best_Finish < 'terminal' SELECT people.Name FROM poker_player JOIN people SELECT people.Name FROM poker_player JOIN people SELECT people.Name FROM poker_player JOIN people WHERE poker_player.Best_Finish > 'terminal' SELECT people.Name FROM poker_player JOIN people WHERE poker_player.Best_Finish > 'terminal' SELECT people.Name FROM poker_player JOIN people ORDER BY poker_player.Earnings Asc SELECT people.Name FROM poker_player JOIN people ORDER BY poker_player.Best_Finish Asc SELECT people.Nationality FROM poker_player JOIN people ORDER BY poker_player.Earnings Asc LIMIT 1 SELECT people.Nationality FROM poker_player JOIN people ORDER BY poker_player.Earnings Asc LIMIT 1 SELECT poker_player.Money_Rank FROM poker_player JOIN people ORDER BY people.Height Desc LIMIT 1 SELECT poker_player.Money_Rank FROM poker_player JOIN people ORDER BY people.Height Desc LIMIT 1 SELECT Avg(poker_player.Money_Rank) FROM poker_player JOIN people WHERE people.Height > 'terminal' SELECT Avg(poker_player.Money_Rank) FROM poker_player JOIN people WHERE people.Height > 'terminal' SELECT people.Name FROM poker_player JOIN people ORDER BY poker_player.Earnings Desc SELECT people.Name FROM poker_player JOIN people ORDER BY poker_player.Earnings Desc SELECT people.Nationality, Count(*) FROM people GROUP BY people.Nationality SELECT people.Nationality, Count(*) FROM people GROUP BY people.Nationality SELECT people.Nationality FROM people GROUP BY people.Nationality ORDER BY Count(*) Desc LIMIT 1 SELECT people.Nationality FROM people GROUP BY people.Nationality SELECT people.Nationality FROM people GROUP BY people.Nationality HAVING Count(*) >= 'terminal' SELECT people.Nationality FROM people GROUP BY people.Nationality HAVING Count(*) >= 'terminal' SELECT people.Name, people.Birth_Date FROM people ORDER BY people.Name Asc SELECT people.Name, people.Birth_Date FROM people ORDER BY people.Name Asc SELECT people.Name FROM people WHERE people.Nationality != 'terminal' SELECT people.Name FROM people WHERE people.Nationality != 'terminal' SELECT people.Name FROM people EXCEPT SELECT people.Name FROM poker_player JOIN people WHERE poker_player.Poker_Player_ID = 'terminal' SELECT people.Name FROM people WHERE people.People_ID NOT IN (SELECT poker_player.People_ID FROM poker_player) SELECT Count(DISTINCT people.Nationality) FROM people SELECT Count(DISTINCT people.Nationality) FROM people SELECT Count(*) FROM AREA_CODE_STATE SELECT CONTESTANTS.contestant_number, CONTESTANTS.contestant_name FROM CONTESTANTS ORDER BY CONTESTANTS.contestant_name Desc SELECT VOTES.vote_id, VOTES.phone_number, VOTES.state FROM VOTES SELECT Max(AREA_CODE_STATE.area_code), Min(AREA_CODE_STATE.area_code) FROM AREA_CODE_STATE SELECT VOTES.vote_id FROM VOTES WHERE VOTES.state = 'terminal' SELECT VOTES.vote_id FROM CONTESTANTS JOIN VOTES WHERE CONTESTANTS.contestant_name != 'terminal' SELECT DISTINCT VOTES.state, VOTES.created FROM VOTES SELECT CONTESTANTS.contestant_number, CONTESTANTS.contestant_name FROM VOTES JOIN CONTESTANTS GROUP BY VOTES.contestant_number HAVING Count(*) >= 'terminal' SELECT Count(*), CONTESTANTS.contestant_name FROM CONTESTANTS JOIN VOTES ORDER BY VOTES.created Asc LIMIT 1 SELECT Count(*) FROM VOTES WHERE VOTES.state = 'terminal' OR VOTES.state = 'terminal' SELECT Count(*) FROM CONTESTANTS WHERE CONTESTANTS.contestant_number NOT IN (SELECT VOTES.vote_id FROM VOTES) SELECT AREA_CODE_STATE.area_code FROM VOTES JOIN AREA_CODE_STATE GROUP BY AREA_CODE_STATE.area_code ORDER BY Count(*) Desc LIMIT 1 SELECT VOTES.state, VOTES.state, VOTES.phone_number FROM CONTESTANTS JOIN VOTES WHERE CONTESTANTS.contestant_name = 'terminal' SELECT AREA_CODE_STATE.area_code FROM CONTESTANTS JOIN VOTES JOIN AREA_CODE_STATE WHERE CONTESTANTS.contestant_name = 'terminal' INTERSECT SELECT AREA_CODE_STATE.area_code FROM CONTESTANTS JOIN VOTES JOIN AREA_CODE_STATE WHERE CONTESTANTS.contestant_name = 'terminal' SELECT CONTESTANTS.contestant_name FROM CONTESTANTS WHERE CONTESTANTS.contestant_name LIKE 'terminal' SELECT country.Name FROM country WHERE country.IndepYear > 'terminal' SELECT country.Name FROM country WHERE country.IndepYear > 'terminal' SELECT Count(*) FROM country SELECT Count(*) FROM country WHERE country.LocalName = 'terminal' SELECT Sum(country.SurfaceArea) FROM country WHERE country.Name = 'terminal' SELECT Sum(country.SurfaceArea) FROM country WHERE country.Name = 'terminal' SELECT city.District FROM city WHERE city.Name = 'terminal' SELECT country.Name FROM city JOIN country WHERE city.Name = 'terminal' SELECT city.District FROM city WHERE city.Name = 'terminal' SELECT country.Region FROM country WHERE country.Region = 'terminal' SELECT city.Name FROM city JOIN country WHERE country.Name = 'terminal' GROUP BY city.Name ORDER BY Count(*) Desc LIMIT 1 SELECT countrylanguage.Language FROM countrylanguage JOIN country WHERE country.Name = 'terminal' GROUP BY countrylanguage.Language ORDER BY Count(*) Desc LIMIT 1 SELECT Sum(city.Population), city.Population FROM city SELECT country.Population, country.HeadOfState FROM country SELECT country.Region, country.Population FROM country WHERE country.LocalName = 'terminal' SELECT country.Region, country.Population FROM country WHERE country.LocalName = 'terminal' SELECT Avg(country.HeadOfState) FROM country WHERE country.Region = 'terminal' SELECT Avg(city.Population) FROM city WHERE city.Name = 'terminal' SELECT country.Name FROM country JOIN city ORDER BY city.Population Asc LIMIT 1 SELECT country.Name FROM country JOIN city WHERE city.CountryCode = 'terminal' ORDER BY country.HeadOfState Asc LIMIT 1 SELECT Sum(Sum(country.Population)), Max(city.Population) FROM country JOIN city WHERE city.CountryCode = 'terminal' SELECT Sum(country.Population), Max(country.Population) FROM country WHERE country.LocalName = 'terminal' SELECT Avg(country.Population) FROM country WHERE country.Capital = 'terminal' SELECT Avg(country.HeadOfState) FROM country WHERE country.Capital = 'terminal' SELECT Sum(country.SurfaceArea) FROM country WHERE country.Region = 'terminal' SELECT Sum(country.SurfaceArea) FROM country WHERE country.Capital = 'terminal' OR country.Capital = 'terminal' SELECT city.Population FROM city WHERE city.District = 'terminal' SELECT Sum(city.Population) FROM city WHERE city.District = 'terminal' SELECT Avg(country.GNP), Sum(country.Population) FROM country WHERE country.HeadOfState = 'terminal' SELECT Avg(country.GNP), Sum(country.Population) FROM country JOIN city WHERE city.Name = 'terminal' SELECT Count(DISTINCT countrylanguage.Language) FROM countrylanguage SELECT Count(DISTINCT countrylanguage.Language) FROM countrylanguage SELECT Count(DISTINCT country.GovernmentForm) FROM country WHERE country.GovernmentForm = 'terminal' SELECT Count(DISTINCT country.GovernmentForm) FROM country WHERE country.GovernmentForm = 'terminal' SELECT Count(*) FROM countrylanguage JOIN country WHERE country.LocalName = 'terminal' SELECT Count(*) FROM city JOIN country WHERE country.Name = 'terminal' AND country.Name = 'terminal' SELECT Count(*) FROM countrylanguage WHERE countrylanguage.Language = 'terminal' SELECT Count(DISTINCT countrylanguage.Language) FROM countrylanguage WHERE countrylanguage.Language = 'terminal' SELECT country.Name FROM country JOIN countrylanguage GROUP BY country.Name ORDER BY Count(*) Desc LIMIT 1 SELECT country.Name FROM countrylanguage JOIN country GROUP BY country.Name ORDER BY Count(*) Desc LIMIT 1 SELECT countrylanguage.Language FROM countrylanguage GROUP BY countrylanguage.Language ORDER BY Count(*) Desc LIMIT 1 SELECT countrylanguage.Language FROM countrylanguage GROUP BY countrylanguage.Language ORDER BY Count(*) Desc LIMIT 1 SELECT Count(*) FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' AND countrylanguage.Language = 'terminal' SELECT Count(*) FROM countrylanguage WHERE countrylanguage.Language = 'terminal' SELECT country.Name FROM country WHERE country.LocalName = 'terminal' INTERSECT SELECT country.Name FROM country WHERE country.LocalName = 'terminal' SELECT country.Name FROM country WHERE country.LocalName = 'terminal' INTERSECT SELECT country.Name FROM country WHERE country.LocalName = 'terminal' SELECT country.Name FROM countrylanguage JOIN country WHERE countrylanguage.Language = 'terminal' INTERSECT SELECT country.Name FROM countrylanguage JOIN country WHERE countrylanguage.Language = 'terminal' SELECT country.Name FROM countrylanguage JOIN country WHERE countrylanguage.Language = 'terminal' INTERSECT SELECT country.Name FROM countrylanguage JOIN country WHERE countrylanguage.Language = 'terminal' SELECT Count(DISTINCT countrylanguage.Language) FROM countrylanguage WHERE countrylanguage.Language = 'terminal' SELECT Count(*) FROM countrylanguage WHERE countrylanguage.Language = 'terminal' SELECT countrylanguage.Language FROM countrylanguage WHERE countrylanguage.Language = 'terminal' OR countrylanguage.Language = 'terminal' SELECT city.Name FROM countrylanguage JOIN city WHERE countrylanguage.Language = 'terminal' OR countrylanguage.Language = 'terminal' SELECT countrylanguage.Language FROM countrylanguage WHERE countrylanguage.Language = 'terminal' OR countrylanguage.Language = 'terminal' SELECT country.Name FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' OR countrylanguage.Language = 'terminal' SELECT countrylanguage.Language FROM countrylanguage GROUP BY countrylanguage.Language ORDER BY Count(*) Desc LIMIT 1 SELECT countrylanguage.Language FROM countrylanguage GROUP BY countrylanguage.Language ORDER BY Count(*) Desc LIMIT 1 SELECT countrylanguage.Language FROM countrylanguage GROUP BY countrylanguage.Language HAVING Count(*) = 'terminal' SELECT countrylanguage.Language FROM countrylanguage GROUP BY countrylanguage.Language HAVING Count(*) = 'terminal' SELECT city.Name FROM city JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' ORDER BY city.Population Desc LIMIT 1 SELECT city.Name FROM city JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' ORDER BY city.Population Desc LIMIT 1 SELECT country.Name, country.Population, city.Population FROM country JOIN city WHERE city.CountryCode = 'terminal' ORDER BY country.SurfaceArea Desc LIMIT 1 SELECT country.Name, country.Population, city.Population FROM country JOIN city ORDER BY country.SurfaceArea Desc LIMIT 1 SELECT Avg(country.HeadOfState) FROM country WHERE country.Code NOT IN (SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal') SELECT Avg(country.HeadOfState) FROM country WHERE country.Code NOT IN (SELECT countrylanguage.Language FROM countrylanguage) SELECT Sum(country.Population) FROM country WHERE country.Code NOT IN (SELECT countrylanguage.Language FROM countrylanguage WHERE countrylanguage.Language = 'terminal') SELECT Sum(country.Population) FROM country WHERE city.CountryCode NOT IN (SELECT countrylanguage.Language FROM countrylanguage WHERE countrylanguage.Language = 'terminal') SELECT countrylanguage.Language FROM country JOIN countrylanguage WHERE country.HeadOfState = 'terminal' SELECT countrylanguage.Language FROM country JOIN countrylanguage WHERE country.HeadOfState = 'terminal' SELECT Count(DISTINCT countrylanguage.Language) FROM countrylanguage JOIN country WHERE country.IndepYear < 'terminal' SELECT Count(DISTINCT countrylanguage.Language) FROM countrylanguage JOIN country WHERE country.IndepYear < 'terminal' SELECT country.Name FROM country WHERE country.SurfaceArea > (SELECT Max(country.SurfaceArea) FROM country) SELECT country.Name FROM country WHERE country.SurfaceArea > (SELECT country.SurfaceArea FROM country) SELECT country.Name FROM country WHERE country.Population < (SELECT Min(country.Population) FROM city) SELECT country.Name FROM country WHERE country.Population < (SELECT Min(country.Population) FROM country) SELECT country.Name FROM country WHERE city.Population > (SELECT Max(city.Population) FROM city) SELECT city.Name FROM city WHERE city.Population > (SELECT Max(city.Population) FROM city) SELECT country.Code FROM country EXCEPT SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal' SELECT country.Code FROM country EXCEPT SELECT countrylanguage.CountryCode FROM countrylanguage SELECT country.Code FROM country JOIN countrylanguage WHERE countrylanguage.Language > 'terminal' SELECT country.Code FROM country JOIN countrylanguage WHERE countrylanguage.Language != 'terminal' SELECT country.Code FROM country WHERE country.Code NOT IN (SELECT countrylanguage.Language FROM countrylanguage) SELECT country.Code FROM country EXCEPT SELECT countrylanguage.CountryCode FROM countrylanguage SELECT city.Name FROM city WHERE city.ID NOT IN (SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal') SELECT city.Name FROM city JOIN countrylanguage WHERE countrylanguage.Language != 'terminal' SELECT DISTINCT city.Name FROM city JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' SELECT DISTINCT city.Name FROM city WHERE city.CountryCode = 'terminal' SELECT country.Name, country.Continent, country.SurfaceArea FROM country ORDER BY country.Population Asc LIMIT 1 SELECT country.Name, country.Continent, country.Region FROM country JOIN city ORDER BY city.Population Asc LIMIT 1 SELECT country.Population, country.Name, country.SurfaceArea FROM country ORDER BY country.SurfaceArea Desc LIMIT 1 SELECT country.Name, country.Population, country.HeadOfState FROM country ORDER BY country.SurfaceArea Desc LIMIT 1 SELECT country.Name, Count(*) FROM countrylanguage JOIN country GROUP BY countrylanguage.Language HAVING Count(*) >= 'terminal' SELECT country.Name, Count(*) FROM country JOIN countrylanguage GROUP BY country.Name HAVING Count(*) > 'terminal' SELECT Count(*), city.District FROM city WHERE city.Population > (SELECT Avg(city.Population) FROM city) SELECT Count(*), city.District FROM city WHERE city.Population > (SELECT Avg(city.Population) FROM city) SELECT country.Name, Sum(city.Population) FROM city WHERE city.Population > (SELECT Avg(city.Population) FROM city) SELECT Sum(country.Population), country.HeadOfState FROM country JOIN city GROUP BY country.HeadOfState HAVING Avg(city.Population) > 'terminal' SELECT Avg(city.Population), Sum(city.Population) FROM city SELECT Sum(country.Population), Avg(city.Population) FROM country JOIN city SELECT country.Name, country.Region FROM country ORDER BY country.SurfaceArea Desc LIMIT 1 SELECT country.Name, country.SurfaceArea FROM country ORDER BY country.Continent Desc LIMIT 1 SELECT country.Name FROM country JOIN city ORDER BY country.Population Desc LIMIT 1 SELECT country.Name FROM country ORDER BY country.Population Desc LIMIT 1 SELECT country.Name FROM country JOIN city ORDER BY city.Population Asc LIMIT 1 SELECT country.Name FROM city JOIN country ORDER BY city.Population Asc LIMIT 1 SELECT Count(*) FROM country SELECT Count(*) FROM country WHERE country.Capital = 'terminal' SELECT country.Name FROM country WHERE country.LocalName = 'terminal' SELECT country.Name FROM country JOIN city WHERE country.LocalName = 'terminal' SELECT Sum(country.Population), Avg(country.SurfaceArea) FROM country JOIN city WHERE country.SurfaceArea > 'terminal' SELECT Sum(country.Population), Avg(country.SurfaceArea) FROM country WHERE country.SurfaceArea > 'terminal' SELECT city.Name FROM city WHERE city.Population BETWEEN 'terminal' AND 'terminal' SELECT city.Name FROM city WHERE city.Population BETWEEN 'terminal' AND 'terminal' SELECT countrylanguage.Language FROM countrylanguage GROUP BY countrylanguage.Language ORDER BY Count(*) Desc LIMIT 1 SELECT countrylanguage.Language FROM countrylanguage GROUP BY countrylanguage.Language ORDER BY Count(*) Desc LIMIT 1 SELECT countrylanguage.Language, countrylanguage.Language FROM countrylanguage JOIN country GROUP BY countrylanguage.Language ORDER BY Count(*) Desc LIMIT 1 SELECT city.CountryCode, countrylanguage.Language FROM countrylanguage JOIN city GROUP BY city.CountryCode ORDER BY Count(*) Desc LIMIT 1 SELECT Count(*) FROM countrylanguage WHERE countrylanguage.Language = (SELECT countrylanguage.Language FROM countrylanguage GROUP BY countrylanguage.Language ORDER BY Count(*) Desc LIMIT 1) SELECT Count(*) FROM countrylanguage WHERE countrylanguage.Language = 'terminal' SELECT country.Code FROM country WHERE countrylanguage.Language = (SELECT city.CountryCode FROM country GROUP BY city.CountryCode ORDER BY Count(*) Desc LIMIT 1) ORDER BY country.Population Desc LIMIT 1 SELECT country.Code FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' GROUP BY countrylanguage.CountryCode ORDER BY Count(*) Desc LIMIT 1 SELECT Count(*) FROM conductor SELECT Count(*) FROM orchestra SELECT conductor.Name FROM conductor ORDER BY conductor.Age Asc SELECT conductor.Name FROM conductor ORDER BY conductor.Age Asc SELECT conductor.Name FROM conductor WHERE conductor.Nationality != 'terminal' SELECT conductor.Name FROM conductor WHERE conductor.Nationality != 'terminal' SELECT orchestra.Orchestra FROM orchestra ORDER BY orchestra.Year_of_Founded Desc SELECT orchestra.Record_Company FROM orchestra ORDER BY orchestra.Year_of_Founded Asc SELECT Avg(show.Attendance) FROM show SELECT Avg(performance.Share) FROM show JOIN performance SELECT Max(performance.Official_ratings_(millions)), Min(performance.Official_ratings_(millions)) FROM performance WHERE performance.Type != 'terminal' SELECT Max(performance.Official_ratings_(millions)), Min(performance.Official_ratings_(millions)) FROM performance WHERE performance.Type != 'terminal' SELECT Count(DISTINCT conductor.Nationality) FROM conductor SELECT Count(DISTINCT conductor.Nationality) FROM conductor SELECT conductor.Name FROM conductor ORDER BY conductor.Year_of_Work Desc SELECT conductor.Name FROM conductor ORDER BY conductor.Year_of_Work Desc SELECT conductor.Name FROM conductor JOIN orchestra ORDER BY conductor.Year_of_Work Desc LIMIT 1 SELECT conductor.Name FROM conductor JOIN orchestra ORDER BY conductor.Year_of_Work Desc LIMIT 1 SELECT conductor.Name, conductor.Name FROM conductor JOIN orchestra SELECT conductor.Name, orchestra.Orchestra FROM conductor JOIN orchestra SELECT conductor.Name FROM conductor JOIN orchestra GROUP BY orchestra.Conductor_ID HAVING Count(*) > 'terminal' SELECT conductor.Name FROM conductor JOIN orchestra GROUP BY orchestra.Conductor_ID HAVING Count(*) > 'terminal' SELECT conductor.Name FROM conductor JOIN orchestra GROUP BY orchestra.Conductor_ID ORDER BY Count(*) Desc LIMIT 1 SELECT conductor.Name FROM conductor JOIN orchestra GROUP BY orchestra.Conductor_ID ORDER BY Count(*) Desc LIMIT 1 SELECT conductor.Name FROM conductor JOIN orchestra WHERE orchestra.Year_of_Founded > 'terminal' SELECT conductor.Name FROM conductor JOIN orchestra WHERE orchestra.Year_of_Founded > 'terminal' SELECT orchestra.Record_Company, Count(*) FROM orchestra GROUP BY orchestra.Record_Company SELECT orchestra.Orchestra, Count(*) FROM orchestra GROUP BY orchestra.Orchestra SELECT orchestra.Orchestra FROM orchestra ORDER BY orchestra.Year_of_Founded Asc SELECT performance.Type FROM performance ORDER BY performance.Type Asc SELECT orchestra.Orchestra FROM orchestra GROUP BY orchestra.Orchestra ORDER BY Count(*) Desc LIMIT 1 SELECT orchestra.Orchestra FROM orchestra GROUP BY orchestra.Orchestra ORDER BY Count(*) Desc LIMIT 1 SELECT orchestra.Orchestra FROM orchestra WHERE orchestra.Orchestra_ID NOT IN (SELECT performance.Orchestra_ID FROM performance) SELECT orchestra.Orchestra FROM orchestra EXCEPT SELECT orchestra.Orchestra FROM orchestra JOIN performance SELECT orchestra.Record_Company FROM orchestra WHERE orchestra.Year_of_Founded < 'terminal' INTERSECT SELECT orchestra.Record_Company FROM orchestra WHERE orchestra.Year_of_Founded > 'terminal' SELECT orchestra.Record_Company FROM orchestra WHERE orchestra.Year_of_Founded < 'terminal' INTERSECT SELECT orchestra.Record_Company FROM orchestra WHERE orchestra.Year_of_Founded > 'terminal' SELECT Count(*) FROM orchestra WHERE orchestra.Major_Record_Format = 'terminal' OR orchestra.Major_Record_Format = 'terminal' SELECT Count(*) FROM orchestra WHERE orchestra.Major_Record_Format = 'terminal' OR orchestra.Major_Record_Format = 'terminal' SELECT orchestra.Year_of_Founded FROM performance JOIN orchestra GROUP BY orchestra.Year_of_Founded HAVING Count(*) > 'terminal' SELECT performance.Weekly_rank FROM performance GROUP BY performance.Orchestra_ID HAVING Count(*) > 'terminal' SELECT Count(*) FROM Highschooler WHERE Highschooler.grade = 'terminal' SELECT Count(*) FROM Highschooler WHERE Highschooler.grade = 'terminal' SELECT Highschooler.name, Highschooler.grade FROM Highschooler WHERE Highschooler.grade = 'terminal' SELECT Highschooler.name, Highschooler.grade FROM Highschooler WHERE Highschooler.grade = 'terminal' SELECT Highschooler.grade FROM Highschooler SELECT Highschooler.grade FROM Highschooler SELECT Highschooler.grade FROM Highschooler WHERE Highschooler.name = 'terminal' SELECT Highschooler.grade FROM Highschooler WHERE Highschooler.name = 'terminal' SELECT Highschooler.name FROM Highschooler WHERE Highschooler.grade = 'terminal' SELECT Highschooler.name FROM Highschooler WHERE Highschooler.grade = 'terminal' SELECT Highschooler.ID FROM Highschooler JOIN Friend WHERE Highschooler.name = 'terminal' SELECT Highschooler.ID FROM Highschooler WHERE Highschooler.name = 'terminal' SELECT Count(*) FROM Highschooler WHERE Highschooler.grade = 'terminal' OR Highschooler.grade = 'terminal' SELECT Count(*) FROM Highschooler WHERE Highschooler.grade = 'terminal' OR Highschooler.grade = 'terminal' SELECT Count(*), Highschooler.grade FROM Highschooler GROUP BY Highschooler.grade SELECT Count(*), Highschooler.grade FROM Highschooler GROUP BY Highschooler.grade SELECT Highschooler.grade FROM Highschooler GROUP BY Highschooler.grade ORDER BY Count(*) Desc LIMIT 1 SELECT Highschooler.grade FROM Highschooler GROUP BY Highschooler.grade ORDER BY Count(*) Desc LIMIT 1 SELECT Highschooler.grade FROM Highschooler JOIN Friend GROUP BY Highschooler.grade HAVING Count(*) >= 'terminal' SELECT Highschooler.grade FROM Friend JOIN Highschooler GROUP BY Highschooler.grade HAVING Count(*) >= 'terminal' SELECT Friend.student_id, Count(*) FROM Friend GROUP BY Friend.student_id SELECT Count(*), Friend.student_id FROM Highschooler JOIN Friend GROUP BY Friend.student_id SELECT Highschooler.name, Count(*) FROM Highschooler JOIN Friend WHERE Highschooler.grade = 'terminal' SELECT Count(*), Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade = 'terminal' GROUP BY Friend.student_id SELECT Highschooler.name FROM Highschooler JOIN Friend GROUP BY Friend.student_id ORDER BY Count(*) Desc LIMIT 1 SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade = (SELECT Friend.friend_id FROM Highschooler JOIN Friend GROUP BY Friend.student_id ORDER BY Count(*) Desc LIMIT 1) SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade = 'terminal' GROUP BY Highschooler.name HAVING Count(*) >= 'terminal' SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade = 'terminal' GROUP BY Friend.student_id HAVING Count(*) >= 'terminal' SELECT DISTINCT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.name = 'terminal' SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.name = 'terminal' SELECT Count(*) FROM Highschooler JOIN Friend WHERE Highschooler.name = 'terminal' AND Highschooler.name = 'terminal' SELECT Count(*) FROM Highschooler JOIN Friend WHERE Highschooler.name = 'terminal' SELECT Highschooler.ID FROM Highschooler EXCEPT SELECT Friend.student_id FROM Friend SELECT Highschooler.ID FROM Highschooler EXCEPT SELECT Friend.student_id FROM Friend SELECT Highschooler.name FROM Highschooler EXCEPT SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade = 'terminal' SELECT Highschooler.name FROM Highschooler EXCEPT SELECT Highschooler.name FROM Highschooler JOIN Friend SELECT Friend.friend_id FROM Friend JOIN Highschooler WHERE Highschooler.grade = 'terminal' INTERSECT SELECT Friend.friend_id FROM Highschooler JOIN Friend WHERE Highschooler.grade = 'terminal' SELECT Friend.student_id FROM Friend INTERSECT SELECT Friend.student_id FROM Friend SELECT Highschooler.name FROM Highschooler JOIN Friend EXCEPT SELECT Highschooler.name FROM Highschooler JOIN Friend SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade = 'terminal' INTERSECT SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade = 'terminal' SELECT Count(*), Friend.student_id FROM Friend GROUP BY Friend.student_id SELECT Friend.student_id, Count(*) FROM Friend GROUP BY Friend.student_id SELECT Highschooler.name, * FROM Likes JOIN Highschooler WHERE Highschooler.grade = 'terminal' SELECT Highschooler.name, Count(*) FROM Likes JOIN Highschooler WHERE Highschooler.grade = 'terminal' SELECT Highschooler.name FROM Highschooler WHERE Highschooler.grade = (SELECT Max(*) FROM Highschooler) SELECT Highschooler.name FROM Highschooler ORDER BY Highschooler.grade Desc LIMIT 1 SELECT Highschooler.name FROM Likes JOIN Highschooler GROUP BY Likes.student_id HAVING Count(*) >= 'terminal' SELECT Highschooler.name FROM Likes JOIN Highschooler GROUP BY Likes.student_id HAVING Count(*) >= 'terminal' SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade > 'terminal' GROUP BY Friend.student_id HAVING Count(*) >= 'terminal' SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade > 'terminal' AND Friend.friend_id >= 'terminal' SELECT Count(*) FROM Likes JOIN Highschooler WHERE Highschooler.name = 'terminal' SELECT Count(*) FROM Likes JOIN Highschooler WHERE Highschooler.name = 'terminal' AND Highschooler.name = 'terminal' SELECT Avg(Highschooler.grade) FROM Highschooler JOIN Friend SELECT Avg(Highschooler.grade) FROM Highschooler JOIN Friend SELECT Min(Highschooler.grade) FROM Highschooler WHERE Highschooler.ID NOT IN (SELECT Friend.student_id FROM Friend) SELECT Highschooler.grade FROM Highschooler EXCEPT SELECT Highschooler.grade FROM Highschooler JOIN Friend SELECT Owners.state FROM Owners UNION SELECT Owners.street FROM Owners SELECT Owners.state FROM Owners UNION SELECT Owners.street FROM Owners SELECT Avg(Dogs.age) FROM Dogs WHERE Dogs.dog_id NOT IN (SELECT Dogs.dog_id FROM Dogs) SELECT Avg(Dogs.age) FROM Dogs SELECT Owners.owner_id, Owners.last_name, Owners.home_phone FROM Owners WHERE Owners.state = 'terminal' GROUP BY Owners.owner_id HAVING Count(*) > 'terminal' UNION SELECT Owners.owner_id, Owners.last_name, Owners.home_phone FROM Owners GROUP BY Owners.owner_id HAVING Count(*) > 'terminal' SELECT Owners.owner_id, Owners.last_name, Owners.cell_number FROM Owners WHERE Owners.state = 'terminal' GROUP BY Owners.owner_id HAVING Count(*) > 'terminal' UNION SELECT Owners.owner_id, Owners.last_name, Owners.cell_number FROM Owners WHERE Owners.state = 'terminal' GROUP BY Owners.owner_id HAVING Count(*) > 'terminal' SELECT Dogs.name FROM Dogs EXCEPT SELECT Dogs.name FROM Dogs WHERE Dogs.abandoned_yn > 'terminal' SELECT Dogs.name FROM Dogs EXCEPT SELECT Dogs.name FROM Dogs SELECT Owners.first_name FROM Owners WHERE Owners.city = 'terminal' OR Owners.first_name = 'terminal' SELECT Owners.first_name FROM Owners WHERE Owners.last_name = 'terminal' OR Owners.last_name = 'terminal' SELECT Owners.owner_id, Owners.email_address, Owners.email_address FROM Owners EXCEPT SELECT Owners.owner_id, Owners.email_address, Owners.email_address FROM Owners JOIN Dogs SELECT Owners.owner_id, Owners.email_address, Owners.email_address FROM Owners EXCEPT SELECT Owners.owner_id, Owners.email_address, Owners.email_address FROM Owners JOIN Dogs SELECT Owners.owner_id, Owners.first_name, Owners.last_name FROM Dogs JOIN Owners GROUP BY Owners.owner_id ORDER BY Count(*) Desc LIMIT 1 SELECT Dogs.owner_id, Owners.first_name, Owners.last_name FROM Dogs JOIN Owners GROUP BY Dogs.owner_id ORDER BY Count(*) Desc LIMIT 1 SELECT Owners.owner_id, Owners.first_name, Owners.first_name FROM Owners JOIN Dogs GROUP BY Owners.owner_id HAVING Count(*) >= 'terminal' SELECT Owners.owner_id, Professionals.role_code, Owners.first_name FROM Dogs JOIN Owners GROUP BY Dogs.owner_id HAVING Count(*) >= 'terminal' SELECT Dogs.name FROM Dogs GROUP BY Dogs.name ORDER BY Count(*) Desc LIMIT 1 SELECT Dogs.name FROM Dogs GROUP BY Dogs.name ORDER BY Count(*) Desc LIMIT 1 SELECT Owners.owner_id, Owners.last_name FROM Dogs JOIN Owners GROUP BY Owners.owner_id ORDER BY Count(*) Desc LIMIT 1 SELECT Owners.owner_id, Owners.last_name FROM Dogs JOIN Owners GROUP BY Dogs.owner_id ORDER BY Count(*) Desc LIMIT 1 SELECT Charges.charge_type FROM Charges GROUP BY Charges.charge_type ORDER BY Sum(Charges.charge_type) Asc LIMIT 1 SELECT Treatment_Types.treatment_type_description FROM Treatment_Types JOIN Charges GROUP BY Charges.charge_type ORDER BY Sum(Treatment_Types.treatment_type_description) Asc LIMIT 1 SELECT Owners.owner_id, Sum(Dogs.date_arrived) FROM Dogs JOIN Owners GROUP BY Dogs.owner_id ORDER BY Sum(Dogs.date_arrived) Desc LIMIT 1 SELECT Dogs.owner_id, Max(Dogs.date_arrived) FROM Dogs GROUP BY Dogs.owner_id ORDER BY Sum(Dogs.date_arrived) Desc LIMIT 1 SELECT Owners.owner_id, Owners.home_phone FROM Owners JOIN Dogs GROUP BY Owners.owner_id HAVING Count(*) >= 'terminal' SELECT Charges.charge_id, Owners.cell_number FROM Charges JOIN Owners GROUP BY Charges.charge_id HAVING Count(*) >= 'terminal' SELECT Owners.first_name, Owners.last_name FROM Dogs JOIN Owners WHERE Dogs.weight < (SELECT Avg(Dogs.weight) FROM Dogs) SELECT Owners.first_name, Owners.last_name FROM Dogs JOIN Owners WHERE Dogs.size_code < (SELECT Avg(Dogs.size_code) FROM Dogs) SELECT Dogs.date_of_birth, Owners.first_name FROM Dogs JOIN Owners SELECT Owners.state, Owners.first_name FROM Owners SELECT Charges.charge_type, Charges.charge_type FROM Charges SELECT Charges.charge_amount, Charges.charge_type FROM Charges SELECT Owners.first_name, Owners.last_name, Owners.city FROM Dogs JOIN Owners SELECT Owners.first_name, Owners.last_name, Dogs.gender FROM Dogs JOIN Owners SELECT Owners.first_name, Dogs.name FROM Owners JOIN Dogs SELECT Owners.first_name, Dogs.name FROM Owners JOIN Dogs SELECT Dogs.name, Dogs.date_of_birth FROM Dogs ORDER BY Dogs.date_arrived Asc LIMIT 1 SELECT Dogs.name, Dogs.date_of_birth FROM Dogs ORDER BY Dogs.date_arrived Asc LIMIT 1 SELECT Owners.first_name, Owners.last_name FROM Owners WHERE Owners.state = 'terminal' SELECT Owners.first_name, Dogs.name FROM Owners JOIN Dogs WHERE Owners.state = 'terminal' SELECT Dogs.date_of_birth, Dogs.date_arrived FROM Dogs SELECT Dogs.date_of_birth, Dogs.date_arrived FROM Dogs SELECT Owners.last_name FROM Dogs JOIN Owners WHERE Dogs.age = (SELECT Max(Dogs.age) FROM Dogs) SELECT Owners.last_name FROM Dogs JOIN Owners WHERE Dogs.age = (SELECT Max(Dogs.age) FROM Dogs) SELECT Professionals.email_address FROM Professionals WHERE Professionals.state = 'terminal' OR Professionals.state = 'terminal' SELECT Professionals.email_address FROM Professionals WHERE Professionals.state = 'terminal' OR Professionals.state = 'terminal' SELECT Dogs.date_of_birth, Dogs.gender FROM Dogs SELECT Dogs.date_of_birth, Dogs.date_arrived FROM Dogs SELECT Count(*) FROM Dogs SELECT Count(*) FROM Dogs SELECT Count(DISTINCT Dogs.owner_id) FROM Dogs SELECT Count(*) FROM Dogs SELECT Professionals.role_code, Professionals.home_phone, Professionals.state FROM Professionals WHERE Professionals.city LIKE 'terminal' SELECT Professionals.role_code, Professionals.street, Professionals.state FROM Professionals WHERE Professionals.city LIKE 'terminal' SELECT Owners.first_name, Owners.last_name, Owners.email_address FROM Owners WHERE Owners.first_name LIKE 'terminal' SELECT Owners.first_name, Owners.last_name, Owners.email_address FROM Owners WHERE Owners.first_name LIKE 'terminal' SELECT Count(*) FROM Dogs WHERE Dogs.age < (SELECT Avg(Dogs.age) FROM Dogs) SELECT Count(*) FROM Dogs WHERE Dogs.age < (SELECT Avg(Dogs.age) FROM Dogs) SELECT Dogs.date_of_birth FROM Dogs ORDER BY Dogs.date_of_birth Asc LIMIT 1 SELECT Dogs.date_arrived FROM Dogs ORDER BY Dogs.date_adopted Desc LIMIT 1 SELECT Count(*) FROM Dogs WHERE Dogs.dog_id NOT IN (SELECT Dogs.owner_id FROM Dogs) SELECT Count(*) FROM Dogs WHERE Dogs.owner_id NOT IN (SELECT Dogs.owner_id FROM Dogs) SELECT Count(*) FROM Owners WHERE Owners.owner_id NOT IN (SELECT Dogs.owner_id FROM Dogs) SELECT Count(*) FROM Owners WHERE Owners.owner_id NOT IN (SELECT Dogs.owner_id FROM Dogs) SELECT Count(*) FROM Owners WHERE Owners.owner_id NOT IN (SELECT Dogs.owner_id FROM Dogs) SELECT Count(*) FROM Dogs WHERE Owners.owner_id NOT IN (SELECT Dogs.owner_id FROM Dogs) SELECT Dogs.name, Dogs.age, Dogs.weight FROM Dogs SELECT Dogs.name, Dogs.age, Dogs.weight FROM Dogs UNION SELECT Dogs.name, Dogs.weight, Dogs.weight FROM Dogs SELECT Avg(Dogs.age) FROM Dogs SELECT Avg(Dogs.age) FROM Dogs SELECT Dogs.age FROM Dogs ORDER BY Dogs.age Desc LIMIT 1 SELECT Dogs.age FROM Dogs ORDER BY Dogs.age Desc LIMIT 1 SELECT Charges.charge_type, Count(*) FROM Charges GROUP BY Charges.charge_type SELECT Charges.charge_type, Count(*) FROM Charges GROUP BY Charges.charge_type SELECT Charges.charge_type FROM Charges GROUP BY Charges.charge_type ORDER BY Max(Charges.charge_amount) Desc LIMIT 1 SELECT Charges.charge_type FROM Charges GROUP BY Charges.charge_type ORDER BY Count(*) Desc LIMIT 1 SELECT Owners.email_address, Owners.cell_number, Owners.home_phone FROM Owners SELECT Owners.email_address, Owners.cell_number, Owners.home_phone FROM Owners SELECT Charges.charge_type FROM Charges SELECT DISTINCT Charges.charge_type, Charges.charge_amount FROM Charges SELECT Owners.first_name, Owners.last_name FROM Dogs JOIN Owners SELECT Owners.first_name, Treatment_Types.treatment_type_description FROM Owners JOIN Treatment_Types SELECT Count(*) FROM singer SELECT Count(*) FROM singer SELECT singer.Name FROM singer ORDER BY singer.Net_Worth_Millions Asc SELECT singer.Name FROM singer ORDER BY singer.Net_Worth_Millions Asc SELECT singer.Birth_Year, singer.Citizenship FROM singer SELECT singer.Birth_Year, singer.Citizenship FROM singer SELECT singer.Name FROM singer WHERE singer.Citizenship != 'terminal' SELECT singer.Name FROM singer WHERE singer.Citizenship != 'terminal' SELECT singer.Name FROM singer WHERE singer.Birth_Year = 'terminal' OR singer.Birth_Year = 'terminal' SELECT singer.Name FROM singer WHERE singer.Birth_Year = 'terminal' OR singer.Birth_Year = 'terminal' SELECT singer.Name, singer.Name FROM singer ORDER BY singer.Net_Worth_Millions Desc LIMIT 1 SELECT singer.Name, singer.Name FROM singer JOIN song ORDER BY song.Sales Desc LIMIT 1 SELECT singer.Citizenship, Count(*) FROM singer GROUP BY singer.Citizenship SELECT singer.Citizenship, Count(*) FROM singer GROUP BY singer.Citizenship SELECT singer.Citizenship FROM singer GROUP BY singer.Citizenship ORDER BY Count(*) Desc LIMIT 1 SELECT singer.Birth_Year FROM singer GROUP BY singer.Birth_Year ORDER BY Count(*) Desc LIMIT 1 SELECT singer.Citizenship, Max(song.Sales) FROM singer JOIN song GROUP BY singer.Citizenship SELECT Max(song.Sales), singer.Citizenship FROM singer JOIN song GROUP BY singer.Citizenship SELECT song.Title, singer.Name FROM singer JOIN song SELECT song.Title, singer.Name FROM singer JOIN song SELECT DISTINCT singer.Name FROM singer JOIN song WHERE song.Sales > 'terminal' SELECT DISTINCT singer.Name FROM singer JOIN song WHERE song.Sales > 'terminal' SELECT singer.Name FROM singer JOIN song GROUP BY song.Singer_ID HAVING Count(*) > 'terminal' SELECT singer.Name FROM singer JOIN song GROUP BY song.Singer_ID HAVING Count(*) > 'terminal' SELECT singer.Name, Sum(song.Sales) FROM singer JOIN song GROUP BY song.Singer_ID SELECT Sum(song.Sales), singer.Name FROM singer JOIN song GROUP BY singer.Name SELECT singer.Name FROM singer WHERE singer.Singer_ID NOT IN (SELECT song.Singer_ID FROM song) SELECT singer.Name FROM singer WHERE singer.Singer_ID NOT IN (SELECT song.Singer_ID FROM song) SELECT singer.Citizenship FROM singer WHERE singer.Birth_Year < 'terminal' INTERSECT SELECT singer.Citizenship FROM singer WHERE singer.Birth_Year > 'terminal' SELECT singer.Citizenship FROM singer WHERE singer.Birth_Year < 'terminal' INTERSECT SELECT singer.Citizenship FROM singer WHERE singer.Birth_Year > 'terminal' SELECT Count(*) FROM Properties SELECT Ref_Feature_Types.feature_type_name FROM Other_Available_Features JOIN Ref_Feature_Types WHERE Other_Available_Features.feature_name = 'terminal' SELECT Other_Available_Features.feature_description FROM Other_Available_Features SELECT Properties.property_name FROM Properties WHERE Properties.room_count > 'terminal' OR Properties.room_count > 'terminal'