SELECT count(*) FROM singers SELECT sum(T1.Total_Number_of_Singers) FROM Singers AS T1 JOIN Songs AS T2 ON T1.Songs = T2.Songs SELECT name, country, age FROM Singers ORDER BY age DESC LIMIT 1 SELECT T1.Name, T1.Country, T1.Age FROM singers AS T1 JOIN vocals AS T2 ON T1.Songs = T2.Songs_Songs_Songs AS T3 ON T1.Songs_Songs_ID = T3 SELECT avg(age), min(age), max(age) FROM singers AS t1 JOIN singers AS t2 ON t1.songs_from_france = t2.songs_from_france SELECT avg(age), min(age), max(age) FROM vocals AS t1 JOIN vocals AS t2 ON t1.f_f_f_f_f_f_f_f_f_f_f_f_f SELECT T1.name, T1.release_year FROM tracks AS T1 JOIN song AS T2 ON T1.song_id = T2.song_id WHERE T2.song_name = "The Youngest" SELECT T1.Name, T1.Release_Year FROM songs AS T1 JOIN vocals AS T2 ON T1.Songs_of_Youngest_SINGER = T2.Songs_of_Youngest_SINGER AS T3 ON T1.Songs_of_ SELECT DISTINCT T1.Country FROM singers AS T1 JOIN languages AS T2 ON T1.Songs_Above_Age 20 = T2.Songs_Above_Age 20 AS T3 ON T1.Songs_Above_Age 20 = T3.Songs SELECT DISTINCT T1.Country FROM singers AS T1 JOIN vocals AS T2 ON T1.Songs_Above_Age 20 GROUP BY T1.Country HAVING count(*) > 20 SELECT Country, COUNT(*) FROM singers SELECT count(*) FROM singers AS T1 JOIN singers AS T2 ON T1.Country = T2.Country SELECT T1.Song_Name FROM Singers AS T1 JOIN Songs AS T2 ON T1.Song_Name = T2.Song_Name WHERE T2.Age > (SELECT avg(age) FROM Singers) SELECT T1.song_name FROM singers AS T1 JOIN vocals AS T2 ON T1.song_name = T2.song_name WHERE T2.age < (SELECT avg(T2.age) FROM singers AS T1 JOIN vocals AS T2 ON SELECT T1.Location, T1.Name FROM stadium AS T1 JOIN stadium AS T2 ON T1.Stadium = T2.Stadium WHERE T2.capacity BETWEEN 5000 AND 10000 SELECT T1.Location, T1.Name FROM station AS T1 JOIN capacity AS T2 ON T1.Station_ID = T2.Station_ID WHERE T2.capacity BETWEEN 5000 AND 10000 SELECT max(capacity), avg(average) FROM stadiums SELECT avg(capacity), max(capacity) FROM stadiums SELECT T1.name, T1.capacity, T1.capacity FROM stadium AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id GROUP BY T1.stadium_id HAVING avg(T1.attendance) >= 1 SELECT T1.name, T1.capacity, T1.capacity FROM stadium AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id GROUP BY T1.stadium_id ORDER BY avg(T1.attendance) DESC LIMIT 1 SELECT count(*) FROM RECORD COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT SELECT count(*) FROM RECORD COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) SELECT T1.stadium_name, count(*) FROM stadium AS T1 JOIN concerts AS T2 ON T1.stadium_name = T2.stadium_name GROUP BY T1.stadium_name SELECT count(*) FROM stadium GROUP BY stadium SELECT T1.stadium_name, T1.capacity, T1.capacity FROM stadium AS T1 JOIN concerts AS T2 ON T1.stadium_name = T2.stadium_name WHERE T2.year = 2014 OR T1.year = 2014 SELECT T1.name, T1.capacity FROM stadium AS T1 JOIN stadium_concerts AS T2 ON T1.stadium_id = T2.stadium_id GROUP BY T1.stadium_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.year, T1.year_high_number_of_concerts GROUP BY T1.year_high_number_of_concerts ORDER BY count(*) DESC LIMIT 1 SELECT T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T1.Year_T SELECT T1.stadium_name, T1.stadium_name FROM stadium AS T1 JOIN concert AS T2 ON T1.stadium_name = T2.stadium_name WHERE T2.concert = "NO" SELECT T1.Name FROM stadiums AS T1 JOIN concerts AS T2 ON T1.Stadium_ID = T2.Stadium_ID WHERE T2.No_concerts = "NO" SELECT Country FROM languages WHERE Age 40 = 40 INTERSECT SELECT Country FROM languages WHERE Age 40 = 40 INTERSECT SELECT Country FROM languages WHERE Age 40 = 40 INTERSECT SELECT Country FROM languages WHERE Age 40 SELECT T1.Name FROM stadiums AS T1 JOIN concerts AS T2 ON T1.Stadium_ID = T2.Stadium_ID WHERE T2.Year_2014 = 2014 AND T2.Year_2014 = 2014 SELECT T1.stadium_name FROM stadiums AS T1 JOIN stadium_concerts AS T2 ON T1.stadium_id = T2.stadium_id WHERE T1.year_is 2014 = "2014" AND T1.year_is = "2014" SELECT T1.Name, T1.Theme FROM EVENTS AS T1 JOIN Singers AS T2 ON T1.Songs = T2.Songs_in_Festivals AS T3 ON T1.Songs_in_Festivals = T3.Songs_in SELECT T1.Name, T2.Theme, T1.Number_of_Singers, T1.Number_of_Singers, T1.Number_of_Singers, T1.Number_of_Singers, T1.Number_of_Singers, T1.Number_of_ SELECT T1.Name, count(*), count(*) FROM Singers AS T1 JOIN Performance AS T2 ON T1.Singer_Name = T2.Singer_Name SELECT T1.Name, count(*) FROM Singers AS T1 JOIN Performance AS T2 ON T1.Songs = T2.Songs AS T3 ON T1.Songs = T3.Songs SELECT T1.Name FROM singers AS T1 JOIN performances AS T2 ON T1.Singer_Name = T2.Singer_Name WHERE T1.Year 2014 = 2014 SELECT T1.Name FROM singers AS T1 JOIN performance AS T2 ON T1.Songs_Performance_ID = T2.Songs_ID WHERE T1.Year_in_2014 = 2014 AND T2.Performance_ID = T2.Performance_ID WHERE T SELECT T1.name, T1.national FROM singers AS T1 JOIN vocals AS T2 ON T1.songid = T2.songid WHERE T2.name LIKE '%Hey%' SELECT T1.name, T1.country_of_origin FROM singers AS T1 JOIN vocals AS T2 ON T1.song_id = T2.song_id WHERE T2.title LIKE '%Hey%' SELECT T1.name, T1.location FROM stadiums AS T1 JOIN stadium_concerts AS T2 ON T1.stadium_id = T2.stadium_id WHERE T2.year_of_2014 AND T2.year_of_2015 = '2014 SELECT T1.Name, T1.Location FROM stadiums AS T1 JOIN stadiums AS T2 ON T1.Stadium_ID = T2.Stadium_ID WHERE T2.Years BETWEEN 2014 AND 2015 SELECT count(*) FROM stadiums WHERE capacity = 'high' GROUP BY stadium_capacity ORDER BY count(*) DESC LIMIT 1 SELECT count(*) FROM stadiums WHERE capacity = 'high' GROUP BY stadium_with_capacity ORDER BY count(*) DESC LIMIT 1 SELECT count(*) FROM pets WHERE weight > 10 SELECT count(*) FROM pets WHERE weight > 10 SELECT t1.Weight, t2.Weight, t2.Weight, t2.Weight, t2.Weight, t2.Weight, t2.Weight, t2.Weight, t2.Weight, t2.Weight, SELECT count(*) FROM dogs WHERE age = (SELECT avg(age) FROM dogs) SELECT max(weight), pet_type FROM pets SELECT max(weight), TYPE FROM pets SELECT count(*) FROM pets WHERE Student_Age > 20 SELECT count(*) FROM pets WHERE age > 20 AND age < 20 SELECT count(*) FROM pets WHERE sex F = "F" SELECT count(*) FROM pets WHERE female_student = "female" AND female_student = "female" SELECT count(DISTINCT TYPE_of_pets) FROM pets SELECT count(DISTINCT TYPE_of_Pet) FROM pets SELECT T1.first_name FROM Students AS T1 JOIN Students AS T2 ON T1.stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu SELECT T1.fname FROM Student AS T1 JOIN Student AS T2 ON T1.stuid = T2.stuid WHERE T2.name = "Cat" OR T1.name = "Dog" SELECT T1.first_name FROM Students AS T1 JOIN Student AS T2 ON T1.student_id = T2.student_id WHERE T2.Cat = "Cat" AND T2.Dog = "Dog" SELECT T1.fname FROM Students AS T1 JOIN Students AS T2 ON T1.fname = T2.fname WHERE T2.pets = 'Cat' INTERSECT SELECT T1.fname FROM Students AS T1 JOIN Students AS T2 ON T SELECT Major, Age FROM STUDENT WHERE Student_ID NOT IN (SELECT Student_ID FROM STUDENT WHERE Student_ID NOT IN (SELECT Student_ID FROM STUDENT WHERE Student_ID NOT IN (SELECT Student_ID FROM STUDENT WHERE Student_ID SELECT Major_of_student WHERE Student_ID NOT IN (SELECT Student_ID FROM Student WHERE Student_ID NOT IN (SELECT Student_ID FROM Student WHERE Student_ID NOT IN (SELECT Student_ID FROM Student WHERE Student_ID NOT IN (SELECT Student_ SELECT T1.student_id FROM STUDENT AS T1 JOIN Students AS T2 ON T1.student_id = T2.student_id WHERE T2.Cat_Pet NOT IN (SELECT T1.student_id FROM STUDENT AS T1 JOIN Student_Cat_Pet SELECT T1.id FROM Students AS T1 JOIN pets AS T2 ON T1.student_id = T2.student_id WHERE T2.pets NOT IN (SELECT T1.student_id FROM Students AS T1 JOIN pets AS T2 ON T1.student_ SELECT T1.first_name, T1.age FROM STUDENT AS T1 JOIN pets AS T2 ON T1.student_id = T2.student_id WHERE T2.name = "Cat" AND T1.age = "F" SELECT T1.fname FROM Student AS T1 JOIN Student AS T2 ON T1.stuid = T2.stuid WHERE T2.name = "Cat" AND T1.name = "Cat" SELECT T1.Type, T1.Weight, ORDER BY T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1. SELECT TYPE_of_pets, COUNT(*) FROM pets WHERE age = (SELECT avg(age) FROM pets) SELECT T1.id, T2.weight FROM pets AS T1 JOIN pets AS T2 ON T1.pets_id = T2.pets_id WHERE T1.age > 1 SELECT T1.id, T1.weight FROM pets AS T1 JOIN pets AS T2 ON T1.pets_id = T2.pets_id WHERE T2.age < 1 SELECT avg(age), max(age) FROM pets SELECT avg(age), max(age) FROM pets SELECT avg(weight) FROM pets SELECT avg(weight) FROM pets SELECT T1.first_name, T1.age FROM STUDENT AS T1 JOIN Students AS T2 ON T1.student_id = T2.student_id WHERE T2.pets = 'Pet' SELECT DISTINCT T1.first_name, T1.age FROM Students AS T1 JOIN Students AS T2 ON T1.student_id = T2.student_id WHERE T2.pets = 'pets' SELECT T1.id FROM pets AS T1 JOIN student AS T2 ON T1.student_id = T2.student_id WHERE T2.last_name = 'Smith' SELECT T1.id FROM pets AS T1 JOIN student AS T2 ON T1.student_id = T2.student_id WHERE T2.last_name = 'Smith' SELECT count(*) FROM Student WHERE Student_ID NOT IN (SELECT Student_ID FROM Student_ID) SELECT T1.student_id FROM Students AS T1 JOIN Student_pets AS T2 ON T1.student_id = T2.student_id GROUP BY T1.student_id HAVING count(*) >= 1 SELECT T1.first_name, T1.gender FROM STUDENT AS T1 JOIN Student AS T2 ON T1.stuid = T2.stuid WHERE T2.pets = 1 SELECT T1.Fname, T1.Fname, T1.Fname, T1.Fname, T1.Fname, T1.Fname, T1.Fname, T1.Fname, T1.Fname, T1.Fname, T SELECT T1.last_name FROM STUDENT AS T1 JOIN Student AS T2 ON T1.stuid = T2.stuid WHERE T2.age = 3 AND T2.age = 3 SELECT T1.last_name FROM Student AS T1 JOIN Student AS T2 ON T1.stuid = T2.stuid WHERE T2.year_old = 3 SELECT avg(age) FROM STUDENT WHERE pets NOT IN (SELECT pets FROM STUDENT WHERE pets NOT IN (SELECT pets FROM STUDENT WHERE pets NOT IN (SELECT pets FROM STUDENT WHERE pets NOT IN (SELECT pets F SELECT avg(age) FROM STUDENT WHERE NOT IN (SELECT avg(age) FROM STUDENT WHERE NOT IN (SELECT avg(age) FROM STUDENT WHERE NOT IN (SELECT avg(age) FROM STUDENT WHERE NOT IN (SELECT avg(age) F SELECT count(*) FROM COUNT(*) LIKE SELECT count(*) FROM COUNT(*) LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE SELECT count(*) FROM COUNT(*) GROUP BY COUNT(*) ORDER BY count(*) DESC LIMIT 1 SELECT count(*), continent_name, count(*) FROM COUNT(*) GROUP BY continent_id SELECT T1.Name, count(*), count(*) FROM COUNT(*) AS T1 JOIN COUNT(*) AS T2 ON T1.Country_ID = T2.Country_ID GROUP BY T1.Country_ID SELECT count(*) FROM COUNT(*) GROUP BY country SELECT count(DISTINCT COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), SELECT count(*), COUNT(*), count(*) FROM maker SELECT T1.full_name, count(*) FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.id = T2.id GROUP BY T1.id ORDER BY count(*) DESC LIMIT 1 SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Model_of_Car, T1.Horsepower FROM vehicles AS T1 JOIN trucks AS T2 ON T1.Car_Horse_Power = T2.Horse_Power GROUP BY T1.Model_of_Car ORDER BY T1.Horse_Power SELECT T1.Model_of_Car WHERE T1.Weight < (SELECT avg(T1.Weight) FROM vehicles AS T1 JOIN vehicles AS T2 ON T1.Model_of_Car_Model_of_Car_Model_of_Car_Model_of_Car SELECT T1.Model_for_vehicle_with_weight_smaller_than_average FROM vehicles AS T1 JOIN drivers AS T2 ON T1.Car_engine_engine_engine_engine_engine_engine_engine_engine_engine_engine_engine_engine_ SELECT T1.name FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.manufacturers_id = T2.manufacturers_id WHERE T2.year_of_1970 = "Made in '1970' SELECT DISTINCT T1.name FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.manufacturers_id = T2.manufacturers_id WHERE T1.year_in_1970 = "1970" SELECT T1.make, T1.production_time FROM vehicles AS T1 JOIN manufacturers AS T2 ON T1.make_id = T2.make_id WHERE T2.year = '2016' AND T2.year = 'Made' ORDER BY SELECT T1.Maker_of_Carr AS T1 JOIN manufacturers AS T2 ON T1.Manufactured_in_year = T2.Made_in_year WHERE T2.Year_of_Product_Made_in_year = '2007' AND T1. SELECT DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.D SELECT DISTINCT T1.Model_Model FROM cards AS T1 JOIN cards AS T2 ON T1.Cards_manufacturer_id = T2.Cards_manufacturer_id WHERE T2.Year_Made < 1980 SELECT count(*), count(*) FROM manufacturers GROUP BY count(*) SELECT T1.name, count(*) FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.manufacturer_id = T2.manufacturer_id GROUP BY T1.country_id SELECT Country_name FROM country GROUP BY Country_name ORDER BY COUNT(*) DESC LIMIT 1 SELECT T1.country_name FROM manufacturers AS T1 JOIN country AS T2 ON T1.country_name = T2.country_name ORDER BY count(*) DESC LIMIT 1 SELECT count(*), maker_full_name FROM manufacturers AS t1 JOIN manufacturers AS t2 ON t1.manufacturers_id = t2.manufacturers_id GROUP BY t1.maker_full_name SELECT count(*), COUNT(*) FROM manufacturers AS t1 JOIN manufacturers AS t2 ON t1.manufacturers_id = t2.manufacturers_id GROUP BY t1.maker SELECT T1.FROM Wheels AS T1 JOIN Wheels AS T2 ON T1.Stu = T2.Stu = T2.Stu = T2.Stu = T2.Stu = T2.Stu = T2.Stu = T2. SELECT sum(accelerate_amount) FROM races AS T1 JOIN drivers AS T2 ON T1.ac_hornet_Sportabout = T2.ac_hornet_Sportabout WHERE T1.make_name = "amc hornet sportabout" SELECT count(*) FROM manufacturers WHERE country = "france" SELECT count(*) FROM makers_of_care WHERE country = "France" SELECT count(*) FROM GROUP BY COUNT(*) GROUP BY COUNT(*) GROUP BY COUNT(*) GROUP BY COUNT(*) GROUP BY COUNT(*) GROUP BY COUNT(*) GROUP BY COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) SELECT count(*) FROM ORDER BY COUNT(*) DESC LIMIT 1 SELECT avg(mpg) FROM vehicles WHERE 4 cylinders = 4 SELECT avg(miles_per_gallon) FROM cards WHERE 4 cylinders = 4 SELECT t1.smallest_weight FROM vehicles AS t1 JOIN cylinders AS t2 ON t1.engine_engine_engine_engine_engine_engine_engine_engine_engine_engine_engine_engine_engine_engine_engine_engine_engine SELECT max(weight) FROM vehicles WHERE 8 cylinders = 8 GROUP BY max(weight) ORDER BY COUNT(*) DESC LIMIT 1 SELECT makers, models FROM makers AND models SELECT makers, models FROM manufacturers AND models SELECT country_name, id FROM manufacturers GROUP BY country_name HAVING COUNT(*) >= 1 SELECT T1.Name, T1.Id FROM country AS T1 JOIN country_manufacturers AS T2 ON T1.Country_ID = T2.Country_ID GROUP BY T1.Country_ID HAVING COUNT(*) >= 1 SELECT count(*) FROM RECORD COUNT ORDER BY COUNT(*) DESC LIMIT 1 SELECT count(*) FROM vehicles WHERE horsepower > 150 GROUP BY COUNT(*) HAVING count(*) > 150 SELECT avg(weight) FROM vehicles GROUP BY avg(weight) SELECT avg(weight), year FROM eating SELECT Country_in_Europe FROM manufacturers GROUP BY Country_in_Europe HAVING COUNT(*) >= 3 SELECT T1.Name FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.Country_ID = T2.Country_ID WHERE T2.Manufacturers = 3 SELECT max(Horsepower), max(Horsepower) FROM vehicles WHERE 3 cylinders = 3 SELECT max(Horsepower), max(Horsepower) FROM Motorcycles WHERE 3 cylinders = 3 AND TYPE_ID = 3 SELECT T1.Model_savings, T1.Fuel_savings, T1.Fuel_savings, T1.Fuel_savings, T1.Fuel_savings, T1.Fuel_savings, T1.Fuel_savings, T1.Fuel_saving SELECT T1.Model_Model_with_highest_mpg FROM vehicles AS T1 JOIN drivers AS T2 ON T1.Car_Model_with_high_mpg = T2.Car_Model_with_high_mpg GROUP BY T1.Model_Model SELECT avg(Horsepower) FROM vehicles WHERE 1980 = "high" AND age < 1980 SELECT avg(Horsepower) FROM vehicles WHERE TYPE_Made_Before 1980 = "Made" AND TYPE_Made_Before_1980 = "Made" AND TYPE_Made_Before_1980 = "Made" AND TYPE_Made_Before_1980 SELECT avg(ED) FROM vehicles WHERE Model_Volvo = "Volvo" SELECT avg(ED) FROM VOLVOS SELECT max(accelerate) FROM Cylinders SELECT max(accelerate) FROM Cylinders SELECT T1.Model, T1.Model_of_Model, T1.Model_of_Model, T1.Model_of_Model, T1.Model_of_Model, T1.Model_of_Model, T1.Model_of_Model, T1. SELECT t1.model_id, t2.model_id FROM versions AS t1 JOIN versions AS t2 ON t1.model_id = t2.model_id GROUP BY t1.model_id ORDER BY count(*) DESC SELECT count(*) FROM vehicles WHERE cylinders > 4 SELECT count(*) FROM vehicles WHERE cylinders > 4 SELECT count(*), count(*) FROM COUNT(*) GROUP BY COUNT(*) DESC LIMIT 1 SELECT count(*) FROM COUNT(*) GROUP BY COUNT(*) COUNT(*) >= 2000 SELECT count(*) FROM manufacturers WHERE t1.full_name = "American Motor Company" AND t2.full_name = "American Motor Company" SELECT count(*) FROM manufacturers AS t1 JOIN manufacturers AS t2 ON t1.American Motor Company = t2.American Motor Company WHERE t1.American Motor Company = 'American Motor Company' SELECT T1.Name, T1.Model_ID FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer_id = T2.Manufacturer_id GROUP BY T1.Model_ID HAVING count(*) > 3 SELECT T1.Name, T1.Id FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.Model_ID = T2.Model_ID WHERE T2.Model_Height > 3 SELECT DISTINCT T1.Model_Name FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer_name = T2.Manufacturer_name WHERE T1.Full_name = "General Motors" OR T1.Weight > 3500 SELECT DISTINCT T1.Model_name FROM vehicles AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer_name = T2.Manufacturer_name WHERE T2.Weight > 3500 OR T1.Model_name = "General Motors" OR SELECT T1.Year_Made_by_Year_Made_by_Year_Made_by_Year_Made_by_Year_Made_by_Year_Made_by_Year_Made_by_Year_Made_by_Year_Made_by_Year_Made_by SELECT DISTINCT T1.Year_in_T1.Year_in_T1.Year_in_T1.Year_in_T1.Year_in_T1.Year_in_T1.Year_in_T1.Year_in_T1.Year_in_T1.Year_ SELECT Horsepower FROM vehicles WHERE Accelerate = "high" AND Accelerate = "accelerate" SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT count(*) FROM vehicle WHERE t1.accelerate = "low" AND t2.engine_id = "high" SELECT count(*) FROM volvo_model WHERE t1.accelerate = "high" AND t2.engine_accelerate = "accelerate" SELECT count(*) FROM races WHERE horsepower > (SELECT max(horsepower) FROM races) SELECT count(*) FROM vehicles WHERE Accelerate > (SELECT avg(Horsepower) FROM races) SELECT count(*) FROM manufacturers GROUP BY country HAVING count(*) > 2 SELECT count(*) FROM country WHERE country_name = 2 GROUP BY country_name HAVING count(*) > 2 SELECT count(*) FROM vehicles WHERE cylinders > 6 SELECT count(*) FROM vehicles WHERE cylinders > 6 SELECT t1.Model_Model_FROM vehicles AS t1 JOIN cylinders AS t2 ON t1.Model_ID = t2.Model_ID WHERE t2.Horsepower = 4 SELECT t1.Model_id, t2.Horsepower FROM 4 cylinder GROUP BY t1.Model_id ORDER BY t1.Horsepower DESC LIMIT 4 SELECT T1.makeid, T1.makename FROM vehicles AS T1 JOIN cylinders AS T2 ON T1.carid = T2.carid WHERE T2.Horsepower > 3 SELECT T1.make_id, T1.make_name FROM vehicles AS T1 JOIN cylinders AS T2 ON T1.engine_id = T2.engine_id WHERE T2.horsepower > 4 GROUP BY T1.make_id HAVING count(*) > SELECT max(miles_per_gallon) FROM vehicles WHERE TYPE_8 = 8 OR TYPE_Made_Before 1980 = "8" OR TYPE_Made_Before 1980 = "8" OR TYPE_Made_Before 1980 = "8 SELECT max(mpg) FROM vehicles WHERE TYPE_NO = 8 OR TYPE_NO = '8' OR TYPE_NO = '1980' SELECT T1.Model_Height FROM vehicles AS T1 JOIN built AS T2 ON T1.Ford_Motor_Company = T2.Ford_Motor_Company WHERE T2.Engine_Engine_Engine_Engine_Engine_Engine_Engine_Engine_Engine_Engine_Engine SELECT DISTINCT T1.Model_Name FROM vehicles AS T1 JOIN built_by_Ford_Motor Company AS T2 ON T1.Ford_MotorCompany = T2.Ford_MotorCompany WHERE T2.lighter_than 3500 NOT IN (SELECT T1.Model_Name SELECT T1.country_name FROM countries AS T1 JOIN manufacturers AS T2 ON T1.country_name = T2.country_name WHERE T2.company_name = 'Honda' SELECT T1.country_name FROM country AS T1 JOIN country AS T2 ON T1.country_id = T2.country_id WHERE T2.no_car_makers = 'NO' SELECT T1.id, T1.maker FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.id = T2.id GROUP BY T1.id HAVING count(*) > 2 AND T2.make_of_product >= 3 SELECT T1.id, T1.makers FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.manufacturers_id = T2.manufacturers_id WHERE T2.Model_Height > 2 AND T1.Model_Height > 3 SELECT T1.country_id, T1.country_name FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.manufacturers_id = T2.manufacturers_id GROUP BY T1.country_id HAVING count(*) > 3 SELECT T1.Country_ID, T1.Name FROM manufacturers AS T1 JOIN manufacturers AS T2 ON T1.Made_in_China = T2.Made_in_Italy AS T3 ON T1.Made_in_Italy = T3.Made_in_ SELECT Country FROM airline WHERE Carrier = "JetBlue Airways" SELECT Country FROM affiliated_with WHERE affiliated_with = "Jetblue Airways" SELECT T1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t SELECT T1. WHERE T1.Name = 'T2.Airways' SELECT T1.airline_name, T1.airline_abbreviation_from, T1.airline_abbreviation_from, T1.airline_abbreviation_from, T1.airline_abbreviation_from, T1.airline_abbreviation_from SELECT T1.Aircraft_Name, T1.Aircraft_Abbreviation FROM airlines AS T1 JOIN airlines AS T2 ON T1.Aircraft_USA = T2.Aircraft_USA SELECT T1.At t1.At t1.At t2.At t2.At2.At2.At2.At2.At2.At2.At2.At2.At2.At2.At2.At2.At2. SELECT T1.At, T1.At, T1.At, T1.At, T1.At, T1.At, T1.At, T1.At, T1.At, T1.At, T SELECT count(*) FROM airlines WHERE airline_id NOT IN (SELECT airline_id FROM airlines) SELECT sum(T1.total_airlines) FROM airlines AS T1 JOIN airlines AS T2 ON T1.airline_id = T2.airline_id GROUP BY T1.airline_id SELECT count(*) FROM COUNT(*) t1.How_many_airports = t2.How_many_airports_to t1.How_many_airports_to t1.How_many_airports_to t1.How_many_airports_ SELECT count(*) FROM a_airports ORDER BY COUNT(*) DESC LIMIT 1 SELECT count(*) FROM Flights WHERE airline_id NOT IN (SELECT airline_id FROM Flights) SELECT count(*) FROM Flights SELECT T1.Aircraft FROM airline AS T1 JOIN airlines AS T2 ON T1.Aircraft = T2.Aircraft WHERE T2.Aircraft_Abbreviation = 'UAL' SELECT T1.airline_with_abbreviation FROM airline AS T1 JOIN airline AS T2 ON T1.airline_id = T2.airline_id WHERE T2.abbreviation = 'UAL' SELECT count(*) FROM airlines WHERE airline_name = "USA" SELECT count(*) FROM airlines WHERE country_is_in_USA = "USA" SELECT T1.city, T1.city, T2.Country, T2.Country, T2.Country, T2.Country, T2.Country, T2.Country, T2.Country, T2.Country, T2.Country, T2.Country, T SELECT T1.city, T1.city FROM ORDER BY T1.city ORDER BY T1.city DESC LIMIT 1 SELECT airport_name FROM airports WHERE airport_name = 'AKO' SELECT T1.Name FROM airports AS T1 JOIN airports AS T2 ON T1.Airport_code = T2.Airport_code WHERE T2.Code = 'AKO' SELECT T1.airport_name FROM airports AS T1 JOIN airports AS T2 ON T1.city_id = T2.city_id WHERE T2.city_name = 'Aberdeen' SELECT T1.name, T1.name FROM ORDER BY T1.name ORDER BY T1.name DESC LIMIT 1 SELECT count(*) FROM Flights WHERE departure_from 'APG' SELECT count(*) FROM Flights WHERE departure_from 'APG' SELECT count(*) FROM Flights WHERE destination = 'ATO' SELECT count(*) FROM Flights WHERE ATO = "ATO" SELECT count(*) FROM Flights WHERE City_Aberdeen = "City Aberdeen" SELECT count(*) FROM Flights WHERE departure_from = "Aberdeen" SELECT count(*) FROM Flights WHERE city = "Aberdeen" SELECT count(*) FROM Flights WHERE LOCATION = "Aberdeen" SELECT count(*) FROM Flights WHERE City 'Aberdeen' AND destination = 'Ashley' SELECT count(*) FROM Flights WHERE Ashley = "Aberdeen" AND Ashley = "Ashley" SELECT count(*) FROM airlines WHERE airline = 'JetBlue Airways' SELECT count(*) FROM Flights WHERE airline_name = "Jetblue Airways" SELECT count(*) FROM Flights WHERE Airport 'ASY' = 'United Airlines' AND LOCATION = 'United Airlines' SELECT count(*) FROM airlines WHERE ASY Airport = "ASY Airport" SELECT count(*) FROM Flights WHERE Airport 'AHD' = 'United Airlines' AND departures = 'United Airlines' SELECT count(*) FROM flights WHERE AHD Airport = "AHD Airport" SELECT count(*) FROM Flights WHERE City 'Aberdeen' SELECT count(*) FROM airlines WHERE Arrival_in_Aberdeen = "United Airlines" AND Arrival_in_Aberdeen = "United Airlines" SELECT city, county, city_city FROM airlines GROUP BY city ORDER BY count(*) DESC LIMIT 1 SELECT T1. WHERE T1.city = t2. WHERE T1.city = 'Top_FROM ORDER BY T1. COUNT(*) DESC LIMIT 1 SELECT city, county, city_city FROM departures GROUP BY city ORDER BY count(*) DESC LIMIT 1 SELECT T1. WHERE T1.city = t2. WHERE T1.city = t2. WHERE T1.city = t2. WHERE T1.city = t2. WHERE T1.city = t2. WHERE T1.city = t SELECT T1.code FROM airport AS T1 JOIN flights AS T2 ON T1.apid = T2.apid GROUP BY T1.apid ORDER BY count(*) DESC LIMIT 1 SELECT airport_code FROM airports GROUP BY airport_code ORDER BY count(*) DESC LIMIT 1 SELECT T1.code FROM airport AS T1 JOIN flights AS T2 ON T1.apid = T2.apid WHERE T2.number_of_flights = 'F' GROUP BY T1.apid HAVING count(*) >= 1 SELECT airport_code FROM airports GROUP BY airport_code ORDER BY COUNT(*) DESC LIMIT 1 SELECT t1.airline, t2.number_of_flights FROM airline AS t1 JOIN airline AS t2 ON t1.apid = t2.apid GROUP BY t1.airline ORDER BY count(*) DESC LIMIT 1 SELECT t1.airline_id FROM airline AS t1 JOIN airline AS t2 ON t1.apid = t2.apid GROUP BY t1.airline_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.Aircraft, T1.Country FROM airline AS T1 JOIN airline AS T2 ON T1.Aircraft = T2.Aircraft GROUP BY T1.Aircraft ORDER BY count(*) DESC LIMIT 1 SELECT T1.Aircraft_Abbreviation FROM airlines AS T1 JOIN flights AS T2 ON T1.Aircraft_Ins_in_Country = T2.Aircraft_Ins_in_Country GROUP BY T1.Aircraft_Ins_in_ SELECT T1.airline_name FROM airlines AS T1 JOIN flights AS T2 ON T1.aid = T2.aid WHERE T2.airport = 'AHD' SELECT T1.Aircraft FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.Aircraft_ID = T2.Aircraft_ID WHERE T2.source_airport_AHD = 'AHD' SELECT airline_id FROM airlines WHERE airport 'AHD' = 'AHD' SELECT T1.Aircraft FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.Aircraft = T2.Aircraft WHERE T2.Destination_Airport AHD = 'AHD' SELECT t1.airline_id FROM airlines AS t1 JOIN flights AS t2 ON t1.aPG = t2.aPG' INTERSECT SELECT t1.airline_id FROM airlines AS t1 JOIN flights SELECT t1.airline_id FROM airlines AS t1 JOIN flights AS t2 ON t1.aPG = t2.aPG INTERSECT SELECT t1.airline_id FROM airlines AS t1 JOIN flights AS SELECT t1.airline_id FROM airlines AS t1 JOIN flights AS t2 ON t1.apid = t2.apid WHERE t1.apid = 'CVO' AND t2.apid = 'A SELECT t1.APG airport FROM airlines AS t1 JOIN departures AS t2 ON t1.APG airports AS t3 ON t2.APG airports = t3.APG airports WHERE t3.A SELECT T1.Aircraft FROM airlines AS T1 JOIN airlines AS T2 ON T1.Aircraft = T2.Aircraft GROUP BY T1.Aircraft HAVING count(*) >= 10 SELECT t1.airline_id FROM airlines AS t1 JOIN airlines AS t2 ON t1.apid = t2.apid GROUP BY t1.airline_id HAVING count(*) > 10 SELECT airline_id FROM airlines WHERE airline_id > 200 GROUP BY airline_id HAVING COUNT(*) > 200 SELECT t1.airline_id FROM airlines AS t1 JOIN airlines AS t2 ON t1.apid = t2.apid WHERE t2.number_of_flights > 200 SELECT Flight_Number FROM airline WHERE airline_name = "United Airlines" SELECT T1.Number FROM Flight AS T1 JOIN Flight AS T2 ON T1.United Airlines = T2.United Airlines GROUP BY T1.Number HAVING count(*) = T2.United Airlines ORDER BY count(*) DESC LIMIT 1 SELECT count(*) FROM Flights WHERE Airport "APG" = "APG" SELECT count(*) FROM Flights WHERE APG = "APG" SELECT count(*) FROM Flights WHERE Airport "APG" = "APG" SELECT count(*) FROM flights landing AS T1 JOIN flights AS T2 ON T1.FROM flights AS T1 JOIN flights AS T2 ON T1.FROM flights AS T1 JOIN flights AS T2 ON T1.FROM flights AS T SELECT count(*) FROM Flights WHERE City = "Aberdeen " SELECT count(*) FROM Flights WHERE departure_from = "Aberdeen" SELECT count(*) FROM Flights WHERE City = "Aberdeen" SELECT count(*) FROM Flights WHERE LOCATION = "Aberdeen" SELECT count(*) FROM Flights WHERE city_of_Aberdeen OR city_of_Abilene = "Aberdeen" OR city_of_Abilene = "Abilene" SELECT count(*) FROM Flights WHERE LOCATION = "Aberdede" OR LOCATION = "Abilene" SELECT T1.Name FROM airports AS T1 JOIN airlines AS T2 ON T1.Aircraft_ID NOT IN (SELECT T1.Airport_ID FROM airports AS T1 JOIN flights AS T2 ON T1.Aircraft_ID = T2.Aircraft SELECT airport_from_or_arriving FROM airports WHERE departures = 'F' OR arrivals = 'Aircraft' SELECT count(*) FROM employees SELECT count(*) FROM employees SELECT T1.Name_by_Age, T1.Age_in_Ascending FROM Employees AS T1 JOIN Employees AS T2 ON T1.Employee_Name_by_Age = T2.Employee_Name_by_Age AS T1 JOIN Employee SELECT T1.Name_of_Employee, T1.Order_of_Age ORDER BY T1.Age ASC SELECT count(*) FROM employees GROUP BY city SELECT count(*) FROM employees GROUP BY city SELECT t1.city FROM employees AS t1 JOIN employees AS t2 ON t1.city = t2.city WHERE t1.age_ 30 = "under" AND t2.age_ 30 = "under" SELECT T1.city_city FROM employees AS T1 JOIN employees AS T2 ON T1.city_id = T2.city_id GROUP BY T1.city_id HAVING count(*) > 1 SELECT count(*) FROM shops GROUP BY location SELECT count(*) FROM shops GROUP BY location SELECT T1.manager_name, T1.district FROM shop AS T1 JOIN products AS T2 ON T1.shop_id = T2.shop_id WHERE T2.number_of_product_items = '%' SELECT T1.manager_name, T1.district FROM Shop AS T1 JOIN Products AS T2 ON T1.Shop_ID = T2.Shop_ID GROUP BY T1.Shop_ID ORDER BY count(*) DESC LIMIT 1 SELECT min(product_quantity), max(product_quantity) FROM stores SELECT min(total_items), max(total_items) FROM products GROUP BY shop SELECT T1.Name, T1.Location, T1.District FROM shops AS T1 JOIN products AS T2 ON T1.Shop_ID = T2.Shop_ID ORDER BY T1.Number_of_Product SELECT T1.Shop_Name, T1.Location, T1.District FROM shops AS T1 JOIN shops AS T2 ON T1.Shop_ID = T2.Shop_ID GROUP BY T1.Shop_ID SELECT T1.Name FROM stores AS T1 JOIN stores AS T2 ON T1.Store_ID = T2.Store_ID WHERE T2.Number_of_product_items > (SELECT avg(T2.Average_Number_of_product) FROM stores AS SELECT shop_name FROM products AS t1 JOIN products AS t2 ON t1.shop_name = t2.shop_name GROUP BY shop_name HAVING count(*) > (SELECT avg(product_average) FROM products) SELECT T1.name FROM Employee AS T1 JOIN Employee AS T2 ON T1.Employee_ID = T2.Employee_ID ORDER BY count(*) DESC LIMIT 1 SELECT T1.Employee_Name FROM Employees AS T1 JOIN Employees AS T2 ON T1.Employee_Name = T2.Employee_Name ORDER BY T1.Award DESC LIMIT 1 SELECT T1.Name FROM Employee AS T1 JOIN Employees AS T2 ON T1.Employee_ID = T2.Employee_ID WHERE T2.Get_The_High_One_Time_Bonus = 1 SELECT T1.Fname, T1.FName FROM Employees AS T1 JOIN Employees AS T2 ON T1.Fname = 'FHERE BETBBIGBIGBBIGBIGBBIG%BBIG%Biggest_Bonus GROUP BY T1.F SELECT T1.Name FROM employees AS T1 JOIN Employees AS T2 ON T1.Employees_ID = T2.Employees_ID WHERE T1.Never_Win_Award_in_Award = "Never" SELECT T1.Name FROM employees AS T1 JOIN Employees AS T2 ON T1.Employees_ID = T2.Employees_ID WHERE T1.Employee_Name = "Never" AND T2.Employee_ID NOT IN (SELECT T1.Employee_Name F SELECT T1.Name FROM shops AS T1 JOIN employees AS T2 ON T1.Shop_ID = T2.Shop_ID GROUP BY T1.Shop_ID ORDER BY count(*) DESC LIMIT 1 SELECT T1.Shop_name FROM employees AS T1 JOIN shop AS T2 ON T1.Shop_Name = T2.Shop_Name GROUP BY T1.Shop_Name ORDER BY count(*) DESC LIMIT 1 SELECT T1.Name FROM shops AS T1 JOIN shops AS T2 ON T1.Shop_ID = T2.Shop_ID WHERE T2.Employees NOT IN (SELECT T1.Shop_ID FROM shops AS T1 JOIN employees AS T2 ON T SELECT T1.Shop_Name FROM Shops AS T1 JOIN Shops AS T2 ON T1.Shop_Name = T2.Shop_Name WHERE T2.Employees = "no" SELECT count(*) FROM employees GROUP BY shop_name SELECT count(*), T1.Name_of_Shop, T1.Name_of_Shop FROM employees AS T1 JOIN shop AS T2 ON T1.Shop_ID = T2.Shop_ID GROUP BY T1.Shop_ID SELECT sum(T1.bonus) FROM evaluations AS T1 JOIN evaluations AS T2 ON T1.evaluations_id = T2.evaluations_id WHERE T2.name = "Good" AND T2.name = "Good" SELECT sum(T1.Bonus) FROM evaluations AS T1 JOIN evaluations AS T2 ON T1.Assessment_ID = T2.Assessment_ID GROUP BY T1.Assessment_ID SELECT T1.info_of_hire_info FROM hiring AS T1 JOIN hiring AS T2 ON T1.hire_id = T2.hire_id GROUP BY T1.hire_id SELECT T1.All_details_of_hire FROM hiring AS T1 JOIN hiring AS T2 ON T1.hire_id = T2.hire_id WHERE T2.hire_name = "hiring" SELECT district FROM stores WHERE products > 3000 AND stores > 10000 SELECT district FROM shops WHERE shops_selling_less_of 3000 products INTERSECT SELECT district FROM shops WHERE shops_selling_high_high_high_high_high_high_high_high_high_high_high_high_high_high SELECT count(*), count(*) FROM LOCATION GROUP BY COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) SELECT count(*), count(*) FROM ORDER BY COUNT(*) DESC LIMIT 1 SELECT count(*) FROM Documents GROUP BY Documents GROUP BY Documents GROUP BY Documents GROUP BY Documents GROUP BY Documents GROUP BY Documents GROUP BY Documents GROUP BY Documents GROUP BY Documents GROUP BY Documents GROUP BY Documents SELECT count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*), count(*), count SELECT document_IDs, document_descriptions,,,,,,,,,,,,,,,,,,,,,,,,, SELECT T1.id, T1.name, T1.descriptions, T1.descriptions FROM documents AS T1 JOIN documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id SELECT T1.document_name, T1.template_id FROM Documents AS T1 JOIN Document_Description AS T2 ON T1.document_description_with_letter 'w' SELECT T1.Name, T1.TemplateId FROM documents AS T1 JOIN Documents AS T2 ON T1.Document_Description = T2.Document_Description WHERE T2.letter_w LIKE "%w%" SELECT document_id, template_id, t1.title_description FROM Documents AS t1 JOIN Document_Types AS t2 ON t1.document_id = t2.document_id WHERE t1.name = "Robbin CV" SELECT T1.document_id, T1.template_id, T1.title_description FROM Documents AS T1 JOIN Document_Types AS T2 ON T1.document_id = T2.document_id WHERE T2.name = "Robin CV" SELECT count(DISTINCT t1.template_id) FROM Documents AS t1 JOIN Documents AS t2 ON t1.document_id = t2.document_id GROUP BY t1.document_id SELECT count(DISTINCT t1.template_id) FROM Documents AS t1 JOIN Documents AS t2 ON t1.document_id = t2.document_id GROUP BY t1.document_id SELECT count(*) FROM Documents WHERE TYPE_code = 'PPT' SELECT count(*) FROM Documents WHERE PPT_type = "PPT" SELECT T1.id, count(*) FROM Documents AS T1 JOIN Document_Templates AS T2 ON T1.template_id = T2.template_id GROUP BY T1.template_id SELECT DISTINCT DISTINCT T1.TemplateId, count(*) FROM Documents AS T1 JOIN Documents AS T2 ON T1.Documents_ID = T2.Documents_ID SELECT T1.id, T1.type_code, T1.type_code FROM Documents AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.id, T1.type_code FROM Documents AS T1 JOIN Templates AS T2 ON T1.template_id = T2.template_id GROUP BY T1.template_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.ID FROM Documents AS T1 JOIN Document_Types AS T2 ON T1.Document_ID = T2.Document_ID GROUP BY T1.ID HAVING count(*) > 1 SELECT T2.Template_ID FROM Templates AS T1 JOIN Documents AS T2 ON T1.T1.Document_ID = T2.Document_ID WHERE T2.Title_Type_of_Documents > 1 SELECT T1.ID FROM Documents AS T1 JOIN Document_IDs AS T2 ON T1.Document_ID = T2.Document_ID WHERE T2.Name = "Documents" SELECT T1.id FROM Documents AS T1 JOIN Documents AS T2 ON T1.Documents_to_be_used_in_documents AS T3 ON T1.Documents_to_be_used_in_documents AS T4 ON T1.Documents_to_be SELECT count(*) FROM templates WHERE templates_available NOT IN (SELECT templates_available) FROM templates WHERE templates_available NOT IN (SELECT templates_available) FROM templates WHERE templates_available) SELECT count(*) FROM templates SELECT T1.template_id, T1.template_type_code, T1.template_type_code FROM templates AS T1 JOIN templates AS T2 ON T1.template_id = T2.template_id GROUP BY T1.template_id HAVING count SELECT T1.id, T1.version_number, T1.type_code FROM templates AS T1 JOIN templates AS T2 ON T1.template_id = T2.template_id GROUP BY T1.template_id SELECT DISTINCT T1.template_type_code FROM Templates AS T1 JOIN Templates AS T2 ON T1.template_type_code = T2.template_type_code GROUP BY T1.template_type_code SELECT DISTINCT T1.TemplateType_Code FROM Templates AS T1 JOIN Templates AS T2 ON T1.TemplateType_Code = T2.TemplateType_Code SELECT T1.id FROM templates AS T1 JOIN templates AS T2 ON T1.template_type_code = T2.template_type_code WHERE T2.type_code = "PP" OR T2.type_code = "PPT" SELECT T1.id FROM templates AS T1 JOIN templates AS T2 ON T1.templates_id = T2.templates_id WHERE T2.code = 'PP' OR T2.code = 'PPT' SELECT count(*) FROM Templates WHERE T1.Type_Code_CV = "CV" SELECT count(*) FROM templates WHERE T1.Type = CV SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Version_Numbers, T2.Type_Code_Code FROM Templates AS T1 JOIN Templates AS T2 ON T1.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T SELECT T1.Type_Code, count(*) FROM Templates AS T1 JOIN Templates AS T2 ON T1.Type_Code = T2.Type_Code GROUP BY T1.Type_Code SELECT DISTINCT T1.type_code, count(*) FROM Templates AS T1 JOIN Templates AS T2 ON T1.template_type_code = T2.template_type_code SELECT T1.type_code FROM Templates AS T1 JOIN Templates AS T2 ON T1.type_code = T2.type_code GROUP BY T1.type_code ORDER BY count(*) DESC LIMIT 1 SELECT T1.type_code FROM Templates AS T1 JOIN Templates AS T2 ON T1.type_code = T2.type_code GROUP BY T1.type_code ORDER BY count(*) DESC LIMIT 1 SELECT T1.Type_Code FROM Templates AS T1 JOIN Templates AS T2 ON T1.Type_Code = T2.Type_Code WHERE T2.Total_Templates > 3 SELECT T1.Code FROM Templates AS T1 JOIN Templates AS T2 ON T1.Template_Types_of_Templates_Types_of_Templates_Types AS T3 ON T1.Template_Types_of_Templates_Types_of_Templates_Types_of_Types_ SELECT T1. t1. t1. t1. t1. t1. t1. t1. t1. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t SELECT t1.f_number, t2.f_type_code FROM Templates AS t1 JOIN Templates AS t2 ON t1.f_code = t2.f_code WHERE t2.theme_type_code = "code SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.type_code FROM Documents AS T1 JOIN Document_Base AS T2 ON T1.document_name = T2.document_name WHERE T2.document_name = "Data base" AND T2.document_name = "Data base" SELECT T1.document_name FROM Documents AS T1 JOIN Document_Documents AS T2 ON T1.document_name = T2.document_name WHERE T2.type_code = "BK" SELECT T1.Name FROM documents AS T1 JOIN Documents AS T2 ON T1.Documents_with_code_BK = T2.Documents_with_code_BK WHERE T2.Code_BK = "BK" SELECT T1.Type_Code, count(*) FROM Documents AS T1 JOIN Document_Types AS T2 ON T1.Type_Code = T2.Type_Code GROUP BY T1.Type_Code SELECT DISTINCT T1.type_code, count(*) FROM Documents AS T1 JOIN Document_Types AS T2 ON T1.document_type_code = T2.document_type_code SELECT T1. WHERE T1. WHERE T1. t1. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. SELECT T1.Code, T1.Code, T1.Code, T1.Code, T1.Code, T1.Code, T1.Code, T1.Code, T1.Code, T1.Code, T1.Code, T1.Code, T SELECT T1.type_code FROM Templates AS T1 JOIN Document_Types AS T2 ON T1.type_code = T2.type_code WHERE T2.name = "No" SELECT T1.Code FROM Templates AS T1 JOIN Templates AS T2 ON T1.Code = T2.Code WHERE T2.Name = "No" SELECT T1.type_code, T1.description FROM Templates AS T1 JOIN Templates AS T2 ON T1.type_code = T2.type_code WHERE T2.description = "code" SELECT T1.type_code, T1.description FROM Templates AS T1 JOIN Templates AS T2 ON T1.template_type_code = T2.template_type_code WHERE T2.type_code = "code" AND T2.type_description = SELECT T1.T1.T1.F.T2.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F.F SELECT T1.T1.T1.T1.T1.T1.T1.T2.T1.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T2.T SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Type_Code FROM TYPE_code ORDER BY T1.Type_Code DESC LIMIT 1 SELECT DISTINCT T1.TemplateType_Description FROM Documents AS T1 JOIN Documents AS T2 ON T1.Documents_type_description = T2.Documents_type_description WHERE T2.Documents_type_name = "document" SELECT DISTINCT T1.Description FROM Documents AS T1 JOIN Documents AS T2 ON T1.Document_ID = T2.Document_ID WHERE T2.Name = "A document" SELECT T1.template_id FROM Templates AS T1 JOIN Templates AS T2 ON T1.template_id = T2.template_id WHERE T1.type_description = "Presentation" SELECT T1.id FROM Templates AS T1 JOIN Templates AS T2 ON T1.template_id = T2.template_id WHERE T1.description = 'Presentation' SELECT count(*) FROM paragraphs SELECT count(*) FROM paragraphs SELECT count(*) FROM Documents WHERE name = 'Summer Show' SELECT count(*) FROM Documents WHERE t1.description = 'Summer Show' SELECT t1.paragraph_details FROM paragraphs AS t1 JOIN paragraphs AS t2 ON t1.paragraph_details = t2.paragraph_details WHERE t1.text = 'Korea ' SELECT T1.details FROM paragraph AS T1 JOIN paragraphs AS T2 ON T1.paragraph_id = T2.paragraph_id WHERE T2.text_name LIKE '%Korea%' SELECT t1.paragraph_id, t2.texts FROM Documents AS t1 JOIN Documents AS t2 ON t1.document_id = t2.document_id WHERE t1.name = 'Welcome to NY' SELECT T1.id, T1.texts FROM Documents AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id WHERE T2.name = 'Welcome to NY' SELECT t1.paragraph_text FROM Customer_Reviews AS t1 JOIN Ref_Documents AS t2 ON t1.document_id = t2.document_id WHERE t1.document_name = "Customer_reviews" SELECT t1.paragraph_text FROM Documents AS t1 JOIN Ref_Texts AS t2 ON t1.document_id = t2.document_id WHERE t1.name = 'Customer reviews' SELECT document_id, count(*) FROM Documents_to_be_publicised SELECT DISTINCT T1.document_id, count(*) FROM Documents AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id SELECT T1.document_id, T1.name, count(*) FROM Documents AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id SELECT T1.id, T1.name, count(*) FROM Documents AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id HAVING count(*) >= 1 SELECT document_id FROM Documents WHERE paragraphs >= 2 SELECT T1.id FROM documents AS T1 JOIN paragraphs AS T2 ON T1.document_id = T2.document_id WHERE T2.paragraphs = 2 OR T2.paragraphs = 2 SELECT T1.document_id, T1.name FROM Documents AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.id, T1.name FROM Documents AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id ORDER BY count(*) DESC LIMIT 1 SELECT document_id, least_number_of_paragraphs FROM Documents GROUP BY document_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.document_id FROM Documents AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id ORDER BY count(*) DESC LIMIT 1 SELECT document_id FROM Documents WHERE paragraphs >= 1 to 2 SELECT T1.Document_ID FROM Documents AS T1 JOIN Documents AS T2 ON T1.Documents_with_Papers = T2.Documents_with_Papers AS T3 ON T1.Documents_with_Papers = T3.Documents_with_Papers SELECT document_id FROM Documents WHERE paragraph_text = 'Brazil' INTERSECT SELECT document_id FROM Documents WHERE paragraph_text = 'Ireland' SELECT T1.id FROM documents AS T1 JOIN paragraphs AS T2 ON T1.document_id = T2.document_id WHERE T2.text_text_text_text_text_text_text_text_text_text_text_text_text_text SELECT count(*) FROM teachers SELECT sum(T1.teacher) FROM teachers AS T1 JOIN teachers AS T2 ON T1.teacher = T2.teacher GROUP BY T1.teacher SELECT T1.Name FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT Age, Hometown FROM teachers WHERE age = (SELECT avg(age), hometown) FROM teachers) SELECT Age, Hometown FROM Teacher SELECT T1.name FROM Teachers AS T1 JOIN Teachers AS T2 ON T1.teacher_name = T2.teacher_name WHERE T2.Hometown!= 'Little Lever Urban District' SELECT T1.Name FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.name FROM classroom AS T1 JOIN classroom_of_student_teacher = T2.teacher_of_student_teacher ORDER BY T1.name_to ORDER BY T1.name_to_to_to_to_to_to_to_to SELECT T1.YEAR FROM Teachers AS T1 JOIN Teachers AS T2 ON T1.YEAR = T2.YEAR ORDER BY T1.YEAR DESC LIMIT 1 SELECT DISTINCT hometown, count(*) FROM teachers SELECT count(*) FROM hometown GROUP BY hometown SELECT T1.Hometown FROM teachers AS T1 JOIN teachers AS T2 ON T1.Hometown = T2.Hometown GROUP BY T1.Hometown ORDER BY count(*) DESC LIMIT 1 SELECT T1.Hometown FROM teachers AS T1 JOIN teachers AS T2 ON T1.Hometown = T2.Hometown WHERE T2.Hometown = "Commmon" AND T2.Hometown = "Lname" SELECT T1.Hometown_shared_by_teachers, T1.Hometown_shared_by_teachers, T1.Hometown_shared_by_teachers, T1.Hometown_shared_by_teachers, T1.Hometown_shared_by_teachers, T SELECT T2.Town FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name_of_T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.name, T1.course_name FROM T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.name, T1.course_name FROM teachers AS T1 JOIN teachers AS T2 ON T1.teacher = T2.teacher ORDER BY T1.name ASC SELECT T1.name, T1.name FROM T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name FROM people AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Math_Courses = "Math" SELECT T1.Name, count(*) FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name, count(*) FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name FROM teachers AS T1 JOIN teaches AS T2 ON T1.T1.T2.T2.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name FROM teachers AS T1 JOIN teachers AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT count(*) FROM Visitors WHERE age 30 = 30 SELECT T1.Name FROM Visitors AS T1 JOIN Visitors AS T2 ON T1.Visitor_ID = T2.Visitor_ID WHERE T2.Membership_level > 4 AND T2.Membership_level > 4 SELECT avg(age) FROM VISITORS WHERE membership_level NOT IN (SELECT membership_level FROM VISITORS WHERE membership_level > 4) SELECT T1.name, T1.membership_level FROM VISITORS AS T1 JOIN VISITORS AS T2 ON T1.Visitor_ID = T2.Visitor_ID WHERE T2.membership_level > 4 AND T2.age > (SELECT avg(membership_level) FROM SELECT T1.id, T1.name FROM museum AS T1 JOIN staff AS T2 ON T1.Museum_ID = T2.Museum_ID GROUP BY T1.Museum_ID ORDER BY count(*) DESC LIMIT 1 SELECT avg(T1.staff_working) FROM museums AS T1 JOIN staff AS T2 ON T1.staff_id = T2.staff_id WHERE T1.opened_before 2009 SELECT opening_year, staff_number FROM MUSEUMS WHERE NAME = "Plaza Museum" SELECT T1.Name FROM museums AS T1 JOIN staff AS T2 ON T1.Museum_ID = T2.Museum_ID WHERE T2.Staff > (SELECT max(staff_number) FROM museums) AS T1 JOIN museums AS T2 ON T1. SELECT T1.name, T1.age, T1.age FROM VISITORS AS T1 JOIN VISITS AS T2 ON T1.Visits_by_Visitors_with_History AS T3 ON T1.Visits_by_History = T3.Visits_ SELECT T1.name, T1.membership_level, T1.membership_level FROM VISITORS AS T1 JOIN VISITORS AS T2 ON T1.Museum_Tickets = T2.Museum_Tickets GROUP BY T1.Museum_Tickets ORDER BY sum(T1.total) SELECT T1.id, T1.name FROM museum AS T1 JOIN museums AS T2 ON T1.museum_id = T2.museum_id GROUP BY T1.museum_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.name FROM museum AS T1 JOIN VISITORS AS T2 ON T1.Museum_ID = T2.Museum_ID WHERE T2.Visitors_YEAR NOT IN (SELECT T1.Museum_ID FROM Visitors AS T3 ON T1.Museum_ID SELECT T1.name, T1.age FROM Visitors AS T1 JOIN Visitors AS T2 ON T1.Visits_ID = T2.Visits_ID GROUP BY T1.Visits_ID ORDER BY count(*) DESC LIMIT 1 SELECT avg(T1.total), max(T1.total) FROM BOOKINGS AS T1 JOIN BOOKINGS AS T2 ON T1.Bookings_by_Bookings = T2.Bookings_by_Bookings AS T3 ON T1.Bookings_by SELECT sum(T1.ticket_expenses) FROM Visitors AS T1 JOIN Memberships AS T2 ON T1.Visitor_level = 1 SELECT T1.name FROM VISITORS AS T1 JOIN VISITS AS T2 ON T1.Visits_by_Visitor_ID = T2.Visits_by_Visitor_ID WHERE T2.opened_before 2009 INTERSECT SELECT T1.name FROM VISITORS AS SELECT count(*) FROM VISITORS WHERE opened_after 2010 SELECT count(*) FROM museums WHERE opened_date < 2013 OR opened_date_date_date_date_date_date_date_date_date_date_date_date_date_date_date_date_date_date_date_date_date_date SELECT sum(T1.total_player) FROM Player AS T1 JOIN Player_Player AS T2 ON T1.Player_ID = T2.Player_ID GROUP BY T1.Player_ID SELECT count(*) FROM Players SELECT sum(T1.Total_matches) FROM matches AS T1 JOIN match_matches AS T2 ON T1.match_matches = T2.match_matches SELECT count(*) FROM matches SELECT T1.first_name, T1.birth_date FROM Players AS T1 JOIN Player_Country AS T2 ON T1.player_id = T2.player_id WHERE T2.country_code = "USA" SELECT T1.first_name, T1.birth_date FROM Players AS T1 JOIN Player AS T2 ON T1.player_id = T2.player_id WHERE T2.country = "USA" SELECT avg(Losers), avg(Winnings) FROM MATCHes SELECT avg(losser), avg(winner) FROM match_season SELECT avg(T1.rank) FROM MATCH AS T1 JOIN MATCH AS T2 ON T1.match_id = T2.match_id GROUP BY T1.match_id ORDER BY avg(T1.rank) DESC LIMIT 1 SELECT avg(rank) FROM MATCHes SELECT highest_rank_of_losers, highest_rank_of_losers FROM MATCHes GROUP BY highest_rank_of_losers ORDER BY count(*) DESC LIMIT 1 SELECT avg(Loser) FROM MATCH GROUP BY MATCH SELECT count(DISTINCT country_code) FROM Player SELECT count(DISTINCT country) FROM player SELECT count(*) FROM COUNT(*) ORDER BY COUNT(*) DESC LIMIT 1 SELECT count(*) FROM COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT SELECT T1.Name FROM tourney AS T1 JOIN MATCH AS T2 ON T1.Tourney_ID = T2.Tourney_ID GROUP BY T1.Tourney_ID HAVING count(*) > 10 SELECT T1.Tournament_Name FROM Tournaments AS T1 JOIN Tournaments AS T2 ON T1.Tournament_ID = T2.Tournament_ID GROUP BY T1.Tournament_ID HAVING count(*) > 10 SELECT T1.Name FROM winners AS T1 JOIN winners AS T2 ON T1.Winning_Year = T2.Winning_Year ORDER BY T1.Winning_Year DESC LIMIT 1 SELECT T1.Name FROM Player AS T1 JOIN Player AS T2 ON T1.Player_Name = T2.Player_Name WHERE T2.Winning = '2013' INTERSECT SELECT T1.Name FROM Player AS T1 JOIN Player AS T2 ON T SELECT count(*) FROM MATCHes WHERE YEAR = 2013 OR YEAR = 2016 SELECT count(*) FROM MATCHes WHERE YEAR BETWEEN 2013 OR 2016 SELECT Country_Code, First_Name FROM Tournament WHERE WTA Championships = 'Australian Open' INTERSECT SELECT Country_Code, First_Name FROM Tournament WHERE WHERE WHERE WHERE WHERE WHERE WHERE WHERE WHERE W SELECT T1.first_name, T1.country_code FROM Players AS T1 JOIN WHERE T2.Wimbledon_Championship = 'WTA Championships' INTERSECT SELECT T1.first_name, T1.country_code FROM Players AS SELECT T1.first_name, T1.country_code FROM Player ORDER BY T1.first_name, T1.country_code ORDER BY T1.first_name, T1.country_code DESC LIMIT 1 SELECT T1.fname, T1.fname, T1.fname, T1.fname, T1.fname, T1.fname, T1.fname, T1.fname, T1.fname, T1.fname, T SELECT T1.first_name, T1.last_name FROM Player AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID ORDER BY T1.birth_date ASC LIMIT 1 SELECT T1.Full_Name FROM Player AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID GROUP BY T1.Birth_Date SELECT T1.first_name, T1.last_name FROM Player AS T1 JOIN Player AS T2 ON T1.player_id = T2.player_id WHERE T2.birth_date = "L" AND T2.birth_date = "L" SELECT T1.Full_name FROM Player AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID ORDER BY T1.Birth_Date SELECT T1.first_name, T1.country_code FROM Player AS T1 JOIN Tournaments AS T2 ON T1.Player_ID = T2.Player_ID GROUP BY T1.Player_ID ORDER BY count(*) DESC LIMIT 1 SELECT T1.first_name, T1.country_code FROM Player AS T1 JOIN Tournaments AS T2 ON T1.Player_id = T2.Player_id GROUP BY T1.Player_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.year, T1.year_of_matches, T1.year_of_match, T1.year_of_match, T1.year_of_match, T1.year_of_match, T1.year_of_match, T1. SELECT YEAR FROM MATCHes GROUP BY YEAR ORDER BY COUNT(*) DESC LIMIT 1 SELECT T1.Name, T1.RankPoints FROM Winnings AS T1 JOIN Winnings AS T2 ON T1.Winnings = T2.Winnings GROUP BY T1.Winnings ORDER BY count(*) DESC LIMIT 1 SELECT T1.Name, T1.RankPoints, T1.RankPoints FROM Player AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID GROUP BY T1.Winning_Match ORDER BY count(*) DESC LIMIT 1 SELECT T1.Name FROM winner AS T1 JOIN Australian Open AS T2 ON T1.Winning_Points = T2.Winning_Points GROUP BY T1.Name ORDER BY T1.Points DESC LIMIT 1 SELECT T1.Name FROM winners AS T1 JOIN Australian Open AS T2 ON T1.Australian Open = T2.Australian Open GROUP BY T1.Name ORDER BY T1.RankPoints DESC LIMIT 1 SELECT T1.Loser, T1.Winninger, T1.Winninger FROM match AS T1 JOIN match AS T2 ON T1.Match_ID = T2.MATCH_ID ORDER BY T1.Minutes DESC LIMIT 1 SELECT T1.winner, T1.loser FROM match AS T1 JOIN MATCH AS T2 ON T1.match_id = T2.match_id WHERE T2.longest_match played = "longest match" AND T2.longest_match played SELECT avg(T1.rank), T1.first_name, avg(T1.first_name) FROM Player AS T1 JOIN Player AS T2 ON T1.player_id = T2.player_id GROUP BY T1.player_id SELECT T1.first_name, T1.average_ranks FROM Players AS T1 JOIN Rankings AS T2 ON T1.player_id = T2.player_id GROUP BY T1.player_id HAVING avg(T1.ranks) >= 1 SELECT sum(Points), t1.first_name, t2.first_name FROM Player AS t1 JOIN Player_Rankings AS t2 ON t1.player_id = t2.player_id GROUP BY t1.player_id SELECT T1.first_name, T1.total_rating_points FROM Rankings AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID GROUP BY T1.Player_ID SELECT count(*) FROM Players GROUP BY Country SELECT count(*) FROM Players GROUP BY Country SELECT country, t1.country_code FROM players AS t1 JOIN players AS t2 ON t1.country_code = t2.country_code ORDER BY count(*) DESC LIMIT 1 SELECT T1.country_code FROM basketball AS T1 JOIN county AS T2 ON T1.country_code = T2.country_code ORDER BY count(*) DESC LIMIT 1 SELECT COUNT(*) FROM COUNT(*) GROUP BY COUNT(*) HAVING count(*) > 50 SELECT T1.country_code FROM countries AS T1 JOIN countries AS T2 ON T1.country_code = T2.country_code WHERE T2.player_count > 50 SELECT count(*) FROM Rankings SELECT count(*) FROM Rankings GROUP BY Ranking_Date SELECT count(*) FROM matches GROUP BY year SELECT count(*) FROM MATCHes GROUP BY YEAR SELECT T1.Name, T1.Rank FROM Winnings AS T1 JOIN Winnings AS T2 ON T1.Winnings = T2.Winnings GROUP BY T1.Winnings ORDER BY COUNT(*) DESC LIMIT 3 SELECT T1.Name, T1.Ranks FROM winners AS T1 JOIN MATCH AS T2 ON T1.Winnings = T2.Winnings GROUP BY T1.Winnings ORDER BY COUNT(*) DESC LIMIT 3 SELECT count(DISTINCT winners) FROM WTA WHERE left_handed = "WTA" INTERSECT SELECT count(DISTINCT winners) FROM WTA WHERE left_handed = "left" SELECT count(*) FROM winners WHERE left_handed winners = 'left' AND winners = 'WTA' SELECT T1.first_name, T1.country_code, T1.birth_date FROM MATCH AS T1 JOIN MATCH AS T2 ON T1.match_id = T2.match_id GROUP BY T1.winner ORDER BY count(*) DESC LIMIT 1 SELECT T1.first_name, T1.country_code, T1.birth_date FROM Player AS T1 JOIN Player_Rankings AS T2 ON T1.player_id = T2.player_id GROUP BY T1.player_id ORDER BY count(*) SELECT count(*) FROM Player GROUP BY player SELECT count(*) FROM Players GROUP BY TYPE SELECT count(*) FROM ships WHERE 'Captured' = 'Captured' SELECT name, tonnage ORDER BY name DESC SELECT T1.Name, T1.Date, T1.Result FROM Battlefield AS T1 JOIN Participants AS T2 ON T1.Battle_ID = T2.Battle_ID SELECT max(death_toll), min(death_toll) FROM Accidents SELECT avg(AVG(INCT injury) FROM injury_accidents SELECT T1.Death, T1.Injured_by_Ship_with_Tonnage FROM ships AS T1 JOIN ship AS T2 ON T1.Ship_T1.Ship_T1.Ship_T1.Ship_T1.Ship_T1.Ship_T1.Ship_ SELECT T1.Name, T1.Result FROM fighting AS T1 JOIN fighting AS T2 ON T1.Boris = T2.Borilo ORDER BY T1.RESULT DESC LIMIT 1 SELECT DISTINCT T1.Name, T1.Name FROM ships AS T1 JOIN ships AS T2 ON T1.Ship_Type_Ship_Type_Ship_Type_Ship_Type_Ship_Type_Ship_Type_Ship_Type_Ship_Type_Ship SELECT T1.id, T1.name FROM fighting AS T1 JOIN people AS T2 ON T1.people_killed_in_total = T2.people_killed_in_total GROUP BY T1.id HAVING count(*) > 10 SELECT T1.Ship_ID, T1.Name FROM injury_accidents AS T1 JOIN ship AS T2 ON T1.Ship_ID = T2.Ship_ID GROUP BY T1.Ship_ID ORDER BY count(*) DESC LIMIT 1 SELECT DISTINCT T1.Battle_Name FROM fighting AS T1 JOIN commanders AS T2 ON T1.Commander = T2.German_Commander ORDER BY T1.Name ASC LIMIT 1 SELECT count(*), count(*) FROM COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT COUNT SELECT count(*) FROM ships WHERE tonnage '225' SELECT T1.name, T1.date_of_battle AS T1 JOIN ship AS T2 ON T1.ship_name = T2.ship_name WHERE T2.Ship_name = 'Lettice' AND T2.Ship_name = 'HMS A SELECT T1.Name, T1.RESULTS, T1.Bulgarian_Commanders FROM fighting AS T1 JOIN ships AS T2 ON T1.Ship_loss_loss_loss_loss_loss_loss_loss AS T3 ON T1.Ship_loss_loss SELECT T1.Death_Event_Notes FROM death_events AS T1 JOIN funeral_events AS T2 ON T1.Death_Event_Details = T2.Death_Event_Details WHERE T2.Sub = 'East' SELECT DISTINCT Addresse_Name FROM addresses GROUP BY Addresse_Name HAVING count(*) >= 1 AND line 2 SELECT first, first_line, t3.second_line FROM Addresses AS t1 JOIN Addresses AS t2 ON t1.address_id = t2.address_id WHERE t1.address_id = 'address' SELECT count(*) FROM COURSE SELECT count(*) FROM COURSE SELECT T1.How_to_be_described = 'How_to_be_described = ' SELECT T1.description FROM MATH COURSE AS T1 JOIN MATH_COURSE AS T2 ON T1.Math_Course_Description = T2.Math_Course_Description WHERE T2.Math_Course_Description = "Math" SELECT T1.zip_code FROM LOCATION ORDER BY T1.zip_code DESC LIMIT 1 SELECT T1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t2. t2. t2. t2. t2. t2. t2. t2. t2. t SELECT T1.dept_name, T1.dept_id FROM DEPARTMENT AS T1 JOIN DEPARTMENT AS T2 ON T1.dept_id = T2.dept_id GROUP BY T1.dept_name ORDER BY count(*) DESC SELECT T1.name, T1.id FROM degrees AS T1 JOIN degrees AS T2 ON T1.dept_id = T2.dept_id GROUP BY T1.dept_id ORDER BY count(*) DESC LIMIT 1 SELECT count(*) FROM degrees SELECT count(DISTINCT t1.DISTINCT t1.DISTINCT t1.DISTINCT t1.DISTINCT t1.DISTINCT t1.DISTINCT t1.DISTINCT t1.DISTINCT t1.DISTINCT t SELECT count(DISTINCT degree_name) FROM degrees SELECT count(DISTINCT degree_of_course) FROM degrees SELECT count(*) FROM degrees WHERE degree_type = "engineering" SELECT count(*) FROM degrees WHERE degree_code = "engineering" SELECT T1.Name, T1.Description FROM sections AS T1 JOIN sections AS T2 ON T1.sections_id = T2.sections_id WHERE T2.sections_name = "%section%" SELECT T1.Name, T1.Description FROM sections AS T1 JOIN sections AS T2 ON T1.sections_id = T2.sections_id WHERE T2.sections_name = "%section%" SELECT T1.Name, T1.Id FROM courses AS T1 JOIN sections AS T2 ON T1.Course_ID = T2.Course_ID GROUP BY T1.Course_ID HAVING COUNT(*) >= 2 SELECT T1.Name, T1.Id FROM COURSE AS T1 JOIN COURSE AS T2 ON T1.Course_ID = T2.Course_ID WHERE T2.sections > 2 SELECT T2.SECTION_name, T2.SECTION_name, T2.SECTION_name, T2.SECTION_name, T2.SECTION_name, T2.SECTION_name, T2.SECTION_name, T2.SECTION_ SELECT T1.Name FROM sections AS T1 JOIN sections AS T2 ON T1.StuID = T2.StuID WHERE T2.Reverse_alphabetical_order ='reverse' SELECT T1.name, T1.id FROM enroll AS T1 JOIN semester AS T2 ON T1.semester_id = T2.semester_id GROUP BY T1.semester_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.name, T1.id FROM enroll AS T1 JOIN enroll AS T2 ON T1.enroll_id = T2.enroll_id GROUP BY T1.semester ORDER BY count(*) DESC LIMIT 1 SELECT T1.description FROM department AS T1 JOIN department AS T2 ON T1.department_id = T2.department_id WHERE T2.name = "Computer" AND T2.name = "Computer" SELECT T1.Fname FROM ORDER BY T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1.DISTINCT T1. SELECT T1.first_name, T2.middle_name, T1.last_name, T1.id FROM enrolment AS T1 JOIN degree_programs AS T2 ON T1.dept_program_id = T2.dept_program_id SELECT T1.first, T2.middle, T1.last, T1.last, T1.last, T1.last, T1.last, T1.last, T1.last, T1.last, T1.last, T1.last, T SELECT T1.first_name, T2.middle_name FROM enrolment AS T1 JOIN enrolment AS T2 ON T1.enrolment_in_a_Bachelor_degree_program AS T3 ON T1.enrolment_in_a_program SELECT T1.first, T2.middle, T1.last FROM enrolment AS T1 JOIN enroll AS T2 ON T1.enrolment_in_a_Bachilles_program AS T3 ON T1.enrolment_in_a_Bachilles_ SELECT T1.type_of_program, count(*) FROM enrolment AS T1 JOIN student AS T2 ON T1.student_enroll_in = T2.student_enroll_in AS T3 ON T1.student_enroll_in = T3.student_enroll SELECT T1.Degree_Summary_Name FROM degree AS T1 JOIN degree_summary AS T2 ON T1.Dept_Name = T2.Dept_Name GROUP BY T1.Dept_Name ORDER BY count(*) DESC LIMIT 1 SELECT T1.id, T1.summary FROM enrolment AS T1 JOIN enrolment AS T2 ON T1.id = T2.id GROUP BY T1.id ORDER BY count(*) DESC LIMIT 1 SELECT T1.program_id, T1.summary FROM enrolment AS T1 JOIN degrees AS T2 ON T1.degree_id = T2.degree_id GROUP BY T1.degree_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.student_id, T1.student_id FROM enrolments AS T1 JOIN student AS T2 ON T1.stuid = T2.stuid GROUP BY T1.stuid ORDER BY count(*) DESC LIMIT 1 SELECT T1.first, T2.middle, T1.last, T1.enrollment, T1.enrollment, T1.enrollment, T1.enrollment FROM enrolment AS T1 JOIN student AS T2 ON T1.stuid = T2.stu SELECT T1.Stu_Stu_Name FROM SELECT T1.Stu_Stu_Name FROM Student_Enrolled AS T1 JOIN SELECT T1.Stu_Stu_Name FROM Student_Enrolled GROUP BY T1.Stu_Stu_ SELECT T1.name FROM Semester AS T1 JOIN Students AS T2 ON T1.StuID = T2.StuID GROUP BY T1.StuID ORDER BY T1.StuID ORDER BY T1.StuID ORDER BY T1.StuID SELECT T1.Course_Name FROM enrolment AS T1 JOIN enrolment AS T2 ON T1.Enrolment_Course_ID = T2.Enrolment_Course_ID GROUP BY T1.Course_Name HAVING count(*) >= 1 SELECT T1.Course_Name FROM courses AS T1 JOIN enrolment AS T2 ON T1.Course_ID = T2.Course_ID WHERE T2.Enrolment = "%student%" SELECT T1.name FROM Courses AS T1 JOIN Enrolment AS T2 ON T1.crs_id = T2.crs_id GROUP BY T1.crs_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.name FROM Documents AS T1 JOIN Students AS T2 ON T1.to t1.to t1.to t1.to t1.to t1.to t1.to t1.to t1.to t1.to t1.to SELECT T1.last_name FROM STUDENT AS T1 JOIN degrees AS T2 ON T1.student_id = T2.student_id WHERE T2.state_of_North_Carolyn = "North Carolina" AND T1.state_of_state_of SELECT T1.last_name FROM STUDENT AS T1 JOIN STUDENT AS T2 ON T1.student_id = T2.student_id WHERE T2.country_code = "North Carolina" AND T2.country_code NOT IN (SELECT T1.last_name F SELECT Date, id, T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1. SELECT date_and_id FROM transcripts WHERE t1.course_id = 2 AND t1.course_id = 2 SELECT T2.Phone_Number FROM t3.Fname ORDER BY T2.Phone_Number ORDER BY T2.Phone_Number ORDER BY T2.Phone_Number ORDER BY T2.Phone_Number ORDER BY T2.Phone_Number ORDER BY T2.Phone_Number SELECT T1.mobile_phone_number FROM Student AS T1 JOIN Student AS T2 ON T1.student_name = T2.student_name WHERE T2.name = "Timmothy Ward" SELECT T1.Fname, T1.Fname, T1.Fname, T2.Fname, T2.Fname, T2.Fname, T2.Fname, T2.Fname, T2.Fname, T2.Fname, T SELECT T1.Fname, T1.Fname, T2.Lname, T1.Lname, T1.Lname, T2.Lname, T2.Lname, T2.Lname, T2.Lname, T2.Lname, T SELECT T1.first_name, T1.middle_name, T1.last_name, T1.last_name FROM graduate AS T1 JOIN graduate AS T2 ON T1.high_school = T2.high_school GROUP BY T1.first_name SELECT T1.first, T2.middle, T1.last, T1.last FROM graduate AS T1 JOIN school AS T2 ON T1.school_graduate = T2.school_graduate ORDER BY T1.school_graduate DESC LIMIT 1 SELECT T1.FROM ORDER BY T1.FROM ORDER BY T1.FROM ORDER BY T1.FROM ORDER BY T1.FROM ORDER BY T1.FROM ORDER BY T1.FROM ORDER BY T1.FROM ORDER BY T1.FROM SELECT T1.Fname FROM Student WHERE T1.Fname LIKE '%' SELECT T1.address_id, count(*) FROM Student_Addresses AS T1 JOIN Student_Addresses AS T2 ON T1.address_id = T2.address_id GROUP BY T1.address_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.id, T2.line_2 FROM Addresses AS T1 JOIN Students AS T2 ON T1.address_id = T2.address_id GROUP BY T1.address_id ORDER BY count(*) DESC LIMIT 1 SELECT avg(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG(T1.AVG SELECT avg(T1.date) FROM transcripts AS T1 JOIN transcripts AS T2 ON T1.transcripts_id = T2.transcripts_id WHERE T2.year = '2016' SELECT Date_Release, Date_Details FROM transcripts AS t1 JOIN transcripts AS t2 ON t1.transcripts_released_by_t1.transcripts_released_by_t1.date_released ORDER BY COUNT(*) DESC LIMIT 1 SELECT t1.date_of_a_transcript_release, t1.date_of_a_release FROM transcripts AS t1 JOIN transcripts AS t2 ON t1.transcript_releases = t2.transcript_releases GROUP BY SELECT count(*) FROM transcripts GROUP BY transcripts SELECT count(*) FROM transcripts SELECT T1.Last_Release_Date FROM transcripts AS T1 JOIN transcripts AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.last_released FROM transcripts AS T1 JOIN transcripts AS T2 ON T1.transcripts_id = T2.transcripts_id WHERE T2.last_released = "Last_Release" SELECT count(*) FROM COURSE_Enrolment_RESULTS GROUP BY COURSE_Enrolment_RESULT ORDER BY count(*) DESC LIMIT 1 SELECT max(T1.enrollment_id) FROM enrolment AS T1 JOIN enrollment AS T2 ON T1.enrolment_id = T2.enrolment_id GROUP BY T1.enrollment_id SELECT date_of_test, date_of_result FROM results GROUP BY date_of_test ORDER BY count(*) DESC LIMIT 1 SELECT date, id, id FROM transcripts WHERE results = '%' SELECT semester_by_Master_student_and_Bachelor_student_enrolment_in FROM enrolment AS T1 JOIN enrolment AS T2 ON T1.Enrolment_in_to_Get_Enrolled_in AS T3 ON T1.En SELECT T1.id FROM semester AS T1 JOIN enrolment AS T2 ON T1.semester_id = T2.semester_id WHERE T2.Masters = 'Master' INTERSECT SELECT T1.id FROM semester AS T1 JOIN enrolment SELECT count(DISTINCT Addresses) FROM Student WHERE Population = "%student%" SELECT DISTINCT T1.address_of_student AS T1 JOIN STUDENT AS T2 ON T1.student_id = T2.student_id WHERE T2.student_living_There = "There" SELECT T1.stu_details FROM Student_Details AS T1 JOIN Student_Details AS T2 ON T1.stu_details = T2.stu_details_in_reversed_lexicographical_order SELECT T1.details_from_student_in_reverse_alphabetical_order FROM STUDENT AS T1 JOIN Students AS T2 ON T1.student_in_reverse_alphabetical_order = T2.student_in_reverse_order SELECT T1.describe t2.describe t2.describe t2.describe t2.describe t2.describe t2.describe t2.describe t2.describe t2.describe t2.describe t2.describe t SELECT T1.description FROM sections AS T1 JOIN sections AS T2 ON T1.section_name = T2.section_name WHERE T2.name = "h" SELECT T1.first_name FROM STUDENT AS T1 JOIN STUDENT AS T2 ON T1.student_id = T2.student_id WHERE T2.country = Haiti OR T2.cell_phone_number = '09700166582' SELECT T1.first_name FROM STUDENT AS T1 JOIN STUDENT AS T2 ON T1.student_id = T2.student_id WHERE T2.country_code = "Haiti" OR T1.cell_phone_number = "09700166582" SELECT T1.Title FROM Cartoons AS T1 JOIN Cartoons AS T2 ON T1.Cartoons_ID = T2.Cartoons_ID ORDER BY T1.Title SELECT title FROM cartoons ORDER BY title SELECT T1.All_Movies AS T1 JOIN Cartoons AS T2 ON T1.Cartoon_Directed_by_Ben Jones = T2.Cartoon_Directed_by_Ben Jones AS T3 ON T1.Cartoon_Directed_by_Ben Jones = T3. SELECT T1.Name FROM cartoons AS T1 JOIN cartoons AS T2 ON T1.Cartoons_directed_by_Ben Jones AS T3 ON T1.Cartoons_directed_by_Ben Jones = T3.Cartoons_directed_by_ SELECT count(*) FROM cartoons WHERE t1.name = "Joseph Kuhr" SELECT count(*) FROM Cartoons WHERE Writer_Joseph Kuhr = "Joseph Kuhr" SELECT title, director ORDER BY title_date DESC LIMIT 1 SELECT T1.name, T1.director FROM cartoons AS T1 JOIN cartoons AS T2 ON T1.cartoon_id = T2.cartoon_id WHERE T2.date = "air date" SELECT T1.title FROM cartoon AS T1 JOIN cartoon AS T2 ON T1.cartoon_directed_by_Ben Jones OR T2.directed_by_Brandon Vietti AS T3 ON T1.cartoon_directed_by_Ben Jones OR T3.directed SELECT T1.Title FROM cartoons AS T1 JOIN cartoons AS T2 ON T1.Cartoons_directed_by_Ben Jones OR T2.Brandon Vietti = T2.Cartoons_directed_by_Ben Jones OR T2.Brandon Vietti = T SELECT T1.Country, T1.Country, T1.Country, T1.Country, T1.Country, T1.Country, T1.Country, T1.Country, T1.Country, T1.Country, T1.Country, T1.Country, T SELECT Country, COUNT(*) FROM Television_Channels GROUP BY Country ORDER BY count(*) DESC LIMIT 1 SELECT count(DISTINCT T1.Series_Name), count(*) FROM Television_Channels AS T1 JOIN Television_Channels AS T2 ON T1.TV_Channel_Table = T2.TV_Channel_Table SELECT count(DISTINCT T1.TV Channel_Table) FROM Television_Channels AS T1 JOIN contents AS T2 ON T1.TV_Channel_Table = T2.TV_Channel_Table SELECT T1.Content FROM broadcast AS T1 JOIN broadcast AS T2 ON T1.TV_Channel_id = T2.TV_Channel_id WHERE T2.Serial_name = "Sky Radio" SELECT T1.title FROM content AS T1 JOIN broadcast AS T2 ON T1.broadcast_from = T2.broadcast_from AS T3 ON T1.broadcast_from = T3.broadcast_from 'Sky Radio' SELECT T1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t2. t SELECT T1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t2. t2. t2. t2. t2. t SELECT count(*) FROM channels WHERE languages = "English" SELECT count(*) FROM RECORD COUNT COUNT(*) DESC LIMIT 1 SELECT T1.language, count(*) FROM channel AS T1 JOIN channel AS T2 ON T1.TV_Channel = T2.TV_Channel GROUP BY T1.language ORDER BY count(*) DESC LIMIT 1 SELECT T1.languages_used_by_TV_Channels, T1.languages_used_by_TV_Channels, T1.languages_used_by_TV_Channels, T1.languages_used_by_TV_Channels, T1.languages_used SELECT T1.language, count(*) FROM channels AS T1 JOIN channel AS T2 ON T1.TV_Channels_id = T2.TV_Channels_id GROUP BY T1.language SELECT count(*) FROM channels GROUP BY languages SELECT T1.TV_Channel FROM Cartoons AS T1 JOIN Cartoons AS T2 ON T1.TV_Channel = T2.TV_Channel WHERE T2.Cartoon_name = "The Rise of the Blue Beetle" SELECT T1.TV_Channel FROM Cartoons AS T1 JOIN Cartoons AS T2 ON T1.TV_Channel = T2.TV_Channel WHERE T2.Cartoon_name = "The Rise of the Blue Beetle" SELECT T1.title FROM Cartoons AS T1 JOIN Cartoons AS T2 ON T1.Cartoons_showed_on_TV_Channel AS T3 ON T1.Cartoons_showed_on_TV_Channel_with_name "Sky Radio" SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Title, T1.Title, T1.Title, T1. SELECT T1.Title FROM Television ORDER BY T1.Title DESC LIMIT 1 SELECT count(*) FROM broadcasts ORDER BY Ratings SELECT T1.TV_Series, T1.Rating FROM Television_Series AS T1 JOIN Ratings AS T2 ON T1.TV_Series = T2.TV_Series GROUP BY T1.TV_Series ORDER BY T1.Rating DESC LIMIT 3 SELECT T1.Top3, T1.Top3 FROM Ratings AS T1 JOIN Ratings AS T2 ON T1.TV_Series_Table = T2.TV_Series_Table GROUP BY T1.TV_Series_Table ORDER BY T1.High_rating DESC SELECT min(share), max(share) FROM Television_Series SELECT max(share), min(share) FROM Television_Series SELECT T1.Air_Date FROM broadcast AS T1 JOIN broadcast AS T2 ON T1.TV_Series_ID = T2.TV_Series_ID WHERE T2.Episode = "A Love of a Lifetime" SELECT t1.date_of_air FROM "A Love of a Lifetime" SELECT Weekly_Rank FROM Television_Series WHERE Episode = "A Love of a Lifetime" SELECT weekly_rank FROM "A Love of a Lifetime" SELECT T1.TV_Channel FROM TV_Series AS T1 JOIN Television_Series AS T2 ON T1.TV_Series_Name = T2.TV_Series_Name WHERE T2.Episode = "A Love of a Lifetime" SELECT T1.name FROM COURSE AS T1 JOIN Supernatural AS T2 ON T1.StuID = T2.StuID WHERE T2.Episode = "A Love of a Lifetime" SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Episode FROM broadcast AS T1 JOIN broadcast AS T2 ON T1.TV_Series_Name = T2.TV_Series_Name WHERE T2.Name = "Sky Radio" SELECT count(*) FROM Cartoons AS t1 JOIN Cartoons AS t2 ON t1.Committee_to_SELECT t1.Committee_to_SELECT t1.Committee_to_SELECT t1.Committee_to_SELECT SELECT count(*) FROM Cartoons SELECT T1.Product_Code, T1.Channel FROM cartoon AS T1 JOIN cartoon_broadcast AS T2 ON T1.Cartoon_ID = T2.Cartoon_ID ORDER BY T1.Years_of_Aired DESC LIMIT 1 SELECT T1.Product_Code, T1.Channel FROM Cartoons AS T1 JOIN Cartoons AS T2 ON T1.Cartoon_ID = T2.Cartoon_ID ORDER BY T1.Year_Release DESC LIMIT 1 SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T2.T2.T2.T2.T2.T SELECT T1.name, T1.name, T2.name, T2.name, T2.name, T2.name, T2.name, T2.name, T2.name, T2.name, T2.name, T2.name, T SELECT t1.country FROM cartoons AS t1 JOIN cartoons AS t2 ON t1.cartoons_id = t2.cartoon_id WHERE t2.name = "Todd Casey" AND t2.name = "Todd Case SELECT T1.Country FROM cartoons AS T1 JOIN cartoons AS T2 ON T1.Todd Casey = T2.Todd Casey WHERE T2.Todd Casey = "Todd Casey" SELECT t1.country FROM cartoons AS t1 JOIN cartoons AS t2 ON t1.cartoons_id = t2.cartoon_id WHERE t2.Todd Casey = "Todd Casey" SELECT T1.Country FROM cartoons AS T1 JOIN cartoons AS T2 ON T1.Todd Casey = T2.Todd Casey WHERE T2.Todd Casey NOT IN (SELECT T1.Country FROM cartoons AS T1 JOIN cartoons AS T SELECT T1.name, T1.country FROM Cartoons AS T1 JOIN Cartoons AS T2 ON T1.TV_Channel_ID = T2.TV_ID WHERE T2.directored_by_Ben Jones AND T2.Michael Chang = "Ben Jones" SELECT T1.name, T1.country FROM channels AS T1 JOIN cartoons AS T2 ON T1.channel_id = T2.channel_id WHERE T2.directored_by_Ben Jones = "Michael Chang" AND T2.season_name = SELECT pixel_aspect_ratio, national_of_channels FROM channels WHERE languages NOT IN (SELECT languages_of_channels FROM channels WHERE languages NOT IN (SELECT languages_of_channels FROM channels WHERE languages NOT IN (SELECT SELECT T1.pixel_aspect_ratio, T1.country_of_origin FROM channels AS T1 JOIN channels AS T2 ON T1.TV_channels_id NOT IN (SELECT T1.TV_channels_id FROM channels AS T1 JOIN channels AS SELECT T1.TV_Channel FROM channels AS T1 JOIN channels AS T2 ON T1.TV_Channel = T2.TV_Channel GROUP BY T1.TV_Channel HAVING count(*) > 2 SELECT T1.TV_Channel FROM channel AS T1 JOIN channel AS T2 ON T1.TV_Channel = T2.TV_Channel GROUP BY T1.TV_Channel HAVING count(*) > 2 SELECT id FROM channel WHERE t1.name = "Ben Jones" AND t1.name = "Ben Jones" SELECT T1.TV_channels_id FROM Cartoons AS T1 JOIN Cartoons AS T2 ON T1.TV_channels_id = T2.TV_channels_id WHERE T2.Ben Jones NOT IN (SELECT T1.TV_channels_id FROM Cartoon SELECT t1.package_option FROM channel AS t1 JOIN channels AS t2 ON t1.channel_id = t2.channel_id WHERE t1.name = "Ben Jones" AND t2.name = "Ben Jones" SELECT T1.Package_Options FROM channels AS T1 JOIN cartoons AS T2 ON T1.TV_channels_unavailable_by_Ben Jones AS T3 ON T1.TV_channels_unavailable_by_Ben Jones = T3.TV_channels_unavailable_by SELECT count(*) FROM Poker_Player SELECT count(*) FROM Poker_Player SELECT earnings_of_poker_player DESC SELECT earnings_of_poker_player ORDER BY revenue SELECT T1.Final_Table_Made, T1.Best_Finished_of_Poker_Player, T1.Best_Finished_of_Poker ORDER BY T1.Winning_Time DESC LIMIT 1 SELECT T1.Final_Table_Made, T1.Best_Finishes FROM Poker_Player AS T1 JOIN Winnings AS T2 ON T1.Poker_Player = T2.Poker_Player GROUP BY T1.Poker_Player ORDER BY T1.Best_Finishes SELECT avg(salary) FROM Players WHERE BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BET SELECT avg(salary) FROM cards SELECT T1.Money_Rank FROM Player AS T1 JOIN Player AS T2 ON T1.Poker_Player = T2.Player_Player_ID ORDER BY T1.Points_Rank DESC LIMIT 1 SELECT T1.Money_Rank FROM Player AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID ORDER BY T1.Money_Rank DESC LIMIT 1 SELECT max(total_tables_made) FROM Tournaments WHERE earnings > 200000 SELECT max(T1.Final_Tables_Made) FROM Tournaments AS T1 JOIN Players AS T2 ON T1.Poker_Player_ID = T2.Poker_Player_ID WHERE T1.earnings > 200000 SELECT T1.Name FROM Poker_Player AS T1 JOIN Player AS T2 ON T1.Poker_Player = T2.Player_Player_ID WHERE T2.Player_Name = "Poker" SELECT T1.Name FROM Poker_Player AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID GROUP BY T1.Player_ID SELECT T1.Name FROM Players AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID WHERE T1.Earnings > 300000 SELECT T1.Name FROM Players AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID WHERE T1.Earnings > 300000 SELECT T1.Name FROM Player AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID ORDER BY T1.Position ASC SELECT T1.Name FROM Players AS T1 JOIN Tournament_Points AS T2 ON T1.Player_ID = T2.Player_ID ORDER BY T1.Number_of_Final_Tables AS T1 JOIN Tournament_Points AS T2 ON T1.Poker_ SELECT Birth_Date FROM Player WHERE Winnings > (SELECT avg(Earnings) FROM Player) SELECT Birth_Date FROM Player WHERE Financial_Earnings > (SELECT avg(Financial_Earnings) FROM Player) SELECT Money_Rank FROM Player WHERE Player_Rank = "T3.T1.Poker" AND Player_Rank = "Top" SELECT T1.Money_Rank FROM Player AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID ORDER BY T1.Money_Rank DESC LIMIT 1 SELECT avg(earnings) FROM cards WHERE height > 200 SELECT avg(salary) FROM cards WHERE age > 200 AND age > 200 SELECT T1.Name FROM Player AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID ORDER BY T1.Earning_Order DESC SELECT T1.Name FROM Players AS T1 JOIN Player AS T2 ON T1.Player_ID = T2.Player_ID ORDER BY T1.Points_Descending DESC SELECT DISTINCT Nationality, COUNT(*) FROM people GROUP BY Nationality SELECT count(*) FROM people GROUP BY Nationality SELECT t1.Name FROM Population GROUP BY t1.Name ORDER BY t1.Total t1.Total t1.Total t1.Total t1.Total t1.Total t1.Total t1.Total t1.Total t1.Total t1. SELECT Nationality FROM people GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1 SELECT Nationality FROM people WHERE shared_by_people = 2 SELECT Nationality FROM People WHERE Population > 2 OR Population > 2 SELECT T1.Name, T1.Birth_Date FROM People AS T1 JOIN People AS T2 ON T1.People_ID = T2.People_ID ORDER BY T1.Name ASC SELECT T1.Name, T1.Birth_Date FROM people AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID ORDER BY T1.Name SELECT T1.Name FROM People WHERE Nationality LIKE "%Russia" SELECT T1.People_Name FROM people AS T1 JOIN People AS T2 ON T1.People_Name_from SELECT T1.People_FROM people AS T1 JOIN People AS T2 ON T1.People_from = 'Russia' SELECT T1.Name FROM people AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Player_Name = "Poker" SELECT T1.name FROM People AS T1 JOIN People AS T1 JOIN People AS T2 ON T1.People_Name_FROM People WHERE NOT NOT IN SELECT T1.name FROM People WHERE NOT IN SELECT T1.name FROM People WHERE NOT IN SELECT count(*) FROM How count(*) = t2.How_count_percent_nationalities GROUP BY t1.count_count_percent t2.count_percent t2.count_percent t2.count_percent t2.count_percent t2.count_percent SELECT count(*), COUNT, COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*), COUNT(*) SELECT count(*) FROM states SELECT T1.contestant_number, T1.name, T1.name FROM Contestant AS T1 JOIN Contestant AS T2 ON T1.contestant_name = T2.contestant_name ORDER BY T1.contestant_name_descending SELECT T1.Vote_ID, T1.Phone_Numbers, T1.State FROM VOTING AS T1 JOIN VOTING AS T2 ON T1.Vote_ID = T2.Vote_ID GROUP BY T1.Vote_ID SELECT max(T1.max(T1.minimum), min(T1.minimum) FROM Area_Codes AS T1 JOIN Area_Codes AS T2 ON T1.Area_Code = T2.Area_Code WHERE T2.Area_Code = "Area_Code" SELECT date_created_of_votes FROM VOTING_RESULTS WHERE state = 'CA' SELECT T1.Name FROM Competition_contest AS T1 Jessie Alloway AS T2 ON T1.Committee_ID = T2.Committee_ID WHERE T2.Name!= 'Jessie Alloway' SELECT DISTINCT state, created_time FROM VOTING GROUP BY state SELECT T1.contestant_number, T1.contestant_name FROM votes AS T1 JOIN votes AS T2 ON T1.competition_id = T2.competition_id WHERE T2.votes >= 2 SELECT T1.contestant_number, T1.name FROM votes AS T1 JOIN votes AS T2 ON T1.competition_id = T2.competition_id GROUP BY T1.contestant_number ORDER BY count(*) DESC LIMIT 1 SELECT count(*) FROM VOTING SELECT count(*) FROM VOTING WHERE state = 'NY' OR state = 'CA' SELECT count(*) FROM votes WHERE Vote_No = '%Vote%' SELECT t1.area_code FROM VOTING_Area AS t1 JOIN VOTING_Area AS t2 ON t1.voting_area_code = t2.voting_area_code GROUP BY t1.voting_area_code ORDER SELECT T1.Create_Date, T1.Phone_Numbers, T1.Phone_Number FROM VOTING AS T1 JOIN VOTING AS T2 ON T1.Vote_Date = T2.Vote_Date WHERE T2.Name = 'Tabatha Gehling' SELECT Area_Code FROM VOTING_COUNT(*) GROUP BY Area_Code HAVING COUNT(*) >= 2 SELECT T1.Name FROM Competitions AS T1 JOIN Contestants AS T2 ON T1.Committee_ID = T2.Committee_ID WHERE T2.Name LIKE '%Al%' SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.Name FROM nations AS T1 JOIN nations AS T2 ON T1.Country_name = T2.Country_name WHERE T1.Founded < 1950 SELECT count(*) FROM COUNT(*) GROUP BY COUNT(*) HAVING count(*) >= 1 SELECT count(*) FROM COUNT(*) GROUP BY COUNT(*) GROUP BY COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) SELECT sum(surface_area) FROM Caribbean region WHERE Caribbean region = "Caribbean" SELECT count(*) FROM COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) SELECT T1. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T SELECT T1.name FROM languages AS T1 JOIN languages AS T2 ON T1.languages = T2.languages WHERE T2.name = "Anguilla" AND T2.country_name = "Aguilla" SELECT t1.region FROM city AS t1 JOIN cities AS t2 ON t1.city_id = t2.city_id WHERE t1.city_code = "Kabul" SELECT T1.Region, T1.Region, T1.Region, T1., T1., T1., T1., T1., T1., T1., T1., T1., T1., T1., T1. SELECT T1. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T SELECT T1. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T SELECT T1. t1. t1. t1. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t2. t SELECT T2.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT region, population FROM Angola SELECT region_id FROM Angola WHERE Population > (SELECT avg(Population) FROM Angola) SELECT avg(Life_Expectancy) FROM Population WHERE Region_of_Central_Africa = "Central Africa" SELECT avg(Life_Expectancy) FROM people WHERE Population > (SELECT avg(Life_Expectancy) FROM people WHERE Population > (SELECT avg(Life_Expectancy) FROM people WHERE Population > (SELECT avg(Life_Expectancy SELECT T1.name FROM languages AS T1 JOIN languages AS T2 ON T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT T1.country_name FROM country AS T1 JOIN lives_xpectancy AS T2 ON T1.country_name = T2.country_name ORDER BY T1.life_xpectancy DESC LIMIT 1 SELECT sum(T1.Population), max(T1.GNP) FROM Population AS T1 JOIN Population AS T2 ON T1.Population = T2.Population GROUP BY T1.Population ORDER BY T1.Population DESC LIMIT 1 SELECT count(*) FROM people WHERE GDP = (SELECT avg(GDP) FROM people) SELECT avg(Life_Expectancy) FROM Population WHERE Population = "African" AND Population = "Republic" SELECT avg(Life_Expectancy) FROM Population WHERE Country_name = "Africa" AND Country_name = "Republic" SELECT T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T SELECT sum(surface_area) FROM cities WHERE country_region = "Asia" OR country_region = "Europe" SELECT count(*) FROM People GROUP BY T1.How_to_count_to_to_to SELECT count(*) FROM People GROUP BY T1.How_to_to_to_to_to_to_to_to_to_to_to_to_to_ SELECT sum(T2.Population) FROM Population ORDER BY T1.Population_of_Gelderland ORDER BY T1.Total_Population FROM Population_of Gelderland ORDER BY T1.Total_Population_of_Gelderland ORDER BY T1.Total_Population_of_ SELECT avg(GNP), avg(total_population) FROM nations WHERE territory = "US territory" SELECT mean_GNP, sum(total_population), total_population FROM nations AS t1 JOIN nations AS t2 ON t1.national_id = t2.national_id WHERE t2.country_name = "US" SELECT count(*) FROM languages GROUP BY languages SELECT count(*) FROM languages GROUP BY languages SELECT count(*) FROM Population GROUP BY T1.COUNT(*) GROUP BY T1.COUNT(*) GROUP BY T1.COUNT(*) GROUP BY T1.COUNT(*) GROUP BY T1.COUNT(*) GROUP BY T1.COUNT(*) GROUP BY T1.COUNT(*) GROUP BY T1.COUNT SELECT count(*) FROM Population GROUP BY COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) SELECT sum(DISTINCT languages_used) FROM languages WHERE languages_used_in = "Aruba" SELECT count(*) FROM languages WHERE languages_code = "Aruba" SELECT count(*) FROM Official languages AS t1 JOIN languages AS t2 ON t1.language_id = t2.language_id WHERE t1.country_id NOT IN (SELECT country_id FROM languages AS t3 ON t SELECT count(*) FROM Official languages WHERE Official_languages = "afghan" SELECT T1.country_name FROM languages AS T1 JOIN languages AS T2 ON T1.languages_id = T2.languages_id GROUP BY T1.country_name ORDER BY count(*) DESC LIMIT 1 SELECT T1.Name FROM languages AS T1 JOIN languages AS T2 ON T1.languages = T2.languages GROUP BY T1.Name ORDER BY count(*) DESC LIMIT 1 SELECT t1.country FROM languages AS t1 JOIN languages AS t2 ON t1.languages = t2.languages GROUP BY t1.country ORDER BY COUNT(*) DESC LIMIT 1 SELECT t1.country FROM languages AS t1 JOIN languages AS t2 ON t1.languages = t2.languages GROUP BY t1.country ORDER BY count(*) DESC LIMIT 1 SELECT count(*) FROM languages WHERE languages = "English" INTERSECT SELECT count(*) FROM languages WHERE languages = "Dutch" SELECT count(*) FROM languages WHERE languages = "English" AND languages = "Dutch" SELECT T1.Name FROM languages AS T1 JOIN languages AS T2 ON T1.languages = T2.languages WHERE T2.English = "English" INTERSECT SELECT T1.Name FROM languages AS T1 JOIN languages AS T2 ON T1. SELECT T1.Name FROM languages AS T1 JOIN languages AS T2 ON T1.languages = T2.languages WHERE T2.English = "English" INTERSECT SELECT T1.Name FROM languages AS T1 JOIN languages AS T2 ON T1. SELECT T1.Name FROM languages AS T1 JOIN languages AS T2 ON T1.English = T2.French GROUP BY T1.Name HAVING COUNT(*) >= 1 SELECT T1.Country_Name FROM languages AS T1 JOIN languages AS T2 ON T1.languages_languages_languages_languages = T2.languages_languages_languages AS T3 ON T1.languages_languages_languages_languages_languages_languages_languages_languages_languages SELECT count(*) FROM languages WHERE languages_is_ spoken = "Chinese" SELECT count(*) FROM SELECT count(*) FROM SELECT count(*) FROM SELECT count(*) FROM SELECT count(*) FROM SELECT count(*) FROM SELECT count(*) FROM SELECT count(*) FROM SELECT count(*) FROM SELECT count(*) FROM SELECT count SELECT T1.Region FROM languages AS T1 JOIN languages AS T2 ON T1.Region_code = T2.Region_code WHERE T2.English = "English" OR T2.Dutch = "Dutch" SELECT T1.Region FROM languages AS T1 JOIN languages AS T2 ON T1.Languages = T2.Dutch OR T2.English = T2.English SELECT Country FROM languages WHERE Official_language = "English" OR Official_language = "Dutch" SELECT T1.country_name FROM languages AS T1 JOIN languages AS T2 ON T1.languages_languages_languages_languages_languages_languages_languages AS T3 ON T1.languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_ SELECT T1. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T2. WHERE T SELECT T2.language_name FROM languages AS T1 JOIN languages AS T2 ON T1.languages_id = T2.languages_id GROUP BY T1.language_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.languages FROM languages AS T1 JOIN languages AS T2 ON T1.languages = T2.languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_ SELECT T1.language_available_by T1.country_with_a_republik_government FROM languages AS T1 JOIN languages AS T2 ON T1.languages_available_by T2.languages_available_by T2.languages_available_by T2.languages_available_by SELECT city, largest_population FROM cities WHERE languages = "english" AND languages = "english" SELECT T1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t SELECT T1.name, T1.population, T1.population FROM province AS T1 JOIN province AS T2 ON T1.province_id = T2.province_id GROUP BY T1.country_id ORDER BY COUNT(*) DESC LIMIT 1 SELECT T1.name, T1.population, T1.Life_Expectancy FROM Population AS T1 JOIN Population AS T2 ON T1.Population = T2.Population GROUP BY T1.Country ORDER BY T1.Population DESC LIMIT 1 SELECT avg(Life_Expectancy) FROM languages WHERE Official_language = "english" SELECT mean_life_xpectancy FROM languages WHERE languages_is NOT IN (SELECT languages_is_in_english) SELECT sum(T1.Population) FROM people AS T1 JOIN languages AS T2 ON T1.People_ID = T2.People_ID WHERE T2.English = "english" SELECT count(*) FROM Population GROUP BY COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) SELECT T1.Fname FROM languages AS T1 JOIN Official languages AS T2 ON T1.Fname = 'Baatrix' SELECT T1.Fname FROM Official languages AS T1 JOIN Official languages AS T2 ON T1.Fname = 'Baea' SELECT sum(DISTINCT Official_languages_spoken) FROM languages WHERE Founded_Before 1930 GROUP BY sum(Unique_Official_languages_spoken) SELECT sum(DISTINCT Official_languages) FROM languages WHERE Founded_Before 1930 GROUP BY Official_languages SELECT T1.Country_in_United SELECT T1.Country_in_United SELECT T1.Country_in_United SELECT T1.Country_in_United, T1.Country_in_United SELECT T1.Country_in_United FROM GROUP BY T1.Country_ SELECT T1.Country_in_United, T1.Country_in_Italy FROM languages AS T1 JOIN languages AS T2 ON T1.CName = 'Y' SELECT Country FROM african_countries WHERE Population > (SELECT avg(Population) FROM african_countries) SELECT t1.country FROM Population AS t1 JOIN Population AS t2 ON t1.country_id = t2.country_id WHERE t2.population > (SELECT avg(population_population_city) FROM Population) SELECT Country FROM Population WHERE Population > (SELECT Country FROM Population) SELECT T1.Asian_Country FROM Population AS T1 JOIN Population AS T2 ON T1.Asian_Country = T2.Asian_Country WHERE T2.Population > (SELECT avg(Population_Population_Population) FROM Population) SELECT country_code FROM country WHERE languages NOT IN (SELECT country_code FROM country WHERE languages NOT IN (SELECT country_code FROM country WHERE languages NOT IN (SELECT country_code FROM country WHERE languages NOT IN (SELECT country_code FROM SELECT country_code FROM country WHERE languages NOT IN (SELECT country_code FROM country WHERE languages NOT IN (SELECT country_code FROM country WHERE languages NOT IN (SELECT country_code FROM country WHERE languages NOT IN (SELECT country_code FROM SELECT country_code FROM countries WHERE people_use_languages other than English = "English" SELECT Country_Code FROM country WHERE People_Speaks NOT IN (SELECT Country_Code FROM country WHERE People_Speaks NOT IN ( SELECT Country_Code FROM country WHERE People_Speaks NOT IN ( SELECT Country_Code FROM country WHERE People_Speak SELECT T1.country_code FROM languages AS T1 JOIN languages AS T2 ON T1.languages_languages_languages_languages_languages_languages AS T3 ON T1.languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_languages_ SELECT T1.country_code FROM languages AS T1 JOIN languages AS T2 ON T1.languages_languages_languages_languages_languages_languages_languages_languages AS T3 ON T1.languages_languages_languages_languages_languages_languages_languages_languages_languages_ SELECT T1.city FROM cities AS T1 JOIN languages AS T2 ON T1.city_id = T2.city_id WHERE T2.english_is NOT IN (SELECT T1.city_id FROM languages AS T1 JOIN languages AS T2 ON SELECT T1.Name FROM cities AS T1 JOIN languages AS T2 ON T1.English = T2.English WHERE T2.Official_language!= "english" SELECT t1.city FROM cities AS t1 JOIN languages AS t2 ON t1.city_id = t2.city_id WHERE t2.english_is the official_language = "Chinese" SELECT DISTINCT T1.Name FROM cities AS T1 JOIN cities AS T2 ON T1.City_ID = T2.City_ID WHERE T2.China = "China" AND T2.Official_language = "Chinese" SELECT T1.name, T1.independence_year, T1.surface_area FROM country AS T1 JOIN Population AS T2 ON T1.country_with_population = T2.country_with_population GROUP BY T1.country_with_population ORDER BY SELECT T1.name, T1.year_of_independence, T1.surface_area FROM country AS T1 JOIN Population AS T2 ON T1.country_id = T2.country_id GROUP BY T1.country_id ORDER BY COUNT(*) DESC SELECT T1.Population, T1.Name, T1.Leader FROM country AS T1 JOIN areas AS T2 ON T1.Country_with_high_area = T2.Country_with_high_area AS T3 ON T1.Country_with_high_area SELECT T1.country, T1.population, T1.headofstate FROM country AS T1 JOIN county AS T2 ON T1.country = T2.country ORDER BY COUNT(*) DESC LIMIT 1 SELECT Country_Name, COUNT(*) FROM country WHERE languages >= 3 SELECT T1.Name, T1.Country_Name, T1.Country_Name FROM countries AS T1 JOIN languages AS T2 ON T1.Country_Name = T2.Country_Name GROUP BY T1.Country_Name HAVING count(*) > 2 SELECT count(*) FROM cities WHERE Population > (SELECT avg(Population_of_city) FROM cities) SELECT count(*) FROM cities GROUP BY district HAVING COUNT(*) > (SELECT avg(Population) FROM cities) SELECT T1.Government_form_name, T1.Total_Population FROM policies AS T1 JOIN government_form AS T2 ON T1.Government_form_name = T2.Government_form_name WHERE T1.Life_Expectancy > 72 SELECT DISTINCT T1.Government_form, T1.Population FROM policies AS T1 JOIN government_forms AS T2 ON T1.Government_form_form_id = T2.Government_form_id WHERE T1.Life_Expectancy > 72 SELECT avg(Life_Expectancy), sum(Population) FROM Population WHERE AVG(Life_Expectancy) > 72 SELECT DISTINCT T1.continent, T1.total_popuation, avg(T1.Life_Expectancy) FROM COUNT(*) AS T1 JOIN Population AS T2 ON T1.continent = T2.continent WHERE T1.average_Life SELECT T1.Name, T1.Area FROM countries AS T1 JOIN areas AS T2 ON T1.Country_with_Top_5 = T2.Country_with_Top_5 GROUP BY T1.Country_with_Top_5 ORDER BY COUNT(*) SELECT T1.Name, T1.Surface_Area FROM languages AS T1 JOIN languages AS T2 ON T1.Country_ID = T2.Country_ID GROUP BY T1.Country_ID ORDER BY COUNT(*) DESC LIMIT 5 SELECT T1.Name FROM COUNT(*) AS T1 JOIN Population AS T2 ON T1.Country = T2.Country ORDER BY T1.Population DESC LIMIT 3 SELECT T1.Name FROM Population AS T1 JOIN Population AS T2 ON T1.Population = T2.Population GROUP BY T1.Country ORDER BY COUNT(*) DESC LIMIT 3 SELECT T1.Name FROM nations AS T1 JOIN Population AS T2 ON T1.Population = T2.Population GROUP BY T1.Name ORDER BY COUNT(*) DESC LIMIT 3 SELECT T1.country_with_f(T2.population) FROM languages AS T1 JOIN people AS T2 ON T1.country_id = T2.country_id GROUP BY T1.country_id ORDER BY count(*) DESC LIMIT 3 SELECT count(*), count(*) FROM count(*) GROUP BY count(*) DESC LIMIT 1 SELECT count(*), COUNT, COUNT, COUNT, COUNT, COUNT, COUNT, COUNT, COUNT, COUNT, COUNT, COUNT, COUNT, COUNT, COUNT, SELECT T1.Name FROM COUNT(*) AS T1 JOIN COUNT(*) AS T2 ON T1.Country_ID = T2.Country_ID WHERE T2.Population > 80000 AND T2.Population_of_80000 = 80000 SELECT T1.Country FROM countries AS T1 JOIN Population AS T2 ON T1.Country = T2.Country WHERE T2.Population >= 8000 AND T2.Population >= 8000 SELECT sum(Population), avg(Area) FROM Population WHERE Population > 3000 GROUP BY COUNT(*) ORDER BY COUNT(*) DESC LIMIT 1 SELECT sum(Population), avg(Surface_Area) FROM COUNT(*) GROUP BY sum(Surface_Area) HAVING COUNT(*) > 3000 ORDER BY avg(Surface_Area) DESC LIMIT 1 SELECT city_name FROM cities WHERE population BETWEEN 160000 AND 900000 SELECT T1.Name FROM cities AS T1 JOIN Population AS T2 ON T1.City_ID = T2.City_ID WHERE T2.Population BETWEEN 160000 AND 900000 SELECT T1.language FROM languages AS T1 JOIN languages AS T2 ON T1.languages = T2.languages GROUP BY T1.language ORDER BY count(*) DESC LIMIT 1 SELECT T2.language, SELECT T1.language_type, t1.f_country, t1.f_country, t1.f_country, t1.f_country, t1.f_country, t1.f_country SELECT T1.language_spoken_by T1.country_of_people, COUNT(*) FROM people AS T1 JOIN people AS T2 ON T1.people_languages = T2.people_languages GROUP BY T1.country_of_people ORDER BY COUNT(*) SELECT country_code, languages_spoken_by_people, languages_languages_languages FROM languages GROUP BY country_code ORDER BY count(*) DESC LIMIT 1 SELECT sum(T1.COUNT(*)) FROM languages AS T1 JOIN languages AS T2 ON T1.Spanish = T2.Spanish GROUP BY T1.Spanish ORDER BY COUNT(*) DESC LIMIT 1 SELECT count(*) FROM languages WHERE Spanish = "Spanish" AND Spanish = "Spanish" = "Spanish" SELECT T1.country_code FROM languages AS T1 JOIN languages AS T2 ON T1.Spanish = T2.Spanish GROUP BY T1.country_code ORDER BY count(*) DESC LIMIT 1 SELECT T1.country_code FROM languages AS T1 JOIN languages AS T2 ON T1.languages_languages_languages = T2.languages_languages AS T3 ON T1.languages_languages_languages = T3.languages_languages AS T1 JOIN languages AS SELECT count(*) FROM conductors SELECT count(*) FROM conductors SELECT T1.Name FROM conductors AS T1 JOIN conductors AS T2 ON T1.Conductor = T2.Conductor ORDER BY T1.Age ASC SELECT T1.Name FROM conductors AS T1 JOIN conductors AS T2 ON T1.Conductor = T2.Conductor ORDER BY T1.Age SELECT T1.Name FROM conductor AS T1 JOIN conductors AS T2 ON T1.Conductor_ID = T2.Conductor_ID WHERE T2.Nationality NOT "USA" SELECT T1.Name FROM conductor AS T1 JOIN conductors AS T2 ON T1.Conductor_ID NOT IN (SELECT T1.Conductor_ID FROM conductors AS T1 JOIN Nationality AS T2 ON T1.Conductor_ID = T2. SELECT T1.Record_Company FROM orchestra AS T1 JOIN orchestra AS T2 ON T1.Orche_FROM orchestra AS T1 JOIN orchestra AS T2 ON T1.Orche_FROM orchestra AS T2 ON T1.Orche_FROM SELECT T1.Record_Company FROM orchestra AS T1 JOIN orchestra AS T2 ON T1.Orchea = T2.Orchea WHERE T2.Founded = '1989' AND T2.Year_of_founded = '1989' SELECT avg(attendance) FROM shows SELECT avg(attendance) FROM shows GROUP BY avg(attendance) SELECT max(share), min(share) FROM Performance WHERE genre_type!= "Live final" SELECT max(share), min(share) FROM Performances WHERE genre!= "Live final" SELECT count(DISTINCT Nationality) FROM conductors SELECT count(DISTINCT Nationality) FROM conductors SELECT T1.Name FROM conductors AS T1 JOIN conductors AS T2 ON T1.Conductor = T2.Conductor ORDER BY T1.Years_of_work DESC SELECT T1.Name FROM conductors AS T1 JOIN conductors AS T2 ON T1.Conductor = T2.Conductor ORDER BY T1.Year_Worked DESC SELECT T1.Name FROM conductor AS T1 JOIN conductor AS T2 ON T1.Conductor = T2.Conductor GROUP BY T1.Name ORDER BY COUNT(*) DESC LIMIT 1 SELECT T1.Name FROM conductor AS T1 JOIN conductor AS T2 ON T1.Conductor = T2.Conductor GROUP BY T1.Name HAVING count(*) >= 1 SELECT T1.Name_of_conductors, T1.The_orchestras_of_conductors, T1.The_orchestras_of_orchestras_of_orchestras_of_orchestras_of_orchestras_of_orchestras_of_orchestras_of SELECT T1.Name_of_conductors, T1.Corresonding_orchestras AS T1 JOIN conductors AS T2 ON T1.Conductor_ID = T2.Conductor_ID GROUP BY T1.Conductor_ID SELECT T1.Name FROM conductor AS T1 JOIN conductor AS T2 ON T1.Conductor = T2.Conductor WHERE T2.Name = "John" AND T2.Name = "One" SELECT T1.Name FROM conductor AS T1 JOIN conductor AS T2 ON T1.Conductor = T2.Conductor WHERE T2.Name = 'John' AND T2.Name = 'One' SELECT T1.Name FROM conductor AS T1 JOIN conductor AS T2 ON T1.Conductor = T2.Conductor GROUP BY T1.Conductor ORDER BY count(*) DESC LIMIT 1 SELECT T1.Name FROM conductor AS T1 JOIN conductor AS T2 ON T1.Conductor = T2.Conductor GROUP BY T1.Conductor ORDER BY count(*) DESC LIMIT 1 SELECT T1.Name FROM conductor AS T1 JOIN conductor AS T2 ON T1.Conductor = T2.Conductor WHERE T2.Founded < 2008 AND T2.Conducted < 2008 SELECT T1.Name FROM conductor AS T1 JOIN conductor AS T2 ON T1.Conductor = T2.Conductor WHERE T2.Year_2008 = 2008 AND T2.Conductor = T2.Conductor WHERE T2.Year_2008 = 2008 AND T SELECT DISTINCT T1.company, COUNT(*) FROM RECORDS AS T1 JOIN RECORD AS T2 ON T1.record_company = T2.record_company GROUP BY T1.record_company SELECT count(*) FROM RECORD_Company SELECT T1.record_format_of_orchestra, T1.record_format_of_count FROM orchestra AS T1 JOIN orchestra AS T2 ON T1.orchestra_id = T2.orchestra_id ORDER BY T1.count ASC SELECT Major_record_formats FROM orchestras GROUP BY Major_record_formats ORDER BY COUNT(*) DESC LIMIT 1 SELECT T1.record_company shared_by T1.record_company shared_by T1.record_company GROUP BY T1.record_company ORDER BY count(*) DESC LIMIT 1 SELECT T1.Record_Company_Used_by_The_Majority_of_Musical_Orches AS T1 JOIN RECORD AS T2 ON T1.Record_Company_Used_by_The_Majority_of_Musical_Orches AS T3 ON T1.Orches SELECT T1.Name FROM orchestra AS T1 JOIN performance AS T2 ON T1.Orcheas AS T3 ON T1.Orcheas AS T4 ON T1.Orcheas_ID = T4.Orcheas_ID WHERE T3.Performance = " SELECT T1.Orchestra_ID FROM orchestra AS T1 JOIN performances AS T2 ON T1.Orchestra_ID = T2.Orchestra_ID WHERE T2.Performance_ID NOT IN (SELECT T1.Orchestra_ID FROM performances AS SELECT T1.Record_Companies_Shared_by_ Orchestras_founded_Before 2003 AND T1.Songs_shared_by_Songs_shared_by_Songs_shared_by_Songs_shared_by_Songs_shared_by_Songs_shared_ SELECT T1.Record_Company_Name FROM orchestra AS T1 JOIN orchestra AS T2 ON T1.Orchea_founded_Before 2003 INTERSECT SELECT T1.Record_Company_Name FROM orchestra AS T1 JOIN orchestra AS T2 ON T SELECT count(*) FROM RECORDS WHERE record_format = "CD" OR "DVD" SELECT count(*) FROM orchestra AS T1 JOIN recordings AS T2 ON T1.Orchet = T2.DVD GROUP BY T1.Orchet ORDER BY count(*) DESC LIMIT 1 SELECT YEAR FROM orchestra WHERE Performance > 1 SELECT YEAR FROM orchestra WHERE Performance > 1 SELECT count(*) FROM COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) SELECT count(*), COUNT(*) FROM COUNT(*) GROUP BY COUNT(*) GROUP BY COUNT(*) DESC LIMIT 1 SELECT T1.Name, T1.Grades, T1.Grades FROM high schooler AS T1 JOIN high schooler AS T2 ON T1.HS_T1.HS_T1.high_schooler = T2.HS_T2.high_schooler SELECT T1.Name, T1.Grade FROM high school AS T1 JOIN high school AS T2 ON T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T SELECT avg(T1.Grade) FROM high school AS T1 JOIN high school AS T2 ON T1.HS_high_school_ers = T2.HS_high_school_ers SELECT grade FROM high schooler SELECT T1.StuID ORDER BY T2.StuID ORDER BY T2.StuID ORDER BY T2.StuID ORDER BY T2.StuID ORDER BY T2.StuID ORDER BY T2.StuID ORDER BY T2.StuID SELECT grade FROM high school WHERE t1.name = "Kyle" AND t2.name = "Kyle" SELECT T1.Name FROM Highschoolers AS T1 JOIN enroll AS T2 ON T1.HS_high_schooler = T2.HS_high_schooler ORDER BY T2.Grade DESC LIMIT 1 SELECT T1.name FROM HIGH SELECT T1.name FROM HIGH SELECT T1.name FROM HIGH SELECT T1.name FROM HIGH SELECT T1.name FROM HIGH SELECT T1.name FROM HIGH SELECT T1.name FROM HIGH SELECT T1.ID FROM high_school AS T1 JOIN high_school AS T2 ON T1.HS T1.HS T1.HS T1.HS T1.HS T1.HS T2.HS T1.HS T2.HS T1.HS T2.HS T2.HS T1.HS T2. SELECT T1.id FROM Kyle AS T1 JOIN id AS T2 ON T1.id = T2.id WHERE T2.id = "Kyle" AND T2.name = "Kyle" SELECT count(*), COUNT(*), 10 SELECT count(*) FROM high school WHERE grade 9 OR grade 10 = 9 SELECT count(*) FROM high schoolers GROUP BY grade SELECT count(*) FROM high schoolers GROUP BY grade SELECT T1. WHERE T2. GROUP BY T1. GROUP BY T1. GROUP BY T1. GROUP BY T1. GROUP BY T1. GROUP BY T1. GROUP BY T1. GROUP BY T1. GROUP BY T1. GROUP BY T1. GROUP BY T1. SELECT grade, t1.grade FROM high school AS t1 JOIN high school AS t2 ON t1.highschooler = t2.highschooler ORDER BY count(*) DESC LIMIT 1 SELECT t1.Grade FROM STUDENT AS t1 JOIN STUDENT AS t2 ON t1.Grace = t2.Grace HAVING count(*) >= 4 SELECT gname FROM high schoolers WHERE gname = 4 OR gname = 4 SELECT Student_ID, COUNT(*) FROM Student_Friend_Friend SELECT count(*) FROM Student SELECT T1.Name, T1.Number_of_Friend FROM high school AS T1 JOIN high school AS T2 ON T1.High_school_student = T2.high_school_student GROUP BY T1.High_school_student SELECT T1.Name, count(*) FROM high school AS T1 JOIN high school AS T2 ON T1.HS_high_school_er = T2.HS_high_schooler GROUP BY T1.HS_high_schooler SELECT T1.name FROM HIGHHS AS T1 JOIN HIGHHS AS T2 ON T1.name = t3.highschooler GROUP BY T1.highschooler ORDER BY COUNT(*) DESC LIMIT 1 SELECT T1.Name FROM Highschool Student ORDER BY T1.Name ORDER BY T1.Name ORDER BY T1.Name ORDER BY T1.Name ORDER BY T1.Name ORDER BY T1.Name ORDER BY T1.Name ORDER BY T1.Name ORDER BY T1. SELECT T1.Name FROM high school AS T1 JOIN high school AS T2 ON T1.HS_high_schooler = T2.high_schooler WHERE T2.Friend = 3 SELECT T1.Name FROM High School_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu_Stu SELECT T1.Name FROM t3.Fname ORDER BY T1.Name DESC LIMIT 1 SELECT T1.Fname FROM Official Fname ORDER BY T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1. SELECT count(*) FROM friendships WHERE Kyle = "high school student" AND COUNT(*) = "null" SELECT count(*) FROM LIKE COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) SELECT T1.ID FROM STUDENT AS T1 JOIN Student AS T2 ON T1.StuID = T2.StuID WHERE T2.Friend NOT IN (SELECT T1.ID FROM STUDENT AS T3 ON T1.StuID = T3.Stu SELECT T1.id FROM STUDENT AS T1 JOIN teachers AS T2 ON T1.high_school_student_id = T2.high_school_student_id WHERE T2.friend_is NOT IN (SELECT T1.id FROM STUDENT AS T3 ON T SELECT T1.Name FROM high school AS T1 JOIN enroll AS T2 ON T1.HS_StuID = T2.HS_StuID WHERE T2.Name = 'high school' SELECT T1.Name FROM Students AS T1 JOIN Students AS T2 ON T1.StuID = T2.StuID GROUP BY T1.StuID ORDER BY T1.StuID ORDER BY T1.StuID ORDER BY T1.StuID SELECT T1.Id FROM high schoolers AS T1 JOIN teachers AS T2 ON T1.HS_T1.HS_T1.HS_T1.HS_T2.HS_T2.HS_T2.HS_T2.HS_T2.HS_T2.HS_T2. SELECT T1.id FROM STUDENT AS T1 JOIN Students AS T2 ON T1.student_id = T2.student_id WHERE T2.friend = 'friend' INTERSECT SELECT T1.id FROM STUDENT AS T1 JOIN Student AS T2 SELECT T1.name FROM STUDENT AS T1 JOIN STUDENT AS T2 ON T1.student_id = T2.student_id WHERE T2.friend_by_ = 'friend' AND T2.friend_by_ = 'friend' SELECT T1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t1. t2. t2. t2. t2. t2. t2. t2. t SELECT count(*) FROM Student_ID SELECT count(*) FROM Student_ID SELECT T1.Name, T1.Number_of_LIKEs, T1.Number_of_LIKEs FROM high school AS T1 JOIN LIKES AS T2 ON T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1. SELECT T1.Name FROM high school AS T1 JOIN LIKES AS T2 ON T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1.HS_T1. SELECT T1.name FROM LIKES GROUP BY T1.name ORDER BY COUNT(*) DESC LIMIT 1 SELECT T1.Name FROM Student GROUP BY T1.StuID ORDER BY T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1.T1. SELECT T1.Name FROM Students AS T1 JOIN Students AS T2 ON T1.StuID = T2.StuID WHERE T2.LIKE = 2 SELECT T1.name FROM Students AS T1 JOIN Students AS T2 ON T1.stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu_stu SELECT T1.Name FROM STUDENT AS T1 JOIN STUDENT AS T2 ON T1.StuID = T2.StuID WHERE T2.Grade > 5 AND T2.Friend = 2 SELECT T1.Name FROM highschoolers AS T1 JOIN highschoolers AS T2 ON T1.HS_high_schooler_id = T2.HS_high_schooler_id WHERE T2.Grade > 5 AND T2.Friends = 2 OR T2.Friend SELECT count(*) FROM LIKES WHERE Kyle LIKE "%%" SELECT count(*) FROM LIKES WHERE t1.name = "Kyle" AND t2.schooler = "Kyle" SELECT avg(Grade) FROM STUDENT WHERE LIKE "%friend%" SELECT avg(AVG(Grade) FROM STUDENT WHERE Friends = "Friend" SELECT min(Grade) FROM STUDENT WHERE LIKE '%friend%' SELECT t1.grade FROM STUDENT AS t1 JOIN STUDENT AS t2 ON t1.stuid = t2.stuid WHERE t1.friend = 'friend' SELECT T1.state_of_living_state FROM residents AS T1 JOIN professionals AS T2 ON T1.state_of_building = T2.state_of_building AS T3 ON T1.state_of_building = T3.state_of_building SELECT State FROM residents WHERE Occupation = "Professional" INTERSECT SELECT State FROM residents WHERE Occupation = "Professor" SELECT avg(age) FROM dogs WHERE age > (SELECT avg(age) FROM dogs) SELECT avg(age) FROM dogs WHERE treated_treatments = "treatment" SELECT T1.last_name, T1.last_name, T1.cell_phone FROM professionals AS T1 JOIN procedures AS T2 ON T1.prof_id = T2.prof_id WHERE T2.state_of_Indiana = 2 OR T SELECT T1.id, T1.last_name, T1.cell_phone FROM professionals AS T1 JOIN professionals AS T2 ON T1.prof_id = T2.prof_id WHERE T2.state_of_Indiana = 2 OR T1.state SELECT T1.Name FROM dogs AS T1 JOIN dogs AS T2 ON T1.Dog_ID = T2.Dog_ID WHERE T2.Price > 1000 GROUP BY T1.Dog_ID HAVING count(*) > 1000 SELECT T1.Name FROM dogs AS T1 JOIN dogs AS T2 ON T1.Dog_ID = T2.Dog_ID WHERE T2.Owner_Stays > 1000 GROUP BY T1.Dog_ID HAVING count(*) > 1000 SELECT T1.first_name FROM dogs AS T1 JOIN dogs AS T2 ON T1.dog_name = T2.dog_name WHERE T2.owner_name = "Professional" OR T2.owner_name = "Owner" SELECT T1.fname FROM dogs AS T1 JOIN dogs AS T2 ON T1.fname = T2.fname WHERE T2.owner_name = "Professor" OR T1.owner_name = "Dog" SELECT T1.Professor's_id, T1.role, T1.email FROM professionals AS T1 JOIN dogs AS T2 ON T1.Professor_id = T2.Professor_id WHERE T2.treatment_on_dogs = SELECT T1.id, T1.role, T1.email FROM professionals AS T1 JOIN dogs AS T2 ON T1.prof_id = T2.prof_id WHERE T2.treatment_on_dogs = "no" SELECT T1.owner_id, T1.first_name, T1.last_name, T1.last_name FROM OWNER AS T1 JOIN dogs AS T2 ON T1.owner_id = T2.owner_id GROUP BY T1.owner_ SELECT T1.owner_id, T1.last_name, T1.last_name FROM OWNER AS T1 JOIN dogs AS T2 ON T1.owner_id = T2.owner_id GROUP BY T1.owner_id ORDER BY count(*) SELECT T1.Professor, T1.Professor FROM professionals AS T1 JOIN procedures AS T2 ON T1.Professor = T2.Professor GROUP BY T1.Professor HAVING count(*) >= 2 SELECT T1.id, T1.role, T1.first_name FROM professionals AS T1 JOIN procedures AS T2 ON T1.prof_id = T2.prof_id WHERE T2.treatment_duration > 2 OR T1.treatment_duration > 2 SELECT T1.name FROM dogs AS T1 JOIN dogs AS T2 ON T1.dog = T2.dog GROUP BY T1.breed ORDER BY count(*) DESC LIMIT 1 SELECT t1.breed, t2.breed, t1.breed, t1.breed, t1.breed, t1.breed, t1.breed, t1.breed, t1.breed, t2.breed, SELECT T1.owner_id, T1.last_name FROM OWNER AS T1 JOIN dogs AS T2 ON T1.owner_id = T2.owner_id GROUP BY T1.owner_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.owner_id, T1.last_name FROM OWNER AS T1 JOIN pets AS T2 ON T1.owner_id = T2.owner_id GROUP BY T1.owner_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.description FROM procedures AS T1 JOIN treatment AS T2 ON T1.treatment_type = T2.treatment_type WHERE T1.cost_in_total = '%%' SELECT T1.treatment_type FROM procedures AS T1 JOIN procedures AS T2 ON T1.treatment_type = T2.treatment_type WHERE T1.total_cost = 'low' SELECT T1.owner_id, T1.zip_code FROM OWNER AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id GROUP BY T1.owner_id ORDER BY sum(T1.amount_of_money) SELECT T1.owner_id, T1.zip_code FROM OWNER AS T1 JOIN dogs AS T2 ON T1.owner_id = T2.owner_id GROUP BY T1.owner_id ORDER BY count(*) DESC LIMIT 1 SELECT T1.Prof_ID, T1.Cell_Phone FROM professionals AS T1 JOIN procedures AS T2 ON T1.Prof_ID = T2.Prof_ID GROUP BY T1.Prof_ID HAVING count(*) >= 2 SELECT T1.id, T1.cell_phone FROM professionals AS T1 JOIN procedures AS T2 ON T1.prof_id = T2.prof_id WHERE T2.treatment_type_of_treatment = 'treatment' SELECT T1.first_name, T1.last_name FROM professionals AS T1 JOIN procedures AS T2 ON T1.treatment_cost_below_average = T2.treatment_cost_below_average WHERE T2.cost_below_average = "treatment" SELECT T1.first_name, T1.last_name FROM procedures AS T1 JOIN procedures AS T2 ON T1.treatment_costs < (SELECT avg(T2.average) FROM procedures AS T1 JOIN procedures AS T2 ON T1.treatment_ SELECT Date_of_treatment, T1.First_name FROM procedures AS T1 JOIN procedures AS T2 ON T1.treatment_id = T2.treatment_id GROUP BY T1.treatment_id SELECT Date, operating_prof's first_name, operating_prof's first_name FROM procedures AS t1 JOIN procedures AS t2 ON t1.treatment_id = t2.treatment_id WHERE T2.treatment_first SELECT cost_of_treatment, t1.treatment_type_description FROM procedures AS t1 JOIN procedures AS t2 ON t1.treatment_type_description = t2.treatment_type_description SELECT cost, treatment_type_description FROM therapy SELECT T1.first_name, T1.last_name, T1.size FROM OWNER AS T1 JOIN DOG AS T2 ON T1.owner_id = T2.owner_id GROUP BY T1.owner_id SELECT T1.first_name, T1.last_name, T1.size FROM OWNER AS T1 JOIN DOG AS T2 ON T1.owner_id = T2.owner_id GROUP BY T1.owner_id HAVING count(*) >= 1 SELECT T1.Owner's first_name, T1.Dog's_first_name FROM Dogs AS T1 JOIN Dogs AS T2 ON T1.Dog = T2.Dog WHERE T2.First_name = "F" INTERSECT SELECT T1. SELECT T1.owner's_first_name, T1.dog's_first_name FROM owners AS T1 JOIN dogs AS T2 ON T1.owner_id = T2.owner_id WHERE T2.dogs_first_name = "F" SELECT T1.Name, T1.Treatment_Date FROM dogs AS T1 JOIN dogs AS T2 ON T1.Dog_Name = T2.Dog_Name ORDER BY T1.Treatment_Date DESC LIMIT 1 SELECT T1.Name, T1.Treatment_Date FROM dogs AS T1 JOIN dogs AS T2 ON T1.Dog = T2.Dog WHERE T2.Treatment_Date = "rare" SELECT T1.owner's first_name, T1.owner's last_name, T1.owner's first_name FROM dogs AS T1 JOIN dogs AS T2 ON T1.owner_id = T2.owner_id WHERE T2.country SELECT T1.Name_of_Owners_Living_in_Virginia, T1.Name_of_Dogs_There = T2.Dog_There = T2.Dog_There ORDER BY T1.Country_of_Living_in_Virginia DESC LIMIT 1 SELECT T1.Arrival_Date, T1.Departing_Date FROM dogs AS T1 JOIN dogs AS T2 ON T1.Dog_ID = T2.Dog_ID WHERE T2.Treatment = "treatment" SELECT T1.Arrival_Date, T1.Departing_Date FROM dogs AS T1 JOIN dogs AS T2 ON T1.Dog_Treatment_Date = T2.Dog_Treatment_Date WHERE T2.Treatment_Date = "treatment" SELECT T1.last_name FROM OWNER AS T1 JOIN DOG AS T2 ON T1.OWNER = T2.OWNER ORDER BY T1.age LIMIT 1 SELECT T1.Name FROM LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE LIKE SELECT T1.email_of_employees AS T1 JOIN employees AS T2 ON T1.email_of_employees = T2.email_of_employees WHERE T2.state_of_Alaska OR T2.state_of_ Wisconsin = T2.email_of_employees W SELECT T1.email_of_employees AS T1 JOIN employees AS T2 ON T1.prof_office_id = T2.prof_office_id WHERE T2.state_of_hawaii = 'Honolulu' OR T2.state_of_ Wisconsin = ' SELECT T1.Arrival_Date, T1.Departing_Date FROM dogs AS T1 JOIN dogs AS T2 ON T1.Dog_ID = T2.Dog_ID GROUP BY T1.Dog_ID SELECT Arrival_Date, Arrival_Date FROM Dogs SELECT count(*) FROM dogs WHERE procedures = "no" AND procedures = "no" SELECT count(*) FROM dogs WHERE a_treatment!= "treatment" SELECT count(*) FROM professionals WHERE pets = "%dogs%" SELECT count(*) FROM professionals WHERE treated_dogs = "%dogs%" AND treated_dogs = "%dogs%" SELECT T1.Professor, T1.City, T1.State FROM professionals AS T1 JOIN professionals AS T2 ON T1.Professor = T2.Professor WHERE T2.City = 'West' SELECT T1.role, T1.city, T1.city FROM professionals AS T1 JOIN professionals AS T2 ON T1.prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof SELECT T1.first_name, T1.last_name, T1.email FROM OWNER AS T1 JOIN OWNER AS T2 ON T1.OWNER = T2.OWNER WHERE T2.state = 'North' SELECT T1.first_name, T1.last_name, T1.email FROM OWNER AS T1 JOIN OWNER AS T2 ON T1.OWNER_ID = T2.OWNER_ID WHERE T2.state_name LIKE '%North SELECT count(*) FROM dogs WHERE age < (SELECT avg(age) FROM dogs) SELECT count(*) FROM dogs WHERE age < (SELECT avg(age) FROM dogs) SELECT sum(T1.cost) FROM procedures AS T1 JOIN procedures AS T2 ON T1.treatment_cost = T2.treatment_cost GROUP BY T1.treatment_cost ORDER BY count(*) DESC LIMIT 1 SELECT cost_of_treatment FROM Maintenance_Repe_treatments ORDER BY COUNT(*) DESC LIMIT 1 SELECT count(*) FROM dogs WHERE dogs_type_code NOT IN (SELECT dogs_type_code FROM dogs) SELECT count(*) FROM dogs WHERE Dogs_Name NOT IN (SELECT Dogs_Name FROM dogs WHERE Dogs_Name NOT IN (SELECT Dogs_Name FROM dogs WHERE Dogs_Name NOT IN (SELECT Dogs_Name FROM dogs W SELECT count(*) FROM dogs WHERE OWNER NOT IN (SELECT OWNER FROM dogs) SELECT count(*) FROM dogs WHERE OWNER_ID NOT IN (SELECT OWNER_ID FROM dogs) SELECT count(*) FROM professionals WHERE pets = "dogs" AND dogs = "yellow" SELECT count(*) FROM professionals WHERE treated_no_dogs = 'no' SELECT T1.name, T1.age, T1.weight FROM dogs AS T1 JOIN dogs AS T2 ON T1.dog_id = T2.dog_id WHERE T2.abandoned = 1 SELECT T1.Dog_name, T1.Age, T1.Weight FROM dogs AS T1 JOIN dogs AS T2 ON T1.Dog_ID = T2.Dog_ID WHERE T2.Bad_Adoption = "abandoned" SELECT avg(age) FROM dogs SELECT avg(age) FROM dogs GROUP BY avg(age) SELECT Age FROM dogs WHERE Age = "oldest" SELECT Age_of_Dog FROM Dogs WHERE Age_of_Dog = "oldest" SELECT count(*), sum(cost) FROM Payments SELECT T1.Charge_Type, T1.Amount FROM Payments AS T1 JOIN Payments AS T2 ON T1.Charge_Type = T2.Charge_Type_Type_Type_Type_Type_Type_Type_Type_Type_Type_Type_Type SELECT count(*) FROM expenses GROUP BY COUNT(*) ORDER BY count(*) DESC LIMIT 1 SELECT count(*) FROM expenses GROUP BY COUNT(*) ORDER BY COUNT(*) DESC LIMIT 1 SELECT email, cell phone, home phone FROM professionals SELECT email, cell phone, home phone FROM professionals SELECT breed_type, age_type, sizes_type FROM breeds WHERE breed_type = "breed" INTERSECT SELECT breed_type, age_type FROM breeds WHERE breed_type = " SELECT DISTINCT Breed_Type, Height_Type, Height_Type FROM Dogs SELECT T1.first_name, T1.description FROM professionals AS T1 JOIN procedures AS T2 ON T1.prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_prof_ SELECT T1.first_name, T1.description FROM professionals AS T1 JOIN procedures AS T2 ON T1.prof_id = T2.prof_id WHERE T2.treatment_type_code = "treatment" SELECT count(*) FROM singers SELECT count(*) FROM Singers SELECT T1.Name FROM Singers AS T1 JOIN Singers AS T2 ON T1.Songs = T2.Songs ORDER BY T1.Net_Worth ASC SELECT T1.Name FROM Singers AS T1 JOIN Singers AS T2 ON T1.Songs_Ordered_by_Ascending_Net_Worth = T2.Songs_Ordered_by_Ascending_Net_Worth AS T3 ON T1.Songs_ SELECT Birth_Year, Citizenship FROM Singers WHERE Citizenship = "Songer" SELECT Birth_Year, Citizenship FROM Singers WHERE Citizenship = "The Singers" SELECT T1.Name FROM singers AS T1 JOIN vocals AS T2 ON T1.Songs_Name = T2.Songs_Name WHERE T2.Citizenship!= "France" SELECT T1.Name FROM singers AS T1 JOIN vocals AS T2 ON T1.Songs_of_France = T2.Songs_of_French AS T3 ON T1.Songs_of_French = T3.Songs_of_French AS T SELECT T1.Name FROM Singers AS T1 JOIN Birth_Years AS T2 ON T1.Songs_ID = T2.Songs_ID WHERE T1.Birth_Year = 1948 OR T1.Birth_Year = 1949 SELECT T1.Name FROM Singers AS T1 JOIN Birth_Years AS T2 ON T1.Songs_ID = T2.Songs_ID WHERE T2.Birth_Year = 1948 OR T2.Birth_Year = 1949 SELECT T1.name FROM singers AS T1 JOIN singers AS T2 ON T1.songs_id = T2.songs_id GROUP BY T1.songs_id ORDER BY COUNT(*) DESC LIMIT 1 SELECT T1.name FROM singers AS T1 JOIN singers AS T2 ON T1.songs_id = T2.songs_id GROUP BY T1.songs_id ORDER BY count(*) DESC LIMIT 1 SELECT DISTINCT Citizenship, COUNT(*) FROM Singers SELECT count(*) FROM singers AS t1 JOIN languages AS t2 ON t1.languages_id = t2.languages_id GROUP BY t1.country SELECT citizenship, citizenship FROM singers GROUP BY citizenship ORDER BY COUNT(*) DESC LIMIT 1 SELECT t1.citizenship FROM singers AS t1 JOIN citizenship AS t2 ON t1.singer_citizenship = t2.singer_citizenship GROUP BY t1.singer_citizenship ORDER BY count(*) DESC LIMIT 1 SELECT Citizenship, Maximum Net_Worth FROM Singers GROUP BY Citizenship SELECT max(Net_Worth) FROM citizenship GROUP BY max(Net_Worth) SELECT T1.Titles_of_Songs, T1.Name_of_Singers FROM Songs AS T1 JOIN Songs AS T2 ON T1.Songs_and_Name_of_Singers = T2.Songs_and_Name_of_Singers SELECT T1.Song_Titles, T1.Song_Name FROM SONGS AS T1 JOIN SONGS AS T2 ON T1.Song_Titles = T2.Song_Titles GROUP BY T1.Song_Titles SELECT DISTINCT T1.Name FROM singers AS T1 JOIN songs AS T2 ON T1.Songs_with_sales > 300000 SELECT DISTINCT T1.Name FROM singers AS T1 JOIN singers AS T2 ON T1.Songs_ID = T2.Songs_ID WHERE T1.Sales > 300000 GROUP BY T1.Songs_ID HAVING count(*) > 300000 SELECT T1.Name FROM Singers AS T1 JOIN Songs AS T2 ON T1.Songs = T2.Songs GROUP BY T1.Songs HAVING count(*) > 1 SELECT T1.Name FROM singers AS T1 JOIN songs AS T2 ON T1.Songs = T2.Songs GROUP BY T1.Songs HAVING count(*) > 1 SELECT T1.Name, T1.Total_Sales FROM singers AS T1 JOIN songs AS T2 ON T1.Songs_by_T1.Songs_by_T1.Songs_by_T1.Songs_by_T1.Songs_by_T1. SELECT COUNT(*) FROM singers AS t1 JOIN songs AS t2 ON t1.songid = t2.songid GROUP BY t1.name SELECT T1.Name FROM singers AS T1 JOIN songs AS T2 ON T1.Songs_ID = T2.Songs_ID WHERE T2.Song_Name NOT IN (SELECT T1.Song_Name FROM singers AS T1 JOIN songs AS T2 ON SELECT T1.Sname FROM song AS T1 JOIN song AS T2 ON T1.Sname = T2.Sname WHERE T2.Song_Name NOT IN (SELECT T1.Song_Name FROM song AS T1 JOIN song AS T2 ON T1.Song_Name SELECT citizenship shared_by singers WHERE birth_year = 1945 INTERSECT SELECT citizenship_shared_by singers WHERE birth_year = 1955 INTERSECT SELECT citizenship_shared_by singers WHERE birth_year = 1955 SELECT citizenship FROM Singers WHERE birth_year!= 1945 INTERSECT SELECT citizenship FROM Singers WHERE birth_year!= 1955 SELECT count(*) FROM Contents GROUP BY COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) COUNT(*) SELECT T1.FName FROM SELECT T1.FName FROM SELECT T1.FName FROM SELECT T1.FName FROM SELECT T1.FName FROM SELECT T1.FName FROM SELECT T1.FName FROM SELECT T1.FName F SELECT T1.Property_Type_Descriptions FROM Properties AS T1 JOIN Properties AS T2 ON T1.Code = T2.Code ORDER BY T2.Code DESC LIMIT 1 SELECT T1.Name FROM Properties AS T1 JOIN Apartments AS T2 ON T1.Homes_ID = T2.Homes_ID WHERE T2.Room > 1