Match OK easy pred: SELECT Count(*) FROM singer easy gold: SELECT count(*) FROM singer --- Match OK easy pred: SELECT Count(*) FROM singer easy gold: SELECT count(*) FROM singer --- Match Fail medium pred: SELECT singer.Name, singer.Country, singer.Age FROM singer ORDER BY singer.Age Asc medium gold: SELECT name , country , age FROM singer ORDER BY age DESC --- Match OK medium pred: SELECT singer.Name, singer.Country, singer.Age FROM singer ORDER BY singer.Age Desc medium gold: SELECT name , country , age FROM singer ORDER BY age DESC --- Match Fail medium pred: SELECT Avg(singer.Age), Avg(singer.Age), Max(singer.Age) FROM singer WHERE singer.Country = 'terminal' medium gold: SELECT avg(age) , min(age) , max(age) FROM singer WHERE country = 'France' --- Match OK medium pred: SELECT Avg(singer.Age), Min(singer.Age), Max(singer.Age) FROM singer WHERE singer.Country = 'terminal' medium gold: SELECT avg(age) , min(age) , max(age) FROM singer WHERE country = 'France' --- Match OK medium pred: SELECT singer.Song_Name, singer.Song_release_year FROM singer ORDER BY singer.Age Asc LIMIT 1 medium gold: SELECT song_name , song_release_year FROM singer ORDER BY age LIMIT 1 --- Match OK medium pred: SELECT singer.Song_Name, singer.Song_release_year FROM singer ORDER BY singer.Age Asc LIMIT 1 medium gold: SELECT song_name , song_release_year FROM singer ORDER BY age LIMIT 1 --- Match OK easy pred: SELECT DISTINCT singer.Country FROM singer WHERE singer.Age > 'terminal' easy gold: SELECT DISTINCT country FROM singer WHERE age > 20 --- Match OK easy pred: SELECT DISTINCT singer.Country FROM singer WHERE singer.Age > 'terminal' easy gold: SELECT DISTINCT country FROM singer WHERE age > 20 --- Match OK medium pred: SELECT singer.Country, Count(*) FROM singer GROUP BY singer.Country medium gold: SELECT country , count(*) FROM singer GROUP BY country --- Match OK medium pred: SELECT singer.Country, Count(*) FROM singer GROUP BY singer.Country medium gold: SELECT country , count(*) FROM singer GROUP BY country --- Match Fail hard pred: SELECT singer.Name FROM singer WHERE singer.Age > (SELECT Avg(singer.Age) FROM singer) hard gold: SELECT song_name FROM singer WHERE age > (SELECT avg(age) FROM singer) --- Match Fail hard pred: SELECT singer.Name FROM singer WHERE singer.Age > (SELECT Avg(singer.Age) FROM singer) hard gold: SELECT song_name FROM singer WHERE age > (SELECT avg(age) FROM singer) --- Match OK medium pred: SELECT stadium.Location, stadium.Name FROM stadium WHERE stadium.Capacity BETWEEN 'terminal' AND 'terminal' medium gold: SELECT LOCATION , name FROM stadium WHERE capacity BETWEEN 5000 AND 10000 --- Match OK medium pred: SELECT stadium.Location, stadium.Name FROM stadium WHERE stadium.Capacity BETWEEN 'terminal' AND 'terminal' medium gold: SELECT LOCATION , name FROM stadium WHERE capacity BETWEEN 5000 AND 10000 --- Match Fail medium pred: SELECT Max(stadium.Capacity), Avg(stadium.Capacity) FROM stadium medium gold: select max(capacity), average from stadium --- Match OK medium pred: SELECT Avg(stadium.Capacity), Max(stadium.Capacity) FROM stadium medium gold: select avg(capacity) , max(capacity) from stadium --- Match Fail medium pred: SELECT stadium.Name, stadium.Capacity FROM stadium JOIN concert GROUP BY concert.Stadium_ID ORDER BY Avg(stadium.Average) Desc LIMIT 1 medium gold: SELECT name , capacity FROM stadium ORDER BY average DESC LIMIT 1 --- Match Fail medium pred: SELECT stadium.Name, stadium.Capacity FROM stadium JOIN concert GROUP BY concert.Stadium_ID ORDER BY Avg(stadium.Average) Desc LIMIT 1 medium gold: SELECT name , capacity FROM stadium ORDER BY average DESC LIMIT 1 --- Match OK medium pred: SELECT Count(*) FROM concert WHERE concert.Year = 'terminal' OR concert.Year = 'terminal' medium gold: SELECT count(*) FROM concert WHERE YEAR = 2014 OR YEAR = 2015 --- Match OK medium pred: SELECT Count(*) FROM concert WHERE concert.Year = 'terminal' OR concert.Year = 'terminal' medium gold: SELECT count(*) FROM concert WHERE YEAR = 2014 OR YEAR = 2015 --- Match OK medium pred: SELECT stadium.Name, Count(*) FROM concert JOIN stadium GROUP BY concert.Stadium_ID medium gold: SELECT T2.name , count(*) FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id GROUP BY T1.stadium_id --- Match OK medium pred: SELECT stadium.Name, Count(*) FROM stadium JOIN concert GROUP BY stadium.Stadium_ID medium gold: SELECT T2.name , count(*) FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id GROUP BY T1.stadium_id --- Match OK extra pred: SELECT stadium.Name, stadium.Capacity FROM concert JOIN stadium WHERE concert.Year >= 'terminal' GROUP BY concert.Stadium_ID ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T2.name , T2.capacity FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id WHERE T1.year >= 2014 GROUP BY T2.stadium_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT stadium.Name, stadium.Capacity FROM stadium JOIN concert WHERE concert.Year > 'terminal' ORDER BY stadium.Capacity Desc LIMIT 1 extra gold: select t2.name , t2.capacity from concert as t1 join stadium as t2 on t1.stadium_id = t2.stadium_id where t1.year > 2013 group by t2.stadium_id order by count(*) desc limit 1 --- Match OK hard pred: SELECT concert.Year FROM concert GROUP BY concert.Year ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT YEAR FROM concert GROUP BY YEAR ORDER BY count(*) DESC LIMIT 1 --- Match OK hard pred: SELECT concert.Year FROM concert GROUP BY concert.Year ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT YEAR FROM concert GROUP BY YEAR ORDER BY count(*) DESC LIMIT 1 --- Match OK hard pred: SELECT stadium.Name FROM stadium WHERE stadium.Stadium_ID NOT IN (SELECT concert.Stadium_ID FROM concert) hard gold: SELECT name FROM stadium WHERE stadium_id NOT IN (SELECT stadium_id FROM concert) --- Match Fail hard pred: SELECT stadium.Name FROM stadium EXCEPT SELECT stadium.Name FROM stadium JOIN concert hard gold: SELECT name FROM stadium WHERE stadium_id NOT IN (SELECT stadium_id FROM concert) --- Match OK hard pred: SELECT singer.Country FROM singer WHERE singer.Age > 'terminal' INTERSECT SELECT singer.Country FROM singer WHERE singer.Age < 'terminal' hard gold: SELECT country FROM singer WHERE age > 40 INTERSECT SELECT country FROM singer WHERE age < 30 --- Match OK hard pred: SELECT stadium.Name FROM stadium EXCEPT SELECT stadium.Name FROM stadium JOIN concert WHERE concert.Year = 'terminal' hard gold: SELECT name FROM stadium EXCEPT SELECT T2.name FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id WHERE T1.year = 2014 --- Match OK hard pred: SELECT stadium.Name FROM stadium EXCEPT SELECT stadium.Name FROM stadium JOIN concert WHERE concert.Year = 'terminal' hard gold: SELECT name FROM stadium EXCEPT SELECT T2.name FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id WHERE T1.year = 2014 --- Match Fail medium pred: SELECT singer.Name, concert.Theme, Count(*) FROM concert JOIN singer_in_concert JOIN singer GROUP BY singer.Name medium gold: SELECT T2.concert_name , T2.theme , count(*) FROM singer_in_concert AS T1 JOIN concert AS T2 ON T1.concert_id = T2.concert_id GROUP BY T2.concert_id --- Match Fail medium pred: SELECT concert.concert_Name, concert.Theme, Count(*) FROM concert GROUP BY concert.concert_Name medium gold: select t2.concert_name , t2.theme , count(*) from singer_in_concert as t1 join concert as t2 on t1.concert_id = t2.concert_id group by t2.concert_id --- Match Fail medium pred: SELECT stadium.Name, Count(*) FROM concert JOIN stadium GROUP BY stadium.Name medium gold: SELECT T2.name , count(*) FROM singer_in_concert AS T1 JOIN singer AS T2 ON T1.singer_id = T2.singer_id GROUP BY T2.singer_id --- Match Fail medium pred: SELECT singer.Song_Name, Count(*) FROM singer GROUP BY singer.Song_Name medium gold: SELECT T2.name , count(*) FROM singer_in_concert AS T1 JOIN singer AS T2 ON T1.singer_id = T2.singer_id GROUP BY T2.singer_id --- Match Fail hard pred: SELECT concert.concert_Name FROM concert WHERE concert.Year = 'terminal' hard gold: SELECT T2.name FROM singer_in_concert AS T1 JOIN singer AS T2 ON T1.singer_id = T2.singer_id JOIN concert AS T3 ON T1.concert_id = T3.concert_id WHERE T3.year = 2014 --- Match Fail hard pred: SELECT concert.concert_Name FROM concert WHERE concert.Year = 'terminal' hard gold: SELECT T2.name FROM singer_in_concert AS T1 JOIN singer AS T2 ON T1.singer_id = T2.singer_id JOIN concert AS T3 ON T1.concert_id = T3.concert_id WHERE T3.year = 2014 --- Match Fail medium pred: SELECT stadium.Name, singer.Country FROM stadium JOIN singer_in_concert JOIN singer WHERE singer.Song_Name LIKE 'terminal' medium gold: SELECT name , country FROM singer WHERE song_name LIKE '%Hey%' --- Match OK medium pred: SELECT singer.Name, singer.Country FROM singer WHERE singer.Song_Name LIKE 'terminal' medium gold: SELECT name , country FROM singer WHERE song_name LIKE '%Hey%' --- Match OK extra pred: SELECT stadium.Name, stadium.Location FROM concert JOIN stadium WHERE concert.Year = 'terminal' INTERSECT SELECT stadium.Name, stadium.Location FROM concert JOIN stadium WHERE concert.Year = 'terminal' extra gold: SELECT T2.name , T2.location FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id WHERE T1.Year = 2014 INTERSECT SELECT T2.name , T2.location FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id WHERE T1.Year = 2015 --- Match OK extra pred: SELECT stadium.Name, stadium.Location FROM stadium JOIN concert WHERE concert.Year = 'terminal' INTERSECT SELECT stadium.Name, stadium.Location FROM stadium JOIN concert WHERE concert.Year = 'terminal' extra gold: SELECT T2.name , T2.location FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id WHERE T1.Year = 2014 INTERSECT SELECT T2.name , T2.location FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id = T2.stadium_id WHERE T1.Year = 2015 --- Match Fail hard pred: SELECT Count(*) FROM stadium ORDER BY stadium.Capacity Desc LIMIT 1 hard gold: select count(*) from concert where stadium_id = (select stadium_id from stadium order by capacity desc limit 1) --- Match Fail hard pred: SELECT Count(*) FROM stadium ORDER BY stadium.Capacity Desc LIMIT 1 hard gold: select count(*) from concert where stadium_id = (select stadium_id from stadium order by capacity desc limit 1) --- Match OK easy pred: SELECT Count(*) FROM Pets WHERE Pets.weight > 'terminal' easy gold: SELECT count(*) FROM pets WHERE weight > 10 --- Match OK easy pred: SELECT Count(*) FROM Pets WHERE Pets.weight > 'terminal' easy gold: SELECT count(*) FROM pets WHERE weight > 10 --- Match Fail medium pred: SELECT Pets.weight FROM Pets WHERE Pets.pet_age = (SELECT Min(Pets.pet_age) FROM Pets) medium gold: SELECT weight FROM pets ORDER BY pet_age LIMIT 1 --- Match OK medium pred: SELECT Pets.weight FROM Pets ORDER BY Pets.pet_age Asc LIMIT 1 medium gold: SELECT weight FROM pets ORDER BY pet_age LIMIT 1 --- Match OK medium pred: SELECT Max(Pets.weight), Pets.PetType FROM Pets GROUP BY Pets.PetType medium gold: SELECT max(weight) , petType FROM pets GROUP BY petType --- Match OK medium pred: SELECT Max(Pets.weight), Pets.PetType FROM Pets GROUP BY Pets.PetType medium gold: SELECT max(weight) , petType FROM pets GROUP BY petType --- Match Fail medium pred: SELECT Count(*) FROM Has_Pet JOIN Student JOIN Pets WHERE Student.Age > 'terminal' medium gold: SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.age > 20 --- Match Fail medium pred: SELECT Count(*) FROM Has_Pet JOIN Student JOIN Pets WHERE Student.Age > 'terminal' medium gold: SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.age > 20 --- Match OK hard pred: SELECT Count(*) FROM Has_Pet JOIN Student JOIN Pets WHERE Student.Sex = 'terminal' AND Pets.PetType = 'terminal' hard gold: SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T2.petid = T3.petid WHERE T1.sex = 'F' AND T3.pettype = 'dog' --- Match OK hard pred: SELECT Count(*) FROM Has_Pet JOIN Student JOIN Pets WHERE Student.Sex = 'terminal' AND Pets.PetType = 'terminal' hard gold: SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T2.petid = T3.petid WHERE T1.sex = 'F' AND T3.pettype = 'dog' --- Match OK easy pred: SELECT Count(DISTINCT Pets.PetType) FROM Pets easy gold: SELECT count(DISTINCT pettype) FROM pets --- Match OK easy pred: SELECT Count(DISTINCT Pets.PetType) FROM Pets easy gold: SELECT count(DISTINCT pettype) FROM pets --- Match OK extra pred: SELECT Student.Fname FROM Student JOIN Has_Pet JOIN Pets WHERE Pets.PetType = 'terminal' OR Pets.PetType = 'terminal' extra gold: SELECT DISTINCT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat' OR T3.pettype = 'dog' --- Match OK extra pred: SELECT Student.Fname FROM Has_Pet JOIN Pets JOIN Student WHERE Pets.PetType = 'terminal' OR Pets.PetType = 'terminal' extra gold: SELECT DISTINCT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat' OR T3.pettype = 'dog' --- Match OK extra pred: SELECT Student.Fname FROM Has_Pet JOIN Pets JOIN Student WHERE Pets.PetType = 'terminal' INTERSECT SELECT Student.Fname FROM Has_Pet JOIN Pets JOIN Student WHERE Pets.PetType = 'terminal' extra gold: select t1.fname from student as t1 join has_pet as t2 on t1.stuid = t2.stuid join pets as t3 on t3.petid = t2.petid where t3.pettype = 'cat' intersect select t1.fname from student as t1 join has_pet as t2 on t1.stuid = t2.stuid join pets as t3 on t3.petid = t2.petid where t3.pettype = 'dog' --- Match OK extra pred: SELECT Student.Fname FROM Has_Pet JOIN Pets JOIN Student WHERE Pets.PetType = 'terminal' INTERSECT SELECT Student.Fname FROM Has_Pet JOIN Pets JOIN Student WHERE Pets.PetType = 'terminal' extra gold: SELECT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat' INTERSECT SELECT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog' --- Match Fail extra pred: SELECT Student.Major, Student.Age FROM Student WHERE Student.StuID NOT IN (SELECT Has_Pet.StuID FROM Has_Pet WHERE Pets.PetType != 'terminal') extra gold: SELECT major , age FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat') --- Match Fail extra pred: SELECT Student.Major, Student.Age FROM Student WHERE Student.StuID NOT IN (SELECT Has_Pet.StuID FROM Has_Pet JOIN Pets WHERE Pets.PetType = 'terminal') extra gold: SELECT major , age FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat') --- Match Fail hard pred: SELECT Student.StuID FROM Student EXCEPT SELECT Has_Pet.StuID FROM Has_Pet hard gold: SELECT stuid FROM student EXCEPT SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat' --- Match Fail hard pred: SELECT Student.StuID FROM Student EXCEPT SELECT Has_Pet.StuID FROM Student WHERE Pets.PetType = 'terminal' EXCEPT SELECT Has_Pet.StuID FROM Has_Pet JOIN Pets WHERE Pets.PetType = 'terminal' hard gold: SELECT stuid FROM student EXCEPT SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat' --- Match Fail extra pred: SELECT Student.Fname, Student.Age FROM Student WHERE Student.StuID NOT IN (SELECT Has_Pet.StuID FROM Has_Pet WHERE Pets.PetType = 'terminal') extra gold: SELECT T1.fname , T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog' AND T1.stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat') --- Match Fail extra pred: SELECT Student.Fname FROM Student WHERE Student.Advisor = 'terminal' EXCEPT SELECT Student.Fname FROM Student JOIN Has_Pet WHERE Student.Advisor = 'terminal' extra gold: SELECT T1.fname , T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'dog' AND T1.stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pettype = 'cat') --- Match Fail medium pred: SELECT Pets.PetType, Pets.weight FROM Has_Pet JOIN Pets JOIN Student WHERE Student.Age = (SELECT Min(Student.Age) FROM Student) medium gold: SELECT pettype , weight FROM pets ORDER BY pet_age LIMIT 1 --- Match Fail medium pred: SELECT Pets.PetType, Pets.weight FROM Pets ORDER BY Pets.weight Asc LIMIT 1 medium gold: SELECT pettype , weight FROM pets ORDER BY pet_age LIMIT 1 --- Match Fail medium pred: SELECT Pets.PetID, Pets.weight FROM Has_Pet JOIN Pets WHERE Pets.pet_age > 'terminal' medium gold: SELECT petid , weight FROM pets WHERE pet_age > 1 --- Match OK medium pred: SELECT Pets.PetID, Pets.weight FROM Pets WHERE Pets.pet_age > 'terminal' medium gold: SELECT petid , weight FROM pets WHERE pet_age > 1 --- Match Fail medium pred: SELECT Avg(Student.Age), Avg(Student.Age), Pets.PetType FROM Has_Pet JOIN Student JOIN Pets GROUP BY Pets.PetType medium gold: SELECT avg(pet_age) , max(pet_age) , pettype FROM pets GROUP BY pettype --- Match Fail medium pred: SELECT Avg(Student.Age), Avg(Student.Age), Pets.PetType FROM Has_Pet JOIN Student JOIN Pets GROUP BY Pets.PetType medium gold: SELECT avg(pet_age) , max(pet_age) , pettype FROM pets GROUP BY pettype --- Match OK medium pred: SELECT Pets.PetType, Avg(Pets.weight) FROM Pets GROUP BY Pets.PetType medium gold: SELECT avg(weight) , pettype FROM pets GROUP BY pettype --- Match OK medium pred: SELECT Pets.PetType, Avg(Pets.weight) FROM Pets GROUP BY Pets.PetType medium gold: SELECT avg(weight) , pettype FROM pets GROUP BY pettype --- Match Fail medium pred: SELECT Student.Fname, Student.Age FROM Has_Pet JOIN Pets JOIN Student WHERE Pets.PetType = 'terminal' medium gold: SELECT DISTINCT T1.fname , T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid --- Match OK medium pred: SELECT DISTINCT Student.Fname, Student.Age FROM Has_Pet JOIN Student medium gold: SELECT DISTINCT T1.fname , T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid --- Match OK medium pred: SELECT Has_Pet.PetID FROM Has_Pet JOIN Student WHERE Student.LName = 'terminal' medium gold: SELECT T2.petid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.Lname = 'Smith' --- Match Fail medium pred: SELECT Student.StuID FROM Has_Pet JOIN Student WHERE Student.LName = 'terminal' medium gold: SELECT T2.petid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid WHERE T1.Lname = 'Smith' --- Match Fail medium pred: SELECT Has_Pet.StuID, Count(*) FROM Has_Pet GROUP BY Has_Pet.StuID medium gold: SELECT count(*) , T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid GROUP BY T1.stuid --- Match Fail medium pred: SELECT Count(DISTINCT Has_Pet.StuID) FROM Has_Pet medium gold: select count(*) , t1.stuid from student as t1 join has_pet as t2 on t1.stuid = t2.stuid group by t1.stuid --- Match OK medium pred: SELECT Student.Fname, Student.Sex FROM Has_Pet JOIN Student GROUP BY Has_Pet.StuID HAVING Count(*) > 'terminal' medium gold: SELECT T1.fname , T1.sex FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid GROUP BY T1.stuid HAVING count(*) > 1 --- Match OK medium pred: SELECT Student.Fname, Student.Sex FROM Student JOIN Has_Pet GROUP BY Has_Pet.StuID HAVING Count(*) > 'terminal' medium gold: SELECT T1.fname , T1.sex FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid GROUP BY T1.stuid HAVING count(*) > 1 --- Match Fail hard pred: SELECT Student.LName FROM Student WHERE Student.Age = 'terminal' hard gold: SELECT T1.lname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pet_age = 3 AND T3.pettype = 'cat' --- Match Fail hard pred: SELECT Student.LName FROM Student WHERE Student.Age = 'terminal' hard gold: SELECT T1.lname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid = T2.stuid JOIN pets AS T3 ON T3.petid = T2.petid WHERE T3.pet_age = 3 AND T3.pettype = 'cat' --- Match Fail extra pred: SELECT Avg(Student.Age) FROM Student WHERE Student.StuID NOT IN (SELECT Has_Pet.StuID FROM Has_Pet JOIN Pets WHERE Pets.PetType = 'terminal') extra gold: select avg(age) from student where stuid not in (select stuid from has_pet) --- Match Fail extra pred: SELECT Avg(Student.Age) FROM Student WHERE Student.StuID NOT IN (SELECT Has_Pet.StuID FROM Has_Pet JOIN Pets WHERE Pets.PetType != 'terminal') extra gold: select avg(age) from student where stuid not in (select stuid from has_pet) --- Match Fail easy pred: SELECT Count(*) FROM car_names easy gold: SELECT count(*) FROM CONTINENTS; --- Match Fail easy pred: SELECT Count(*) FROM car_makers easy gold: SELECT count(*) FROM CONTINENTS; --- Match Fail medium pred: SELECT countries.CountryId, countries.CountryName, Count(*) FROM countries JOIN car_makers GROUP BY countries.CountryId medium gold: SELECT T1.ContId , T1.Continent , count(*) FROM CONTINENTS AS T1 JOIN COUNTRIES AS T2 ON T1.ContId = T2.Continent GROUP BY T1.ContId; --- Match Fail medium pred: SELECT car_makers.Id, countries.CountryName, Count(*) FROM countries JOIN car_makers GROUP BY car_makers.Id medium gold: SELECT T1.ContId , T1.Continent , count(*) FROM CONTINENTS AS T1 JOIN COUNTRIES AS T2 ON T1.ContId = T2.Continent GROUP BY T1.ContId; --- Match OK easy pred: SELECT Count(*) FROM countries easy gold: SELECT count(*) FROM COUNTRIES; --- Match OK easy pred: SELECT Count(*) FROM countries easy gold: SELECT count(*) FROM COUNTRIES; --- Match OK medium pred: SELECT car_makers.FullName, car_makers.Id, Count(*) FROM model_list JOIN car_makers GROUP BY car_makers.Id medium gold: SELECT T1.FullName , T1.Id , count(*) FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker GROUP BY T1.Id; --- Match Fail medium pred: SELECT model_list.ModelId, model_list.ModelId, Count(*) FROM model_list JOIN car_names GROUP BY model_list.ModelId medium gold: SELECT T1.FullName , T1.Id , count(*) FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker GROUP BY T1.Id; --- Match Fail hard pred: SELECT model_list.Model FROM model_list JOIN car_names GROUP BY car_names.Model ORDER BY Count(*) Asc LIMIT 1 hard gold: SELECT T1.Model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id ORDER BY T2.horsepower ASC LIMIT 1; --- Match Fail hard pred: SELECT car_names.Make FROM model_list JOIN car_names GROUP BY car_names.Make ORDER BY Count(*) Asc LIMIT 1 hard gold: SELECT T1.Model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id ORDER BY T2.horsepower ASC LIMIT 1; --- Match OK extra pred: SELECT model_list.Model FROM cars_data JOIN car_names WHERE cars_data.Weight < (SELECT Avg(cars_data.Weight) FROM cars_data) extra gold: SELECT T1.model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id WHERE T2.Weight < (SELECT avg(Weight) FROM CARS_DATA) --- Match Fail extra pred: SELECT model_list.Model FROM model_list JOIN cars_data WHERE cars_data.Weight < (SELECT Avg(cars_data.Weight) FROM cars_data) extra gold: SELECT T1.model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id WHERE T2.Weight < (SELECT avg(Weight) FROM CARS_DATA) --- Match Fail extra pred: SELECT car_makers.FullName FROM car_makers JOIN model_list JOIN cars_data WHERE cars_data.Year = 'terminal' extra gold: SELECT DISTINCT T1.Maker FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker JOIN CAR_NAMES AS T3 ON T2.model = T3.model JOIN CARS_DATA AS T4 ON T3.MakeId = T4.id WHERE T4.year = '1970'; --- Match Fail extra pred: SELECT DISTINCT car_makers.FullName FROM model_list JOIN car_makers JOIN cars_data WHERE cars_data.Year = 'terminal' extra gold: SELECT DISTINCT T1.Maker FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker JOIN CAR_NAMES AS T3 ON T2.model = T3.model JOIN CARS_DATA AS T4 ON T3.MakeId = T4.id WHERE T4.year = '1970'; --- Match Fail extra pred: SELECT car_names.Make, cars_data.Year FROM cars_data JOIN car_names ORDER BY cars_data.Year Asc LIMIT 1 extra gold: SELECT T2.Make , T1.Year FROM CARS_DATA AS T1 JOIN CAR_NAMES AS T2 ON T1.Id = T2.MakeId WHERE T1.Year = (SELECT min(YEAR) FROM CARS_DATA); --- Match Fail extra pred: SELECT car_names.Make, cars_data.Year FROM cars_data JOIN car_names GROUP BY cars_data.Year ORDER BY Count(cars_data.Year) Asc LIMIT 1 extra gold: SELECT T2.Make , T1.Year FROM CARS_DATA AS T1 JOIN CAR_NAMES AS T2 ON T1.Id = T2.MakeId WHERE T1.Year = (SELECT min(YEAR) FROM CARS_DATA); --- Match OK hard pred: SELECT DISTINCT model_list.Model FROM model_list JOIN car_names JOIN cars_data WHERE cars_data.Year > 'terminal' hard gold: SELECT DISTINCT T1.model FROM MODEL_LIST AS T1 JOIN CAR_NAMES AS T2 ON T1.model = T2.model JOIN CARS_DATA AS T3 ON T2.MakeId = T3.id WHERE T3.year > 1980; --- Match Fail hard pred: SELECT DISTINCT car_names.Model FROM car_names JOIN cars_data WHERE cars_data.Year > 'terminal' hard gold: SELECT DISTINCT T1.model FROM MODEL_LIST AS T1 JOIN CAR_NAMES AS T2 ON T1.model = T2.model JOIN CARS_DATA AS T3 ON T2.MakeId = T3.id WHERE T3.year > 1980; --- Match Fail hard pred: SELECT car_makers.Country, Count(*) FROM model_list JOIN car_makers GROUP BY car_makers.Country hard gold: SELECT T1.Continent , count(*) FROM CONTINENTS AS T1 JOIN COUNTRIES AS T2 ON T1.ContId = T2.continent JOIN car_makers AS T3 ON T2.CountryId = T3.Country GROUP BY T1.Continent; --- Match Fail hard pred: SELECT countries.CountryName, Count(*) FROM countries JOIN car_makers GROUP BY car_makers.Country hard gold: SELECT T1.Continent , count(*) FROM CONTINENTS AS T1 JOIN COUNTRIES AS T2 ON T1.ContId = T2.continent JOIN car_makers AS T3 ON T2.CountryId = T3.Country GROUP BY T1.Continent; --- Match Fail extra pred: SELECT countries.CountryName FROM countries JOIN car_makers GROUP BY countries.CountryName ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T2.CountryName FROM CAR_MAKERS AS T1 JOIN COUNTRIES AS T2 ON T1.Country = T2.CountryId GROUP BY T1.Country ORDER BY Count(*) DESC LIMIT 1; --- Match OK extra pred: SELECT countries.CountryName FROM countries JOIN car_makers GROUP BY car_makers.Country ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T2.CountryName FROM CAR_MAKERS AS T1 JOIN COUNTRIES AS T2 ON T1.Country = T2.CountryId GROUP BY T1.Country ORDER BY Count(*) DESC LIMIT 1; --- Match Fail medium pred: SELECT car_names.Make, Count(*) FROM model_list JOIN car_names GROUP BY model_list.Model medium gold: select count(*) , t2.fullname from model_list as t1 join car_makers as t2 on t1.maker = t2.id group by t2.id; --- Match Fail medium pred: SELECT car_makers.Id, car_makers.FullName, Count(*) FROM car_makers JOIN cars_data GROUP BY cars_data.MPG medium gold: SELECT Count(*) , T2.FullName , T2.id FROM MODEL_LIST AS T1 JOIN CAR_MAKERS AS T2 ON T1.Maker = T2.Id GROUP BY T2.id; --- Match Fail medium pred: SELECT cars_data.Cylinders FROM cars_data JOIN car_names WHERE car_names.Make = 'terminal' medium gold: SELECT T1.Accelerate FROM CARS_DATA AS T1 JOIN CAR_NAMES AS T2 ON T1.Id = T2.MakeId WHERE T2.Make = 'amc hornet sportabout (sw)'; --- Match Fail medium pred: SELECT Count(*) FROM car_names WHERE car_names.Make = 'terminal' medium gold: SELECT T1.Accelerate FROM CARS_DATA AS T1 JOIN CAR_NAMES AS T2 ON T1.Id = T2.MakeId WHERE T2.Make = 'amc hornet sportabout (sw)'; --- Match Fail medium pred: SELECT Count(*) FROM model_list JOIN car_makers WHERE car_makers.Country = 'terminal' medium gold: SELECT count(*) FROM CAR_MAKERS AS T1 JOIN COUNTRIES AS T2 ON T1.Country = T2.CountryId WHERE T2.CountryName = 'france'; --- Match Fail medium pred: SELECT Count(*) FROM car_makers WHERE car_makers.Country = 'terminal' medium gold: SELECT count(*) FROM CAR_MAKERS AS T1 JOIN COUNTRIES AS T2 ON T1.Country = T2.CountryId WHERE T2.CountryName = 'france'; --- Match Fail hard pred: SELECT Count(*) FROM model_list JOIN car_makers WHERE car_makers.Country = 'terminal' hard gold: SELECT count(*) FROM MODEL_LIST AS T1 JOIN CAR_MAKERS AS T2 ON T1.Maker = T2.Id JOIN COUNTRIES AS T3 ON T2.Country = T3.CountryId WHERE T3.CountryName = 'usa'; --- Match Fail hard pred: SELECT Count(*) FROM car_makers WHERE car_makers.Country = 'terminal' hard gold: SELECT count(*) FROM MODEL_LIST AS T1 JOIN CAR_MAKERS AS T2 ON T1.Maker = T2.Id JOIN COUNTRIES AS T3 ON T2.Country = T3.CountryId WHERE T3.CountryName = 'usa'; --- Match Fail easy pred: SELECT Avg(cars_data.Weight) FROM cars_data JOIN car_names WHERE car_names.Make = 'terminal' easy gold: SELECT avg(mpg) FROM CARS_DATA WHERE Cylinders = 4; --- Match Fail easy pred: SELECT Avg(cars_data.Cylinders) FROM cars_data WHERE cars_data.Weight = 'terminal' easy gold: SELECT avg(mpg) FROM CARS_DATA WHERE Cylinders = 4; --- Match Fail medium pred: SELECT cars_data.Weight FROM cars_data WHERE cars_data.Year = 'terminal' ORDER BY cars_data.Weight Asc LIMIT 1 medium gold: select min(weight) from cars_data where cylinders = 8 and year = 1974 --- Match Fail medium pred: SELECT Min(cars_data.Weight) FROM cars_data WHERE cars_data.Year = 'terminal' medium gold: select min(weight) from cars_data where cylinders = 8 and year = 1974 --- Match Fail medium pred: SELECT model_list.ModelId, model_list.Model FROM model_list medium gold: SELECT Maker , Model FROM MODEL_LIST; --- Match Fail medium pred: SELECT model_list.ModelId, model_list.Model FROM model_list medium gold: SELECT Maker , Model FROM MODEL_LIST; --- Match OK medium pred: SELECT countries.CountryName, car_makers.Country FROM countries JOIN car_makers GROUP BY car_makers.Country HAVING Count(*) >= 'terminal' medium gold: SELECT T1.CountryName , T1.CountryId FROM COUNTRIES AS T1 JOIN CAR_MAKERS AS T2 ON T1.CountryId = T2.Country GROUP BY T1.CountryId HAVING count(*) >= 1; --- Match OK medium pred: SELECT countries.CountryName, car_makers.Country FROM countries JOIN car_makers GROUP BY car_makers.Country HAVING Count(*) >= 'terminal' medium gold: SELECT T1.CountryName , T1.CountryId FROM COUNTRIES AS T1 JOIN CAR_MAKERS AS T2 ON T1.CountryId = T2.Country GROUP BY T1.CountryId HAVING count(*) >= 1; --- Match Fail easy pred: SELECT Count(*) FROM cars_data WHERE cars_data.Cylinders > 'terminal' easy gold: SELECT count(*) FROM CARS_DATA WHERE horsepower > 150; --- Match Fail easy pred: SELECT Count(*) FROM cars_data WHERE cars_data.Cylinders > 'terminal' easy gold: SELECT count(*) FROM CARS_DATA WHERE horsepower > 150; --- Match OK medium pred: SELECT cars_data.Year, Avg(cars_data.Weight) FROM cars_data GROUP BY cars_data.Year medium gold: SELECT avg(Weight) , YEAR FROM CARS_DATA GROUP BY YEAR; --- Match OK medium pred: SELECT Avg(cars_data.Weight), cars_data.Year FROM cars_data GROUP BY cars_data.Year medium gold: SELECT avg(Weight) , YEAR FROM CARS_DATA GROUP BY YEAR; --- Match Fail extra pred: SELECT car_makers.Country FROM car_makers GROUP BY car_makers.Country HAVING Count(*) >= 'terminal' extra gold: SELECT T1.CountryName FROM COUNTRIES AS T1 JOIN CONTINENTS AS T2 ON T1.Continent = T2.ContId JOIN CAR_MAKERS AS T3 ON T1.CountryId = T3.Country WHERE T2.Continent = 'europe' GROUP BY T1.CountryName HAVING count(*) >= 3; --- Match Fail extra pred: SELECT countries.CountryName FROM countries JOIN car_makers GROUP BY car_makers.Country HAVING Count(*) >= 'terminal' extra gold: SELECT T1.CountryName FROM COUNTRIES AS T1 JOIN CONTINENTS AS T2 ON T1.Continent = T2.ContId JOIN CAR_MAKERS AS T3 ON T1.CountryId = T3.Country WHERE T2.Continent = 'europe' GROUP BY T1.CountryName HAVING count(*) >= 3; --- Match Fail extra pred: SELECT Max(cars_data.Weight), Avg(cars_data.Weight) FROM cars_data WHERE cars_data.Cylinders = 'terminal' extra gold: SELECT T2.horsepower , T1.Make FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id WHERE T2.cylinders = 3 ORDER BY T2.horsepower DESC LIMIT 1; --- Match Fail extra pred: SELECT cars_data.MPG, cars_data.Weight FROM cars_data WHERE cars_data.Edispl = 'terminal' extra gold: SELECT T2.horsepower , T1.Make FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id WHERE T2.cylinders = 3 ORDER BY T2.horsepower DESC LIMIT 1; --- Match Fail hard pred: SELECT car_names.Model FROM cars_data JOIN car_names GROUP BY car_names.Model ORDER BY Sum(cars_data.Cylinders) Desc LIMIT 1 hard gold: SELECT T1.Model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id ORDER BY T2.mpg DESC LIMIT 1; --- Match OK hard pred: SELECT car_names.Model FROM cars_data JOIN car_names ORDER BY cars_data.MPG Desc LIMIT 1 hard gold: select t1.model from car_names as t1 join cars_data as t2 on t1.makeid = t2.id order by t2.mpg desc limit 1; --- Match Fail easy pred: SELECT Avg(cars_data.Weight) FROM cars_data WHERE cars_data.Year < 'terminal' easy gold: SELECT avg(horsepower) FROM CARS_DATA WHERE YEAR < 1980; --- Match Fail easy pred: SELECT Avg(cars_data.Weight) FROM cars_data WHERE cars_data.Year < 'terminal' easy gold: select avg(horsepower) from cars_data where year < 1980; --- Match OK medium pred: SELECT Avg(cars_data.Edispl) FROM car_names JOIN cars_data WHERE car_names.Model = 'terminal' medium gold: SELECT avg(T2.edispl) FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id WHERE T1.Model = 'volvo'; --- Match Fail medium pred: SELECT Avg(cars_data.Edispl) FROM cars_data medium gold: SELECT avg(T2.edispl) FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id WHERE T1.Model = 'volvo'; --- Match Fail medium pred: SELECT Max(cars_data.Cylinders), cars_data.Weight FROM cars_data GROUP BY cars_data.Weight medium gold: SELECT max(Accelerate) , Cylinders FROM CARS_DATA GROUP BY Cylinders; --- Match Fail medium pred: SELECT Max(cars_data.Cylinders), car_names.Make FROM cars_data JOIN car_names GROUP BY car_names.Make medium gold: SELECT max(Accelerate) , Cylinders FROM CARS_DATA GROUP BY Cylinders; --- Match Fail hard pred: SELECT model_list.Model FROM car_names JOIN model_list GROUP BY car_names.Model ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT Model FROM CAR_NAMES GROUP BY Model ORDER BY count(*) DESC LIMIT 1; --- Match Fail hard pred: SELECT model_list.Model FROM model_list hard gold: SELECT Model FROM CAR_NAMES GROUP BY Model ORDER BY count(*) DESC LIMIT 1; --- Match Fail easy pred: SELECT Count(*) FROM car_names JOIN cars_data WHERE cars_data.Weight > 'terminal' easy gold: SELECT count(*) FROM CARS_DATA WHERE Cylinders > 4; --- Match Fail easy pred: SELECT Count(*) FROM cars_data WHERE cars_data.Weight > 'terminal' easy gold: SELECT count(*) FROM CARS_DATA WHERE Cylinders > 4; --- Match OK easy pred: SELECT Count(*) FROM cars_data WHERE cars_data.Year = 'terminal' easy gold: SELECT count(*) FROM CARS_DATA WHERE YEAR = 1980; --- Match OK easy pred: SELECT Count(*) FROM cars_data WHERE cars_data.Year = 'terminal' easy gold: SELECT count(*) FROM CARS_DATA WHERE YEAR = 1980; --- Match OK medium pred: SELECT Count(*) FROM car_makers JOIN model_list WHERE car_makers.FullName = 'terminal' medium gold: SELECT count(*) FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker WHERE T1.FullName = 'American Motor Company'; --- Match OK medium pred: SELECT Count(*) FROM model_list JOIN car_makers WHERE car_makers.FullName = 'terminal' medium gold: SELECT count(*) FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker WHERE T1.FullName = 'American Motor Company'; --- Match OK medium pred: SELECT car_makers.FullName, car_makers.Id FROM car_makers JOIN model_list GROUP BY car_makers.Id HAVING Count(*) > 'terminal' medium gold: SELECT T1.FullName , T1.Id FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker GROUP BY T1.Id HAVING count(*) > 3; --- Match Fail medium pred: SELECT cars_data.MPG, cars_data.Id FROM cars_data GROUP BY cars_data.Edispl HAVING Count(*) > 'terminal' medium gold: SELECT T1.FullName , T1.Id FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker GROUP BY T1.Id HAVING count(*) > 3; --- Match Fail extra pred: SELECT DISTINCT model_list.Model FROM car_makers JOIN model_list JOIN cars_data WHERE car_makers.FullName = 'terminal' OR cars_data.Weight > 'terminal' extra gold: SELECT DISTINCT T2.Model FROM CAR_NAMES AS T1 JOIN MODEL_LIST AS T2 ON T1.Model = T2.Model JOIN CAR_MAKERS AS T3 ON T2.Maker = T3.Id JOIN CARS_DATA AS T4 ON T1.MakeId = T4.Id WHERE T3.FullName = 'General Motors' OR T4.weight > 3500; --- Match Fail extra pred: SELECT DISTINCT cars_data.Year FROM car_makers JOIN car_names JOIN cars_data WHERE car_makers.FullName = 'terminal' OR cars_data.Weight > 'terminal' extra gold: SELECT DISTINCT T2.Model FROM CAR_NAMES AS T1 JOIN MODEL_LIST AS T2 ON T1.Model = T2.Model JOIN CAR_MAKERS AS T3 ON T2.Maker = T3.Id JOIN CARS_DATA AS T4 ON T1.MakeId = T4.Id WHERE T3.FullName = 'General Motors' OR T4.weight > 3500; --- Match Fail easy pred: SELECT cars_data.Year FROM cars_data WHERE cars_data.Weight < 'terminal' EXCEPT SELECT cars_data.Year FROM cars_data WHERE cars_data.Weight < 'terminal' easy gold: select distinct year from cars_data where weight between 3000 and 4000; --- Match Fail easy pred: SELECT DISTINCT cars_data.Year FROM cars_data WHERE cars_data.Weight < 'terminal' INTERSECT SELECT cars_data.Year FROM cars_data WHERE cars_data.Weight < 'terminal' easy gold: select distinct year from cars_data where weight between 3000 and 4000; --- Match Fail medium pred: SELECT cars_data.Weight FROM cars_data ORDER BY cars_data.Cylinders Desc LIMIT 1 medium gold: SELECT T1.horsepower FROM CARS_DATA AS T1 ORDER BY T1.accelerate DESC LIMIT 1; --- Match Fail medium pred: SELECT cars_data.Weight FROM cars_data ORDER BY cars_data.Cylinders Desc LIMIT 1 medium gold: SELECT T1.horsepower FROM CARS_DATA AS T1 ORDER BY T1.accelerate DESC LIMIT 1; --- Match Fail extra pred: SELECT cars_data.Weight FROM model_list JOIN car_names JOIN cars_data WHERE model_list.Model = 'terminal' GROUP BY car_names.Model ORDER BY Count(*) Asc LIMIT 1 extra gold: SELECT T1.cylinders FROM CARS_DATA AS T1 JOIN CAR_NAMES AS T2 ON T1.Id = T2.MakeId WHERE T2.Model = 'volvo' ORDER BY T1.accelerate ASC LIMIT 1; --- Match Fail extra pred: SELECT cars_data.Weight FROM car_makers JOIN model_list JOIN cars_data WHERE model_list.Model = 'terminal' ORDER BY cars_data.Cylinders Asc LIMIT 1 extra gold: SELECT T1.cylinders FROM CARS_DATA AS T1 JOIN CAR_NAMES AS T2 ON T1.Id = T2.MakeId WHERE T2.Model = 'volvo' ORDER BY T1.accelerate ASC LIMIT 1; --- Match Fail hard pred: SELECT Count(*) FROM car_names JOIN cars_data WHERE cars_data.Cylinders > car_names.Make hard gold: SELECT COUNT(*) FROM CARS_DATA WHERE Accelerate > ( SELECT Accelerate FROM CARS_DATA ORDER BY Horsepower DESC LIMIT 1 ); --- Match Fail hard pred: SELECT Count(*) FROM cars_data JOIN car_names WHERE cars_data.Cylinders < cars_data.Id hard gold: SELECT COUNT(*) FROM CARS_DATA WHERE Accelerate > ( SELECT Accelerate FROM CARS_DATA ORDER BY Horsepower DESC LIMIT 1 ); --- Match Fail medium pred: SELECT Count(*) FROM car_makers medium gold: select count(*) from countries as t1 join car_makers as t2 on t1.countryid = t2.country group by t1.countryid having count(*) > 2 --- Match Fail medium pred: SELECT Count(*) FROM car_makers medium gold: select count(*) from countries as t1 join car_makers as t2 on t1.countryid = t2.country group by t1.countryid having count(*) > 2 --- Match Fail easy pred: SELECT Count(*) FROM car_names JOIN cars_data WHERE cars_data.Weight > 'terminal' easy gold: SELECT COUNT(*) FROM CARS_DATA WHERE Cylinders > 6; --- Match Fail easy pred: SELECT Count(*) FROM cars_data WHERE cars_data.Weight > 'terminal' easy gold: SELECT COUNT(*) FROM CARS_DATA WHERE Cylinders > 6; --- Match Fail extra pred: SELECT car_names.Make FROM car_names JOIN cars_data WHERE cars_data.Weight = 'terminal' ORDER BY cars_data.Horsepower Desc LIMIT 1 extra gold: SELECT T1.Model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id WHERE T2.Cylinders = 4 ORDER BY T2.horsepower DESC LIMIT 1; --- Match Fail extra pred: SELECT car_names.Make FROM car_names JOIN cars_data WHERE cars_data.Weight = 'terminal' ORDER BY cars_data.Horsepower Desc LIMIT 1 extra gold: SELECT T1.Model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId = T2.Id WHERE T2.Cylinders = 4 ORDER BY T2.horsepower DESC LIMIT 1; --- Match Fail extra pred: SELECT car_names.Make, car_names.MakeId FROM car_names JOIN cars_data WHERE cars_data.Weight < 'terminal' EXCEPT SELECT car_names.Make FROM car_names JOIN cars_data WHERE cars_data.Weight < 'terminal' extra gold: SELECT T2.MakeId , T2.Make FROM CARS_DATA AS T1 JOIN CAR_NAMES AS T2 ON T1.Id = T2.MakeId WHERE T1.Horsepower > (SELECT min(Horsepower) FROM CARS_DATA) AND T1.Cylinders <= 3; --- Match Fail extra pred: SELECT cars_data.Id, cars_data.MPG FROM cars_data WHERE cars_data.Weight < 'terminal' extra gold: select t2.makeid , t2.make from cars_data as t1 join car_names as t2 on t1.id = t2.makeid where t1.horsepower > (select min(horsepower) from cars_data) and t1.cylinders < 4; --- Match Fail medium pred: SELECT Max(cars_data.Cylinders) FROM cars_data WHERE cars_data.Year = 'terminal' OR cars_data.Year < 'terminal' medium gold: select max(mpg) from cars_data where cylinders = 8 or year < 1980 --- Match Fail medium pred: SELECT Max(cars_data.MPG) FROM cars_data WHERE cars_data.Weight = 'terminal' OR cars_data.Year < 'terminal' medium gold: select max(mpg) from cars_data where cylinders = 8 or year < 1980 --- Match Fail extra pred: SELECT cars_data.Weight FROM cars_data WHERE cars_data.Weight > 'terminal' EXCEPT SELECT model_list.Model FROM model_list JOIN car_names JOIN car_makers WHERE car_makers.FullName = 'terminal' extra gold: SELECT DISTINCT T1.model FROM MODEL_LIST AS T1 JOIN CAR_NAMES AS T2 ON T1.Model = T2.Model JOIN CARS_DATA AS T3 ON T2.MakeId = T3.Id JOIN CAR_MAKERS AS T4 ON T1.Maker = T4.Id WHERE T3.weight < 3500 AND T4.FullName != 'Ford Motor Company'; --- Match Fail extra pred: SELECT DISTINCT model_list.Model FROM cars_data WHERE cars_data.Weight > 'terminal' EXCEPT SELECT model_list.Model FROM model_list JOIN car_makers WHERE car_makers.FullName = 'terminal' extra gold: SELECT DISTINCT T1.model FROM MODEL_LIST AS T1 JOIN CAR_NAMES AS T2 ON T1.Model = T2.Model JOIN CARS_DATA AS T3 ON T2.MakeId = T3.Id JOIN CAR_MAKERS AS T4 ON T1.Maker = T4.Id WHERE T3.weight < 3500 AND T4.FullName != 'Ford Motor Company'; --- Match OK hard pred: SELECT countries.CountryName FROM countries EXCEPT SELECT countries.CountryName FROM countries JOIN car_makers hard gold: SELECT CountryName FROM countries EXCEPT SELECT T1.CountryName FROM countries AS T1 JOIN CAR_MAKERS AS T2 ON T1.countryId = T2.Country; --- Match OK hard pred: SELECT countries.CountryName FROM countries EXCEPT SELECT countries.CountryName FROM countries JOIN car_makers hard gold: SELECT CountryName FROM countries EXCEPT SELECT T1.CountryName FROM countries AS T1 JOIN CAR_MAKERS AS T2 ON T1.countryId = T2.Country; --- Match Fail extra pred: SELECT model_list.ModelId, model_list.Model FROM model_list JOIN car_names GROUP BY car_names.Model HAVING Count(*) >= 'terminal' extra gold: select t1.id , t1.maker from car_makers as t1 join model_list as t2 on t1.id = t2.maker group by t1.id having count(*) >= 2 intersect select t1.id , t1.maker from car_makers as t1 join model_list as t2 on t1.id = t2.maker join car_names as t3 on t2.model = t3.model group by t1.id having count(*) > 3; --- Match Fail extra pred: SELECT cars_data.Id, cars_data.MPG FROM cars_data GROUP BY cars_data.Id HAVING Count(*) >= 'terminal' INTERSECT SELECT cars_data.Id, cars_data.MPG FROM cars_data GROUP BY cars_data.Id HAVING Count(*) >= 'terminal' extra gold: SELECT T1.Id , T1.Maker FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker GROUP BY T1.Id HAVING count(*) >= 2 INTERSECT SELECT T1.Id , T1.Maker FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id = T2.Maker JOIN CAR_NAMES AS T3 ON T2.model = T3.model GROUP BY T1.Id HAVING count(*) > 3; --- Match Fail extra pred: SELECT car_makers.Country, countries.CountryName FROM countries JOIN car_makers WHERE car_makers.FullName = 'terminal' GROUP BY car_makers.Country HAVING Count(*) > 'terminal' extra gold: SELECT T1.countryId , T1.CountryName FROM Countries AS T1 JOIN CAR_MAKERS AS T2 ON T1.CountryId = T2.Country GROUP BY T1.countryId HAVING count(*) > 3 UNION SELECT T1.countryId , T1.CountryName FROM Countries AS T1 JOIN CAR_MAKERS AS T2 ON T1.CountryId = T2.Country JOIN MODEL_LIST AS T3 ON T2.Id = T3.Maker WHERE T3.Model = 'fiat'; --- Match Fail extra pred: SELECT car_makers.Country, countries.CountryName FROM countries JOIN car_makers WHERE car_makers.FullName = 'terminal' GROUP BY car_makers.Country HAVING Count(*) > 'terminal' extra gold: select t1.countryid , t1.countryname from countries as t1 join car_makers as t2 on t1.countryid = t2.country group by t1.countryid having count(*) > 3 union select t1.countryid , t1.countryname from countries as t1 join car_makers as t2 on t1.countryid = t2.country join model_list as t3 on t2.id = t3.maker where t3.model = 'fiat'; --- Match OK easy pred: SELECT airlines.Country FROM airlines WHERE airlines.Airline = 'terminal' easy gold: SELECT Country FROM AIRLINES WHERE Airline = "JetBlue Airways" --- Match OK easy pred: SELECT airlines.Country FROM airlines WHERE airlines.Airline = 'terminal' easy gold: SELECT Country FROM AIRLINES WHERE Airline = "JetBlue Airways" --- Match Fail easy pred: SELECT airlines.uid FROM airlines WHERE airlines.Airline = 'terminal' easy gold: SELECT Abbreviation FROM AIRLINES WHERE Airline = "JetBlue Airways" --- Match Fail easy pred: SELECT * FROM airlines WHERE airlines.Airline = 'terminal' easy gold: SELECT Abbreviation FROM AIRLINES WHERE Airline = "JetBlue Airways" --- Match OK medium pred: SELECT airlines.Airline, airlines.Abbreviation FROM airlines WHERE airlines.Country = 'terminal' medium gold: SELECT Airline , Abbreviation FROM AIRLINES WHERE Country = "USA" --- Match OK medium pred: SELECT airlines.Airline, airlines.Abbreviation FROM airlines WHERE airlines.Country = 'terminal' medium gold: SELECT Airline , Abbreviation FROM AIRLINES WHERE Country = "USA" --- Match OK medium pred: SELECT airports.AirportCode, airports.AirportName FROM airports WHERE airports.City = 'terminal' medium gold: SELECT AirportCode , AirportName FROM AIRPORTS WHERE city = "Anthony" --- Match OK medium pred: SELECT airports.AirportCode, airports.AirportName FROM airports WHERE airports.City = 'terminal' medium gold: SELECT AirportCode , AirportName FROM AIRPORTS WHERE city = "Anthony" --- Match OK easy pred: SELECT Count(*) FROM airlines easy gold: SELECT count(*) FROM AIRLINES --- Match OK easy pred: SELECT Count(*) FROM airlines easy gold: SELECT count(*) FROM AIRLINES --- Match OK easy pred: SELECT Count(*) FROM airports easy gold: SELECT count(*) FROM AIRPORTS --- Match OK easy pred: SELECT Count(*) FROM airports easy gold: SELECT count(*) FROM AIRPORTS --- Match OK easy pred: SELECT Count(*) FROM flights easy gold: SELECT count(*) FROM FLIGHTS --- Match OK easy pred: SELECT Count(*) FROM flights easy gold: SELECT count(*) FROM FLIGHTS --- Match OK easy pred: SELECT airlines.Airline FROM airlines WHERE airlines.Abbreviation = 'terminal' easy gold: SELECT Airline FROM AIRLINES WHERE Abbreviation = "UAL" --- Match OK easy pred: SELECT airlines.Airline FROM airlines WHERE airlines.Abbreviation = 'terminal' easy gold: SELECT Airline FROM AIRLINES WHERE Abbreviation = "UAL" --- Match OK easy pred: SELECT Count(*) FROM airlines WHERE airlines.Country = 'terminal' easy gold: SELECT count(*) FROM AIRLINES WHERE Country = "USA" --- Match OK easy pred: SELECT Count(*) FROM airlines WHERE airlines.Country = 'terminal' easy gold: SELECT count(*) FROM AIRLINES WHERE Country = "USA" --- Match OK medium pred: SELECT airports.City, airports.Country FROM airports WHERE airports.AirportName = 'terminal' medium gold: SELECT City , Country FROM AIRPORTS WHERE AirportName = "Alton" --- Match OK medium pred: SELECT airports.City, airports.Country FROM airports WHERE airports.AirportName = 'terminal' medium gold: SELECT City , Country FROM AIRPORTS WHERE AirportName = "Alton" --- Match OK easy pred: SELECT airports.AirportName FROM airports WHERE airports.AirportCode = 'terminal' easy gold: SELECT AirportName FROM AIRPORTS WHERE AirportCode = "AKO" --- Match OK easy pred: SELECT airports.AirportName FROM airports WHERE airports.AirportCode = 'terminal' easy gold: SELECT AirportName FROM AIRPORTS WHERE AirportCode = "AKO" --- Match OK easy pred: SELECT airports.AirportName FROM airports WHERE airports.City = 'terminal' easy gold: SELECT AirportName FROM AIRPORTS WHERE City = "Aberdeen" --- Match OK easy pred: SELECT airports.AirportName FROM airports WHERE airports.City = 'terminal' easy gold: SELECT AirportName FROM AIRPORTS WHERE City = "Aberdeen" --- Match OK easy pred: SELECT Count(*) FROM flights WHERE flights.DestAirport = 'terminal' easy gold: SELECT count(*) FROM FLIGHTS WHERE SourceAirport = "APG" --- Match OK easy pred: SELECT Count(*) FROM flights WHERE flights.DestAirport = 'terminal' easy gold: SELECT count(*) FROM FLIGHTS WHERE SourceAirport = "APG" --- Match OK easy pred: SELECT Count(*) FROM flights WHERE flights.DestAirport = 'terminal' easy gold: SELECT count(*) FROM FLIGHTS WHERE DestAirport = "ATO" --- Match OK easy pred: SELECT Count(*) FROM flights WHERE flights.SourceAirport = 'terminal' easy gold: SELECT count(*) FROM FLIGHTS WHERE DestAirport = "ATO" --- Match OK medium pred: SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' medium gold: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode WHERE T2.City = "Aberdeen" --- Match OK medium pred: SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' medium gold: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode WHERE T2.City = "Aberdeen" --- Match OK medium pred: SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' medium gold: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.City = "Aberdeen" --- Match OK medium pred: SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' medium gold: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.City = "Aberdeen" --- Match Fail hard pred: SELECT Count(*) FROM flights JOIN airports WHERE airports.City = 'terminal' AND airports.City = 'terminal' hard gold: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode JOIN AIRPORTS AS T3 ON T1.SourceAirport = T3.AirportCode WHERE T2.City = "Ashley" AND T3.City = "Aberdeen" --- Match Fail hard pred: SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' AND airports.AirportName = 'terminal' hard gold: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode JOIN AIRPORTS AS T3 ON T1.SourceAirport = T3.AirportCode WHERE T2.City = "Ashley" AND T3.City = "Aberdeen" --- Match OK medium pred: SELECT Count(*) FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' medium gold: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T1.Airline = T2.uid WHERE T2.Airline = "JetBlue Airways" --- Match OK medium pred: SELECT Count(*) FROM flights JOIN airlines WHERE airlines.Airline = 'terminal' medium gold: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T1.Airline = T2.uid WHERE T2.Airline = "JetBlue Airways" --- Match OK medium pred: SELECT Count(*) FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' AND flights.DestAirport = 'terminal' medium gold: SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline = T1.uid WHERE T1.Airline = "United Airlines" AND T2.DestAirport = "ASY" --- Match Fail medium pred: SELECT Count(*) FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' medium gold: SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline = T1.uid WHERE T1.Airline = "United Airlines" AND T2.DestAirport = "ASY" --- Match OK medium pred: SELECT Count(*) FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' AND flights.DestAirport = 'terminal' medium gold: SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline = T1.uid WHERE T1.Airline = "United Airlines" AND T2.SourceAirport = "AHD" --- Match Fail medium pred: SELECT Count(*) FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' AND airlines.Airline = 'terminal' medium gold: SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline = T1.uid WHERE T1.Airline = "United Airlines" AND T2.SourceAirport = "AHD" --- Match Fail hard pred: SELECT Count(*) FROM airlines JOIN airports WHERE airports.City = 'terminal' AND airports.City = 'terminal' hard gold: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode JOIN AIRLINES AS T3 ON T3.uid = T1.Airline WHERE T2.City = "Aberdeen" AND T3.Airline = "United Airlines" --- Match Fail hard pred: SELECT Count(*) FROM airlines JOIN airports WHERE airports.City = 'terminal' AND airlines.Airline = 'terminal' hard gold: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode JOIN AIRLINES AS T3 ON T3.uid = T1.Airline WHERE T2.City = "Aberdeen" AND T3.Airline = "United Airlines" --- Match OK extra pred: SELECT airports.City FROM airports JOIN flights GROUP BY airports.City ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT airports.City FROM airports JOIN flights GROUP BY airports.City ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT airports.City FROM airports JOIN flights GROUP BY airports.City ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.SourceAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT airports.City FROM airports JOIN flights GROUP BY airports.City ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.SourceAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT airports.AirportCode FROM airports JOIN flights GROUP BY airports.AirportCode ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport OR T1.AirportCode = T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT airports.AirportCode FROM airports JOIN flights GROUP BY airports.AirportCode ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport OR T1.AirportCode = T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT airports.AirportCode FROM airports JOIN flights GROUP BY airports.AirportCode ORDER BY Count(*) Asc LIMIT 1 extra gold: SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport OR T1.AirportCode = T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) LIMIT 1 --- Match Fail extra pred: SELECT airports.City FROM flights JOIN airports GROUP BY flights.DestAirport ORDER BY Count(*) Asc LIMIT 1 extra gold: SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode = T2.DestAirport OR T1.AirportCode = T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) LIMIT 1 --- Match OK extra pred: SELECT airlines.Airline FROM airlines JOIN flights GROUP BY airlines.Airline ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT airlines.Airline FROM airlines JOIN flights GROUP BY airlines.Airline ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT airlines.Airline, airlines.Country FROM airlines JOIN flights JOIN airports GROUP BY airlines.Airline ORDER BY Count(*) Asc LIMIT 1 extra gold: SELECT T1.Abbreviation , T1.Country FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline ORDER BY count(*) LIMIT 1 --- Match Fail extra pred: SELECT flights.Airline, airports.Country FROM flights JOIN airports GROUP BY airports.Country ORDER BY Count(*) Asc LIMIT 1 extra gold: SELECT T1.Abbreviation , T1.Country FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline ORDER BY count(*) LIMIT 1 --- Match Fail medium pred: SELECT airlines.Airline FROM airlines JOIN airports WHERE airports.AirportCode = 'terminal' medium gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = "AHD" --- Match OK medium pred: SELECT airlines.Airline FROM airlines JOIN flights WHERE flights.SourceAirport = 'terminal' medium gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = "AHD" --- Match Fail medium pred: SELECT airlines.Airline FROM airlines JOIN airports WHERE airports.AirportCode = 'terminal' medium gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.DestAirport = "AHD" --- Match OK medium pred: SELECT airlines.Airline FROM airlines JOIN flights WHERE flights.DestAirport = 'terminal' medium gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.DestAirport = "AHD" --- Match Fail extra pred: SELECT airlines.Airline FROM airlines JOIN airports WHERE flights.SourceAirport = 'terminal' INTERSECT SELECT airlines.Airline FROM airlines JOIN flights WHERE flights.SourceAirport = 'terminal' extra gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = "APG" INTERSECT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = "CVO" --- Match Fail extra pred: SELECT airlines.Airline FROM airlines JOIN airports WHERE airports.AirportCode = 'terminal' INTERSECT SELECT airlines.Airline FROM airlines JOIN airports WHERE airports.AirportCode = 'terminal' extra gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = "APG" INTERSECT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = "CVO" --- Match Fail extra pred: SELECT airlines.Airline FROM airlines JOIN airports WHERE flights.SourceAirport = 'terminal' EXCEPT SELECT airlines.Airline FROM airlines JOIN airports WHERE flights.SourceAirport = 'terminal' extra gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = "CVO" EXCEPT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = "APG" --- Match Fail extra pred: SELECT airlines.Airline FROM airlines JOIN airports WHERE airlines.Abbreviation = 'terminal' EXCEPT SELECT airlines.Airline FROM airlines JOIN airports WHERE airports.AirportCode = 'terminal' extra gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = "CVO" EXCEPT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline WHERE T2.SourceAirport = "APG" --- Match Fail medium pred: SELECT airlines.Airline FROM airlines JOIN flights GROUP BY flights.Airline HAVING Count(*) >= 'terminal' medium gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline HAVING count(*) > 10 --- Match Fail medium pred: SELECT airlines.Airline FROM airlines JOIN flights GROUP BY flights.Airline HAVING Count(*) >= 'terminal' medium gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline HAVING count(*) > 10 --- Match Fail medium pred: SELECT airlines.Airline FROM airlines JOIN flights WHERE flights.FlightNo < 'terminal' medium gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline HAVING count(*) < 200 --- Match Fail medium pred: SELECT airlines.Airline FROM airlines JOIN flights WHERE flights.FlightNo < 'terminal' medium gold: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid = T2.Airline GROUP BY T1.Airline HAVING count(*) < 200 --- Match OK medium pred: SELECT flights.FlightNo FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' medium gold: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T2.uid = T1.Airline WHERE T2.Airline = "United Airlines" --- Match OK medium pred: SELECT flights.FlightNo FROM airlines JOIN flights WHERE airlines.Airline = 'terminal' medium gold: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T2.uid = T1.Airline WHERE T2.Airline = "United Airlines" --- Match OK easy pred: SELECT flights.FlightNo FROM flights WHERE flights.DestAirport = 'terminal' easy gold: SELECT FlightNo FROM FLIGHTS WHERE SourceAirport = "APG" --- Match Fail easy pred: SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.City = 'terminal' easy gold: SELECT FlightNo FROM FLIGHTS WHERE SourceAirport = "APG" --- Match OK easy pred: SELECT flights.FlightNo FROM flights WHERE flights.DestAirport = 'terminal' easy gold: SELECT FlightNo FROM FLIGHTS WHERE DestAirport = "APG" --- Match OK easy pred: SELECT flights.FlightNo FROM flights WHERE flights.DestAirport = 'terminal' easy gold: SELECT FlightNo FROM FLIGHTS WHERE DestAirport = "APG" --- Match OK medium pred: SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.City = 'terminal' medium gold: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode WHERE T2.City = "Aberdeen" --- Match OK medium pred: SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.City = 'terminal' medium gold: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport = T2.AirportCode WHERE T2.City = "Aberdeen" --- Match OK medium pred: SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.City = 'terminal' medium gold: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.City = "Aberdeen" --- Match OK medium pred: SELECT flights.FlightNo FROM airports JOIN flights WHERE airports.City = 'terminal' medium gold: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.City = "Aberdeen" --- Match OK hard pred: SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' OR airports.City = 'terminal' hard gold: SELECT count(*) FROM Flights AS T1 JOIN Airports AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.city = "Aberdeen" OR T2.city = "Abilene" --- Match OK hard pred: SELECT Count(*) FROM airports JOIN flights WHERE airports.City = 'terminal' OR airports.City = 'terminal' hard gold: SELECT count(*) FROM Flights AS T1 JOIN Airports AS T2 ON T1.DestAirport = T2.AirportCode WHERE T2.city = "Aberdeen" OR T2.city = "Abilene" --- Match Fail hard pred: SELECT airports.AirportName FROM airports JOIN flights WHERE airports.CountryAbbrev = 'terminal' EXCEPT SELECT airports.AirportName FROM airports WHERE airports.CountryAbbrev = 'terminal' hard gold: SELECT AirportName FROM Airports WHERE AirportCode NOT IN (SELECT SourceAirport FROM Flights UNION SELECT DestAirport FROM Flights) --- Match Fail hard pred: SELECT * FROM airports WHERE airports.AirportName = 'terminal' EXCEPT SELECT flights.SourceAirport FROM flights GROUP BY flights.DestAirport HAVING Count(*) >= 'terminal' hard gold: SELECT AirportName FROM Airports WHERE AirportCode NOT IN (SELECT SourceAirport FROM Flights UNION SELECT DestAirport FROM Flights) --- Match OK easy pred: SELECT Count(*) FROM employee easy gold: SELECT count(*) FROM employee --- Match OK easy pred: SELECT Count(*) FROM employee easy gold: SELECT count(*) FROM employee --- Match OK easy pred: SELECT employee.Name FROM employee ORDER BY employee.Age Asc easy gold: SELECT name FROM employee ORDER BY age --- Match OK easy pred: SELECT employee.Name FROM employee ORDER BY employee.Age Asc easy gold: SELECT name FROM employee ORDER BY age --- Match OK medium pred: SELECT employee.City, Count(*) FROM employee GROUP BY employee.City medium gold: SELECT count(*) , city FROM employee GROUP BY city --- Match OK medium pred: SELECT employee.City, Count(*) FROM employee GROUP BY employee.City medium gold: SELECT count(*) , city FROM employee GROUP BY city --- Match Fail medium pred: SELECT employee.City FROM employee WHERE employee.Age > 'terminal' INTERSECT SELECT employee.City FROM employee WHERE employee.Age < 'terminal' medium gold: SELECT city FROM employee WHERE age < 30 GROUP BY city HAVING count(*) > 1 --- Match Fail medium pred: SELECT employee.City FROM employee WHERE employee.Age > 'terminal' medium gold: SELECT city FROM employee WHERE age < 30 GROUP BY city HAVING count(*) > 1 --- Match OK medium pred: SELECT shop.Location, Count(*) FROM shop GROUP BY shop.Location medium gold: SELECT count(*) , LOCATION FROM shop GROUP BY LOCATION --- Match OK medium pred: SELECT shop.Location, Count(*) FROM shop GROUP BY shop.Location medium gold: SELECT count(*) , LOCATION FROM shop GROUP BY LOCATION --- Match Fail medium pred: SELECT shop.Manager_name, shop.District FROM employee JOIN shop GROUP BY shop.Manager_name ORDER BY Count(*) Desc LIMIT 1 medium gold: SELECT manager_name , district FROM shop ORDER BY number_products DESC LIMIT 1 --- Match Fail medium pred: SELECT shop.Manager_name, shop.District FROM shop JOIN hiring GROUP BY hiring.Shop_ID ORDER BY Count(*) Desc LIMIT 1 medium gold: SELECT manager_name , district FROM shop ORDER BY number_products DESC LIMIT 1 --- Match Fail medium pred: SELECT Min(shop.Name), Max(shop.Number_products) FROM shop medium gold: SELECT min(Number_products) , max(Number_products) FROM shop --- Match OK medium pred: SELECT Min(shop.Number_products), Max(shop.Number_products) FROM shop medium gold: SELECT min(Number_products) , max(Number_products) FROM shop --- Match Fail medium pred: SELECT shop.Name, shop.Location, shop.District FROM shop ORDER BY shop.Name Desc medium gold: SELECT name , LOCATION , district FROM shop ORDER BY number_products DESC --- Match Fail medium pred: SELECT shop.Name, shop.Manager_name, shop.Location FROM shop ORDER BY shop.Name Desc medium gold: SELECT name , LOCATION , district FROM shop ORDER BY number_products DESC --- Match OK hard pred: SELECT shop.Name FROM shop WHERE shop.Number_products > (SELECT Avg(shop.Number_products) FROM shop) hard gold: SELECT name FROM shop WHERE number_products > (SELECT avg(number_products) FROM shop) --- Match Fail hard pred: SELECT Count(DISTINCT shop.Name) FROM shop WHERE shop.Number_products > (SELECT Avg(hiring.Is_full_time) FROM hiring) hard gold: SELECT name FROM shop WHERE number_products > (SELECT avg(number_products) FROM shop) --- Match Fail extra pred: SELECT employee.Name FROM employee JOIN hiring GROUP BY employee.Employee_ID ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT t1.name FROM employee AS t1 JOIN evaluation AS t2 ON t1.Employee_ID = t2.Employee_ID GROUP BY t2.Employee_ID ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT employee.Name FROM employee JOIN evaluation GROUP BY employee.Employee_ID ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT t1.name FROM employee AS t1 JOIN evaluation AS t2 ON t1.Employee_ID = t2.Employee_ID GROUP BY t2.Employee_ID ORDER BY count(*) DESC LIMIT 1 --- Match OK hard pred: SELECT employee.Name FROM employee JOIN evaluation ORDER BY evaluation.Bonus Desc LIMIT 1 hard gold: SELECT t1.name FROM employee AS t1 JOIN evaluation AS t2 ON t1.Employee_ID = t2.Employee_ID ORDER BY t2.bonus DESC LIMIT 1 --- Match Fail hard pred: SELECT employee.Name FROM employee JOIN evaluation GROUP BY employee.Employee_ID ORDER BY Sum(evaluation.Bonus) Desc LIMIT 1 hard gold: SELECT t1.name FROM employee AS t1 JOIN evaluation AS t2 ON t1.Employee_ID = t2.Employee_ID ORDER BY t2.bonus DESC LIMIT 1 --- Match OK hard pred: SELECT employee.Name FROM employee WHERE employee.Employee_ID NOT IN (SELECT evaluation.Employee_ID FROM evaluation) hard gold: SELECT name FROM employee WHERE Employee_ID NOT IN (SELECT Employee_ID FROM evaluation) --- Match OK hard pred: SELECT employee.Name FROM employee WHERE employee.Employee_ID NOT IN (SELECT evaluation.Employee_ID FROM evaluation) hard gold: SELECT name FROM employee WHERE Employee_ID NOT IN (SELECT Employee_ID FROM evaluation) --- Match OK extra pred: SELECT shop.Name FROM hiring JOIN shop GROUP BY hiring.Shop_ID ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id = t2.shop_id GROUP BY t1.shop_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT shop.Name FROM shop JOIN hiring GROUP BY shop.Name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id = t2.shop_id GROUP BY t1.shop_id ORDER BY count(*) DESC LIMIT 1 --- Match OK hard pred: SELECT shop.Name FROM shop WHERE shop.Shop_ID NOT IN (SELECT hiring.Shop_ID FROM hiring) hard gold: SELECT name FROM shop WHERE shop_id NOT IN (SELECT shop_id FROM hiring) --- Match OK hard pred: SELECT shop.Name FROM shop WHERE shop.Shop_ID NOT IN (SELECT hiring.Shop_ID FROM hiring) hard gold: SELECT name FROM shop WHERE shop_id NOT IN (SELECT shop_id FROM hiring) --- Match Fail medium pred: SELECT Count(*), hiring.Shop_ID FROM hiring GROUP BY hiring.Shop_ID medium gold: SELECT count(*) , t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id = t2.shop_id GROUP BY t2.name --- Match Fail medium pred: SELECT shop.Name, Count(*) FROM hiring JOIN shop GROUP BY hiring.Shop_ID medium gold: SELECT count(*) , t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id = t2.shop_id GROUP BY t2.name --- Match Fail easy pred: SELECT Sum(evaluation.Year_awarded) FROM evaluation easy gold: SELECT sum(bonus) FROM evaluation --- Match Fail easy pred: SELECT Sum(evaluation.Year_awarded) FROM evaluation easy gold: SELECT sum(bonus) FROM evaluation --- Match OK easy pred: SELECT * FROM hiring easy gold: SELECT * FROM hiring --- Match OK easy pred: SELECT * FROM hiring easy gold: SELECT * FROM hiring --- Match Fail hard pred: SELECT shop.District FROM shop WHERE shop.Number_products < 'terminal' INTERSECT SELECT shop.District FROM shop WHERE shop.Number_products < 'terminal' hard gold: SELECT district FROM shop WHERE Number_products < 3000 INTERSECT SELECT district FROM shop WHERE Number_products > 10000 --- Match OK hard pred: SELECT shop.District FROM shop WHERE shop.Number_products < 'terminal' INTERSECT SELECT shop.District FROM shop WHERE shop.Number_products > 'terminal' hard gold: SELECT district FROM shop WHERE Number_products < 3000 INTERSECT SELECT district FROM shop WHERE Number_products > 10000 --- Match OK easy pred: SELECT Count(DISTINCT shop.Location) FROM shop easy gold: SELECT count(DISTINCT LOCATION) FROM shop --- Match OK easy pred: SELECT Count(DISTINCT shop.Location) FROM shop easy gold: SELECT count(DISTINCT LOCATION) FROM shop --- Match OK easy pred: SELECT Count(*) FROM Documents easy gold: SELECT count(*) FROM Documents --- Match OK easy pred: SELECT Count(*) FROM Documents easy gold: SELECT count(*) FROM Documents --- Match OK medium pred: SELECT Documents.Document_ID, Documents.Document_Name, Documents.Document_Description FROM Documents medium gold: SELECT document_id , document_name , document_description FROM Documents --- Match OK medium pred: SELECT Documents.Document_ID, Documents.Document_Name, Documents.Document_Description FROM Documents medium gold: SELECT document_id , document_name , document_description FROM Documents --- Match Fail medium pred: SELECT Documents.Document_Name, Documents.Document_ID FROM Documents WHERE Documents.Document_Description LIKE 'terminal' medium gold: SELECT document_name , template_id FROM Documents WHERE Document_Description LIKE "%w%" --- Match Fail medium pred: SELECT Documents.Document_Name, Documents.Document_ID FROM Documents WHERE Documents.Document_Description LIKE 'terminal' medium gold: SELECT document_name , template_id FROM Documents WHERE Document_Description LIKE "%w%" --- Match OK medium pred: SELECT Documents.Document_ID, Documents.Template_ID, Documents.Document_Description FROM Documents WHERE Documents.Document_Name = 'terminal' medium gold: SELECT document_id , template_id , Document_Description FROM Documents WHERE document_name = "Robbin CV" --- Match OK medium pred: SELECT Documents.Document_ID, Documents.Template_ID, Documents.Document_Description FROM Documents WHERE Documents.Document_Name = 'terminal' medium gold: SELECT document_id , template_id , Document_Description FROM Documents WHERE document_name = "Robbin CV" --- Match Fail easy pred: SELECT Count(DISTINCT Paragraphs.Document_ID) FROM Paragraphs easy gold: SELECT count(DISTINCT template_id) FROM Documents --- Match Fail easy pred: SELECT Count(DISTINCT Paragraphs.Document_ID) FROM Paragraphs easy gold: SELECT count(DISTINCT template_id) FROM Documents --- Match OK medium pred: SELECT Count(*) FROM Documents JOIN Templates WHERE Templates.Template_Type_Code = 'terminal' medium gold: SELECT count(*) FROM Documents AS T1 JOIN Templates AS T2 ON T1.Template_ID = T2.Template_ID WHERE T2.Template_Type_Code = 'PPT' --- Match Fail medium pred: SELECT Count(*) FROM Templates WHERE Templates.Template_Type_Code = 'terminal' medium gold: SELECT count(*) FROM Documents AS T1 JOIN Templates AS T2 ON T1.Template_ID = T2.Template_ID WHERE T2.Template_Type_Code = 'PPT' --- Match Fail medium pred: SELECT Documents.Template_ID, Count(*) FROM Documents JOIN Paragraphs GROUP BY Paragraphs.Document_ID medium gold: SELECT template_id , count(*) FROM Documents GROUP BY template_id --- Match Fail medium pred: SELECT Paragraphs.Document_ID, Count(*) FROM Paragraphs GROUP BY Paragraphs.Document_ID medium gold: SELECT template_id , count(*) FROM Documents GROUP BY template_id --- Match Fail extra pred: SELECT Documents.Template_ID, Count(*) FROM Documents GROUP BY Documents.Template_ID ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.template_id , T2.Template_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 --- Match OK extra pred: SELECT Documents.Template_ID, Templates.Template_Type_Code FROM Documents JOIN Templates GROUP BY Documents.Template_ID ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.template_id , T2.Template_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 --- Match Fail easy pred: SELECT Documents.Template_ID FROM Documents JOIN Paragraphs GROUP BY Documents.Template_ID HAVING Count(*) > 'terminal' easy gold: SELECT template_id FROM Documents GROUP BY template_id HAVING count(*) > 1 --- Match Fail easy pred: SELECT Paragraphs.Document_ID FROM Paragraphs GROUP BY Paragraphs.Document_ID HAVING Count(*) > 'terminal' easy gold: SELECT template_id FROM Documents GROUP BY template_id HAVING count(*) > 1 --- Match OK hard pred: SELECT Templates.Template_ID FROM Templates EXCEPT SELECT Documents.Template_ID FROM Documents hard gold: SELECT template_id FROM Templates EXCEPT SELECT template_id FROM Documents --- Match OK hard pred: SELECT Templates.Template_ID FROM Templates EXCEPT SELECT Documents.Template_ID FROM Documents hard gold: SELECT template_id FROM Templates EXCEPT SELECT template_id FROM Documents --- Match OK easy pred: SELECT Count(*) FROM Templates easy gold: SELECT count(*) FROM Templates --- Match OK easy pred: SELECT Count(*) FROM Templates easy gold: SELECT count(*) FROM Templates --- Match OK medium pred: SELECT Templates.Template_ID, Templates.Version_Number, Templates.Template_Type_Code FROM Templates medium gold: SELECT template_id , version_number , template_type_code FROM Templates --- Match OK medium pred: SELECT Templates.Template_ID, Templates.Version_Number, Templates.Template_Type_Code FROM Templates medium gold: SELECT template_id , version_number , template_type_code FROM Templates --- Match OK easy pred: SELECT DISTINCT Templates.Template_Type_Code FROM Templates easy gold: SELECT DISTINCT template_type_code FROM Templates --- Match Fail easy pred: SELECT DISTINCT Ref_Template_Types.Template_Type_Code FROM Ref_Template_Types easy gold: SELECT DISTINCT template_type_code FROM Templates --- Match OK medium pred: SELECT Templates.Template_ID FROM Templates WHERE Templates.Template_Type_Code = 'terminal' OR Templates.Template_Type_Code = 'terminal' medium gold: SELECT template_id FROM Templates WHERE template_type_code = "PP" OR template_type_code = "PPT" --- Match OK medium pred: SELECT Templates.Template_ID FROM Templates WHERE Templates.Template_Type_Code = 'terminal' OR Templates.Template_Type_Code = 'terminal' medium gold: SELECT template_id FROM Templates WHERE template_type_code = "PP" OR template_type_code = "PPT" --- Match OK easy pred: SELECT Count(*) FROM Templates WHERE Templates.Template_Type_Code = 'terminal' easy gold: SELECT count(*) FROM Templates WHERE template_type_code = "CV" --- Match OK easy pred: SELECT Count(*) FROM Templates WHERE Templates.Template_Type_Code = 'terminal' easy gold: SELECT count(*) FROM Templates WHERE template_type_code = "CV" --- Match Fail medium pred: SELECT Ref_Template_Types.Template_Type_Code, Templates.Template_Type_Code FROM Ref_Template_Types JOIN Templates WHERE Templates.Template_ID < 'terminal' medium gold: SELECT version_number , template_type_code FROM Templates WHERE version_number > 5 --- Match Fail medium pred: SELECT Ref_Template_Types.Template_Type_Code, Templates.Template_Type_Code FROM Ref_Template_Types JOIN Templates GROUP BY Templates.Template_Type_Code HAVING Count(*) > 'terminal' medium gold: SELECT version_number , template_type_code FROM Templates WHERE version_number > 5 --- Match OK medium pred: SELECT Templates.Template_Type_Code, Count(*) FROM Templates GROUP BY Templates.Template_Type_Code medium gold: SELECT template_type_code , count(*) FROM Templates GROUP BY template_type_code --- Match OK medium pred: SELECT Templates.Template_Type_Code, Count(*) FROM Templates GROUP BY Templates.Template_Type_Code medium gold: SELECT template_type_code , count(*) FROM Templates GROUP BY template_type_code --- Match OK hard pred: SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT template_type_code FROM Templates GROUP BY template_type_code ORDER BY count(*) DESC LIMIT 1 --- Match OK hard pred: SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT template_type_code FROM Templates GROUP BY template_type_code ORDER BY count(*) DESC LIMIT 1 --- Match OK easy pred: SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code HAVING Count(*) < 'terminal' easy gold: SELECT template_type_code FROM Templates GROUP BY template_type_code HAVING count(*) < 3 --- Match Fail easy pred: SELECT Ref_Template_Types.Template_Type_Code FROM Templates JOIN Ref_Template_Types GROUP BY Templates.Template_Type_Code HAVING Count(*) < 'terminal' easy gold: SELECT template_type_code FROM Templates GROUP BY template_type_code HAVING count(*) < 3 --- Match Fail medium pred: SELECT Templates.Version_Number, Count(*) FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Asc LIMIT 1 medium gold: SELECT min(Version_Number) , template_type_code FROM Templates --- Match Fail medium pred: SELECT Templates.Version_Number, Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Asc LIMIT 1 medium gold: SELECT min(Version_Number) , template_type_code FROM Templates --- Match OK medium pred: SELECT Templates.Template_Type_Code FROM Documents JOIN Templates WHERE Documents.Document_Name = 'terminal' medium gold: SELECT T1.template_type_code FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id WHERE T2.document_name = "Data base" --- Match OK medium pred: SELECT Templates.Template_Type_Code FROM Documents JOIN Templates WHERE Documents.Document_Name = 'terminal' medium gold: SELECT T1.template_type_code FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id WHERE T2.document_name = "Data base" --- Match OK medium pred: SELECT Documents.Document_Name FROM Documents JOIN Templates WHERE Templates.Template_Type_Code = 'terminal' medium gold: SELECT T2.document_name FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id WHERE T1.template_type_code = "BK" --- Match Fail medium pred: SELECT Documents.Document_Name FROM Documents JOIN Paragraphs JOIN Templates WHERE Templates.Template_Type_Code = 'terminal' medium gold: SELECT T2.document_name FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id WHERE T1.template_type_code = "BK" --- Match Fail medium pred: SELECT Templates.Template_Type_Code, Count(*) FROM Templates GROUP BY Templates.Template_Type_Code medium gold: SELECT T1.template_type_code , count(*) FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id GROUP BY T1.template_type_code --- Match Fail medium pred: SELECT Templates.Template_Type_Code, Count(*) FROM Templates GROUP BY Templates.Template_Type_Code medium gold: SELECT T1.template_type_code , count(*) FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id GROUP BY T1.template_type_code --- Match Fail extra pred: SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.template_type_code FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id GROUP BY T1.template_type_code ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Templates.Template_Type_Code FROM Templates GROUP BY Templates.Template_Type_Code ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.template_type_code FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id GROUP BY T1.template_type_code ORDER BY count(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT Ref_Template_Types.Template_Type_Code FROM Ref_Template_Types EXCEPT SELECT Templates.Template_Type_Code FROM Templates hard gold: SELECT template_type_code FROM Templates EXCEPT SELECT template_type_code FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id --- Match Fail hard pred: SELECT Ref_Template_Types.Template_Type_Code FROM Ref_Template_Types EXCEPT SELECT Templates.Template_Type_Code FROM Templates hard gold: SELECT template_type_code FROM Templates EXCEPT SELECT template_type_code FROM Templates AS T1 JOIN Documents AS T2 ON T1.template_id = T2.template_id --- Match OK medium pred: SELECT Ref_Template_Types.Template_Type_Code, Ref_Template_Types.Template_Type_Description FROM Ref_Template_Types medium gold: SELECT template_type_code , template_type_description FROM Ref_template_types --- Match OK medium pred: SELECT Ref_Template_Types.Template_Type_Code, Ref_Template_Types.Template_Type_Description FROM Ref_Template_Types medium gold: SELECT template_type_code , template_type_description FROM Ref_template_types --- Match OK easy pred: SELECT Ref_Template_Types.Template_Type_Description FROM Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Code = 'terminal' easy gold: SELECT template_type_description FROM Ref_template_types WHERE template_type_code = "AD" --- Match OK easy pred: SELECT Ref_Template_Types.Template_Type_Description FROM Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Code = 'terminal' easy gold: SELECT template_type_description FROM Ref_template_types WHERE template_type_code = "AD" --- Match OK easy pred: SELECT Ref_Template_Types.Template_Type_Code FROM Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Description = 'terminal' easy gold: SELECT template_type_code FROM Ref_template_types WHERE template_type_description = "Book" --- Match OK easy pred: SELECT Ref_Template_Types.Template_Type_Code FROM Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Description = 'terminal' easy gold: SELECT template_type_code FROM Ref_template_types WHERE template_type_description = "Book" --- Match Fail medium pred: SELECT DISTINCT Ref_Template_Types.Template_Type_Description FROM Ref_Template_Types JOIN Templates medium gold: SELECT DISTINCT T1.template_type_description FROM Ref_template_types AS T1 JOIN Templates AS T2 ON T1.template_type_code = T2.template_type_code JOIN Documents AS T3 ON T2.Template_ID = T3.template_ID --- Match Fail medium pred: SELECT DISTINCT Documents.Document_Description FROM Documents JOIN Paragraphs medium gold: SELECT DISTINCT T1.template_type_description FROM Ref_template_types AS T1 JOIN Templates AS T2 ON T1.template_type_code = T2.template_type_code JOIN Documents AS T3 ON T2.Template_ID = T3.template_ID --- Match Fail medium pred: SELECT Documents.Document_ID FROM Documents JOIN Ref_Template_Types WHERE Ref_Template_Types.Template_Type_Description = 'terminal' medium gold: SELECT T2.template_id FROM Ref_template_types AS T1 JOIN Templates AS T2 ON T1.template_type_code = T2.template_type_code WHERE T1.template_type_description = "Presentation" --- Match Fail medium pred: SELECT Documents.Template_ID FROM Documents WHERE Documents.Document_Description = 'terminal' medium gold: SELECT T2.template_id FROM Ref_template_types AS T1 JOIN Templates AS T2 ON T1.template_type_code = T2.template_type_code WHERE T1.template_type_description = "Presentation" --- Match OK easy pred: SELECT Count(*) FROM Paragraphs easy gold: SELECT count(*) FROM Paragraphs --- Match Fail easy pred: SELECT Count(*) FROM Ref_Template_Types easy gold: SELECT count(*) FROM Paragraphs --- Match OK medium pred: SELECT Count(*) FROM Documents JOIN Paragraphs WHERE Documents.Document_Name = 'terminal' medium gold: SELECT count(*) FROM Paragraphs AS T1 JOIN Documents AS T2 ON T1.document_ID = T2.document_ID WHERE T2.document_name = 'Summer Show' --- Match OK medium pred: SELECT Count(*) FROM Documents JOIN Paragraphs WHERE Documents.Document_Name = 'terminal' medium gold: SELECT count(*) FROM Paragraphs AS T1 JOIN Documents AS T2 ON T1.document_ID = T2.document_ID WHERE T2.document_name = 'Summer Show' --- Match Fail medium pred: SELECT * FROM Documents WHERE Documents.Document_Name = 'terminal' medium gold: select other_details from paragraphs where paragraph_text like 'korea' --- Match Fail medium pred: SELECT * FROM Templates WHERE Templates.Template_Details LIKE 'terminal' medium gold: select other_details from paragraphs where paragraph_text like 'korea' --- Match Fail medium pred: SELECT Documents.Document_ID, Documents.Template_ID FROM Documents WHERE Documents.Document_Name = 'terminal' medium gold: SELECT T1.paragraph_id , T1.paragraph_text FROM Paragraphs AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id WHERE T2.Document_Name = 'Welcome to NY' --- Match Fail medium pred: SELECT Documents.Document_ID, Documents.Document_ID FROM Documents WHERE Documents.Document_Name = 'terminal' medium gold: SELECT T1.paragraph_id , T1.paragraph_text FROM Paragraphs AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id WHERE T2.Document_Name = 'Welcome to NY' --- Match Fail medium pred: SELECT * FROM Paragraphs JOIN Documents WHERE Documents.Document_Name = 'terminal' medium gold: SELECT T1.paragraph_text FROM Paragraphs AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id WHERE T2.document_name = "Customer reviews" --- Match Fail medium pred: SELECT * FROM Documents JOIN Paragraphs WHERE Documents.Document_Name = 'terminal' medium gold: SELECT T1.paragraph_text FROM Paragraphs AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id WHERE T2.document_name = "Customer reviews" --- Match Fail medium pred: SELECT Paragraphs.Document_ID, Count(*) FROM Paragraphs GROUP BY Paragraphs.Document_ID medium gold: SELECT document_id , count(*) FROM Paragraphs GROUP BY document_id ORDER BY document_id --- Match Fail medium pred: SELECT Documents.Document_ID, Count(*) FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID ORDER BY Count(*) Asc medium gold: SELECT document_id , count(*) FROM Paragraphs GROUP BY document_id ORDER BY document_id --- Match OK medium pred: SELECT Documents.Document_ID, Documents.Document_Name, Count(*) FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID medium gold: SELECT T1.document_id , T2.document_name , count(*) FROM Paragraphs AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id --- Match OK medium pred: SELECT Documents.Document_ID, Documents.Document_Name, Count(*) FROM Documents JOIN Paragraphs GROUP BY Documents.Document_ID medium gold: SELECT T1.document_id , T2.document_name , count(*) FROM Paragraphs AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id --- Match OK easy pred: SELECT Paragraphs.Document_ID FROM Paragraphs GROUP BY Paragraphs.Document_ID HAVING Count(*) >= 'terminal' easy gold: SELECT document_id FROM Paragraphs GROUP BY document_id HAVING count(*) >= 2 --- Match OK easy pred: SELECT Paragraphs.Document_ID FROM Paragraphs GROUP BY Paragraphs.Document_ID HAVING Count(*) >= 'terminal' easy gold: SELECT document_id FROM Paragraphs GROUP BY document_id HAVING count(*) >= 2 --- Match OK extra pred: SELECT Documents.Document_ID, Documents.Document_Name FROM Documents JOIN Paragraphs GROUP BY Paragraphs.Document_ID ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.document_id , T2.document_name FROM Paragraphs AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT Documents.Document_ID, Documents.Document_Name FROM Documents JOIN Paragraphs GROUP BY Paragraphs.Document_ID ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.document_id , T2.document_name FROM Paragraphs AS T1 JOIN Documents AS T2 ON T1.document_id = T2.document_id GROUP BY T1.document_id ORDER BY count(*) DESC LIMIT 1 --- Match OK hard pred: SELECT Paragraphs.Document_ID FROM Paragraphs GROUP BY Paragraphs.Document_ID ORDER BY Count(*) Asc LIMIT 1 hard gold: SELECT document_id FROM Paragraphs GROUP BY document_id ORDER BY count(*) ASC LIMIT 1 --- Match OK hard pred: SELECT Paragraphs.Document_ID FROM Paragraphs GROUP BY Paragraphs.Document_ID ORDER BY Count(*) Asc LIMIT 1 hard gold: SELECT document_id FROM Paragraphs GROUP BY document_id ORDER BY count(*) ASC LIMIT 1 --- Match OK easy pred: SELECT Paragraphs.Document_ID FROM Paragraphs GROUP BY Paragraphs.Document_ID HAVING Count(*) BETWEEN 'terminal' AND 'terminal' easy gold: SELECT document_id FROM Paragraphs GROUP BY document_id HAVING count(*) BETWEEN 1 AND 2 --- Match Fail easy pred: SELECT Documents.Document_ID FROM Documents GROUP BY Paragraphs.Document_ID HAVING Count(*) BETWEEN 'terminal' AND 'terminal' INTERSECT SELECT Paragraphs.Document_ID FROM Paragraphs GROUP BY Paragraphs.Document_ID HAVING Count(*) BETWEEN 'terminal' AND 'terminal' easy gold: SELECT document_id FROM Paragraphs GROUP BY document_id HAVING count(*) BETWEEN 1 AND 2 --- Match Fail hard pred: SELECT Documents.Document_ID FROM Documents JOIN Paragraphs WHERE Documents.Template_ID = 'terminal' INTERSECT SELECT Documents.Document_ID FROM Documents JOIN Paragraphs WHERE Paragraphs.Paragraph_ID = 'terminal' hard gold: SELECT document_id FROM Paragraphs WHERE paragraph_text = 'Brazil' INTERSECT SELECT document_id FROM Paragraphs WHERE paragraph_text = 'Ireland' --- Match Fail hard pred: SELECT Documents.Document_ID FROM Documents JOIN Paragraphs WHERE Documents.Template_ID = 'terminal' INTERSECT SELECT Documents.Document_ID FROM Documents JOIN Paragraphs WHERE Paragraphs.Paragraph_ID = 'terminal' hard gold: SELECT document_id FROM Paragraphs WHERE paragraph_text = 'Brazil' INTERSECT SELECT document_id FROM Paragraphs WHERE paragraph_text = 'Ireland' --- Match OK easy pred: SELECT Count(*) FROM teacher easy gold: SELECT count(*) FROM teacher --- Match OK easy pred: SELECT Count(*) FROM teacher easy gold: SELECT count(*) FROM teacher --- Match OK easy pred: SELECT teacher.Name FROM teacher ORDER BY teacher.Age Asc easy gold: SELECT Name FROM teacher ORDER BY Age ASC --- Match OK easy pred: SELECT teacher.Name FROM teacher ORDER BY teacher.Age Asc easy gold: SELECT Name FROM teacher ORDER BY Age ASC --- Match OK medium pred: SELECT teacher.Age, teacher.Hometown FROM teacher medium gold: SELECT Age , Hometown FROM teacher --- Match OK medium pred: SELECT teacher.Age, teacher.Hometown FROM teacher medium gold: SELECT Age , Hometown FROM teacher --- Match OK easy pred: SELECT teacher.Name FROM teacher WHERE teacher.Hometown != 'terminal' easy gold: select name from teacher where hometown != "little lever urban district" --- Match OK easy pred: SELECT teacher.Name FROM teacher WHERE teacher.Hometown != 'terminal' easy gold: select name from teacher where hometown != "little lever urban district" --- Match Fail medium pred: SELECT teacher.Name FROM teacher WHERE teacher.Hometown = 'terminal' OR teacher.Age = 'terminal' medium gold: SELECT Name FROM teacher WHERE Age = 32 OR Age = 33 --- Match Fail medium pred: SELECT teacher.Name FROM teacher WHERE teacher.Hometown = 'terminal' OR teacher.Age = 'terminal' medium gold: SELECT Name FROM teacher WHERE Age = 32 OR Age = 33 --- Match OK medium pred: SELECT teacher.Hometown FROM teacher ORDER BY teacher.Age Asc LIMIT 1 medium gold: SELECT Hometown FROM teacher ORDER BY Age ASC LIMIT 1 --- Match Fail medium pred: SELECT teacher.Name FROM teacher ORDER BY teacher.Age Asc LIMIT 1 medium gold: SELECT Hometown FROM teacher ORDER BY Age ASC LIMIT 1 --- Match OK medium pred: SELECT teacher.Hometown, Count(*) FROM teacher GROUP BY teacher.Hometown medium gold: SELECT Hometown , COUNT(*) FROM teacher GROUP BY Hometown --- Match OK medium pred: SELECT teacher.Hometown, Count(*) FROM teacher GROUP BY teacher.Hometown medium gold: SELECT Hometown , COUNT(*) FROM teacher GROUP BY Hometown --- Match OK hard pred: SELECT teacher.Hometown FROM teacher GROUP BY teacher.Hometown ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT Hometown FROM teacher GROUP BY Hometown ORDER BY COUNT(*) DESC LIMIT 1 --- Match OK hard pred: SELECT teacher.Hometown FROM teacher GROUP BY teacher.Hometown ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT Hometown FROM teacher GROUP BY Hometown ORDER BY COUNT(*) DESC LIMIT 1 --- Match OK easy pred: SELECT teacher.Hometown FROM teacher GROUP BY teacher.Hometown HAVING Count(*) >= 'terminal' easy gold: SELECT Hometown FROM teacher GROUP BY Hometown HAVING COUNT(*) >= 2 --- Match OK easy pred: SELECT teacher.Hometown FROM teacher GROUP BY teacher.Hometown HAVING Count(*) >= 'terminal' easy gold: SELECT Hometown FROM teacher GROUP BY Hometown HAVING COUNT(*) >= 2 --- Match OK medium pred: SELECT teacher.Name, course.Course FROM course_arrange JOIN teacher JOIN course medium gold: SELECT T3.Name , T2.Course FROM course_arrange AS T1 JOIN course AS T2 ON T1.Course_ID = T2.Course_ID JOIN teacher AS T3 ON T1.Teacher_ID = T3.Teacher_ID --- Match OK medium pred: SELECT teacher.Name, course.Course FROM course_arrange JOIN teacher JOIN course medium gold: SELECT T3.Name , T2.Course FROM course_arrange AS T1 JOIN course AS T2 ON T1.Course_ID = T2.Course_ID JOIN teacher AS T3 ON T1.Teacher_ID = T3.Teacher_ID --- Match OK hard pred: SELECT teacher.Name, course.Course FROM course_arrange JOIN teacher JOIN course ORDER BY teacher.Name Asc hard gold: SELECT T3.Name , T2.Course FROM course_arrange AS T1 JOIN course AS T2 ON T1.Course_ID = T2.Course_ID JOIN teacher AS T3 ON T1.Teacher_ID = T3.Teacher_ID ORDER BY T3.Name --- Match OK hard pred: SELECT teacher.Name, course.Course FROM course_arrange JOIN course JOIN teacher ORDER BY teacher.Name Asc hard gold: SELECT T3.Name , T2.Course FROM course_arrange AS T1 JOIN course AS T2 ON T1.Course_ID = T2.Course_ID JOIN teacher AS T3 ON T1.Teacher_ID = T3.Teacher_ID ORDER BY T3.Name --- Match OK hard pred: SELECT teacher.Name FROM course_arrange JOIN teacher JOIN course WHERE course.Course = 'terminal' hard gold: SELECT T3.Name FROM course_arrange AS T1 JOIN course AS T2 ON T1.Course_ID = T2.Course_ID JOIN teacher AS T3 ON T1.Teacher_ID = T3.Teacher_ID WHERE T2.Course = "Math" --- Match OK hard pred: SELECT teacher.Name FROM course_arrange JOIN teacher JOIN course WHERE course.Course = 'terminal' hard gold: SELECT T3.Name FROM course_arrange AS T1 JOIN course AS T2 ON T1.Course_ID = T2.Course_ID JOIN teacher AS T3 ON T1.Teacher_ID = T3.Teacher_ID WHERE T2.Course = "Math" --- Match OK medium pred: SELECT teacher.Name, Count(*) FROM course_arrange JOIN teacher GROUP BY teacher.Name medium gold: SELECT T2.Name , COUNT(*) FROM course_arrange AS T1 JOIN teacher AS T2 ON T1.Teacher_ID = T2.Teacher_ID GROUP BY T2.Name --- Match OK medium pred: SELECT teacher.Name, Count(*) FROM course_arrange JOIN teacher GROUP BY teacher.Name medium gold: SELECT T2.Name , COUNT(*) FROM course_arrange AS T1 JOIN teacher AS T2 ON T1.Teacher_ID = T2.Teacher_ID GROUP BY T2.Name --- Match OK medium pred: SELECT teacher.Name FROM course_arrange JOIN teacher GROUP BY teacher.Name HAVING Count(*) >= 'terminal' medium gold: SELECT T2.Name FROM course_arrange AS T1 JOIN teacher AS T2 ON T1.Teacher_ID = T2.Teacher_ID GROUP BY T2.Name HAVING COUNT(*) >= 2 --- Match OK medium pred: SELECT teacher.Name FROM course_arrange JOIN teacher GROUP BY teacher.Name HAVING Count(*) >= 'terminal' medium gold: SELECT T2.Name FROM course_arrange AS T1 JOIN teacher AS T2 ON T1.Teacher_ID = T2.Teacher_ID GROUP BY T2.Name HAVING COUNT(*) >= 2 --- Match OK hard pred: SELECT teacher.Name FROM teacher WHERE teacher.Teacher_ID NOT IN (SELECT course_arrange.Teacher_ID FROM course_arrange) hard gold: SELECT Name FROM teacher WHERE Teacher_id NOT IN (SELECT Teacher_id FROM course_arrange) --- Match OK hard pred: SELECT teacher.Name FROM teacher WHERE teacher.Teacher_ID NOT IN (SELECT course_arrange.Teacher_ID FROM course_arrange) hard gold: SELECT Name FROM teacher WHERE Teacher_id NOT IN (SELECT Teacher_id FROM course_arrange) --- Match Fail easy pred: SELECT Count(*) FROM visitor JOIN visit WHERE visitor.Age < 'terminal' easy gold: SELECT count(*) FROM visitor WHERE age < 30 --- Match Fail medium pred: SELECT visitor.Name FROM visitor JOIN visit WHERE visit.Total_spent > 'terminal' ORDER BY visitor.Name Asc medium gold: SELECT name FROM visitor WHERE Level_of_membership > 4 ORDER BY Level_of_membership DESC --- Match Fail easy pred: SELECT Avg(visitor.Age) FROM visitor WHERE visitor.ID NOT IN (SELECT visit.visitor_ID FROM visit WHERE visit.Total_spent > 'terminal') easy gold: SELECT avg(age) FROM visitor WHERE Level_of_membership <= 4 --- Match Fail medium pred: SELECT visitor.Name, visitor.Age FROM visitor JOIN visit WHERE visit.Total_spent > 'terminal' ORDER BY visitor.Age Asc medium gold: SELECT name , Level_of_membership FROM visitor WHERE Level_of_membership > 4 ORDER BY age DESC --- Match Fail medium pred: SELECT museum.Museum_ID, museum.Name FROM museum JOIN visit GROUP BY museum.Name ORDER BY Count(*) Desc LIMIT 1 medium gold: SELECT museum_id , name FROM museum ORDER BY num_of_staff DESC LIMIT 1 --- Match OK easy pred: SELECT Avg(museum.Num_of_Staff) FROM museum WHERE museum.Open_Year < 'terminal' easy gold: SELECT avg(num_of_staff) FROM museum WHERE open_year < 2009 --- Match OK medium pred: SELECT museum.Open_Year, museum.Num_of_Staff FROM museum WHERE museum.Name = 'terminal' medium gold: SELECT Num_of_Staff , Open_Year FROM museum WHERE name = 'Plaza Museum' --- Match Fail hard pred: SELECT museum.Name FROM museum WHERE museum.Num_of_Staff > 'terminal' hard gold: SELECT name FROM museum WHERE num_of_staff > (SELECT min(num_of_staff) FROM museum WHERE open_year > 2010) --- Match OK medium pred: SELECT visitor.ID, visitor.Name, visitor.Age FROM visitor JOIN visit GROUP BY visit.visitor_ID HAVING Count(*) > 'terminal' medium gold: SELECT t1.id , t1.name , t1.age FROM visitor AS t1 JOIN visit AS t2 ON t1.id = t2.visitor_id GROUP BY t1.id HAVING count(*) > 1 --- Match Fail extra pred: SELECT visit.visitor_ID, visitor.Name, Sum(visit.Num_of_Ticket) FROM visit JOIN visitor GROUP BY visit.visitor_ID ORDER BY Sum(visit.Total_spent) Desc LIMIT 1 extra gold: SELECT t2.visitor_id , t1.name , t1.Level_of_membership FROM visitor AS t1 JOIN visit AS t2 ON t1.id = t2.visitor_id GROUP BY t2.visitor_id ORDER BY sum(t2.Total_spent) DESC LIMIT 1 --- Match OK extra pred: SELECT museum.Museum_ID, museum.Name FROM museum JOIN visit GROUP BY museum.Museum_ID ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT t2.Museum_ID , t1.name FROM museum AS t1 JOIN visit AS t2 ON t1.Museum_ID = t2.Museum_ID GROUP BY t2.Museum_ID ORDER BY count(*) DESC LIMIT 1 --- Match OK hard pred: SELECT museum.Name FROM museum WHERE museum.Museum_ID NOT IN (SELECT visit.Museum_ID FROM visit) hard gold: SELECT name FROM museum WHERE Museum_ID NOT IN (SELECT museum_id FROM visit) --- Match Fail hard pred: SELECT visitor.Name, visitor.Age FROM visitor JOIN visit GROUP BY visit.visitor_ID ORDER BY Sum(visit.Num_of_Ticket) Desc LIMIT 1 hard gold: SELECT t1.name , t1.age FROM visitor AS t1 JOIN visit AS t2 ON t1.id = t2.visitor_id ORDER BY t2.num_of_ticket DESC LIMIT 1 --- Match Fail medium pred: SELECT Avg(visit.Num_of_Ticket), Avg(visit.Num_of_Ticket) FROM visit medium gold: SELECT avg(num_of_ticket) , max(num_of_ticket) FROM visit --- Match Fail medium pred: SELECT Sum(visit.Total_spent) FROM visit WHERE visit.Total_spent = 'terminal' medium gold: SELECT sum(t2.Total_spent) FROM visitor AS t1 JOIN visit AS t2 ON t1.id = t2.visitor_id WHERE t1.Level_of_membership = 1 --- Match OK extra pred: SELECT visitor.Name FROM visitor JOIN visit JOIN museum WHERE museum.Open_Year < 'terminal' INTERSECT SELECT visitor.Name FROM visitor JOIN visit JOIN museum WHERE museum.Open_Year > 'terminal' extra gold: SELECT t1.name FROM visitor AS t1 JOIN visit AS t2 ON t1.id = t2.visitor_id JOIN museum AS t3 ON t3.Museum_ID = t2.Museum_ID WHERE t3.open_year < 2009 INTERSECT SELECT t1.name FROM visitor AS t1 JOIN visit AS t2 ON t1.id = t2.visitor_id JOIN museum AS t3 ON t3.Museum_ID = t2.Museum_ID WHERE t3.open_year > 2011 --- Match Fail extra pred: SELECT Count(*) FROM visit WHERE visit.Museum_ID NOT IN (SELECT museum.Museum_ID FROM museum WHERE museum.Open_Year > 'terminal') extra gold: SELECT count(*) FROM visitor WHERE id NOT IN (SELECT t2.visitor_id FROM museum AS t1 JOIN visit AS t2 ON t1.Museum_ID = t2.Museum_ID WHERE t1.open_year > 2010) --- Match OK medium pred: SELECT Count(*) FROM museum WHERE museum.Open_Year > 'terminal' OR museum.Open_Year < 'terminal' medium gold: SELECT count(*) FROM museum WHERE open_year > 2013 OR open_year < 2008 --- Match OK easy pred: SELECT Count(*) FROM players easy gold: SELECT count(*) FROM players --- Match OK easy pred: SELECT Count(*) FROM players easy gold: SELECT count(*) FROM players --- Match OK easy pred: SELECT Count(*) FROM matches easy gold: SELECT count(*) FROM matches --- Match OK easy pred: SELECT Count(*) FROM matches easy gold: SELECT count(*) FROM matches --- Match OK medium pred: SELECT players.first_name, players.birth_date FROM players WHERE players.country_code = 'terminal' medium gold: SELECT first_name , birth_date FROM players WHERE country_code = 'USA' --- Match Fail medium pred: SELECT players.first_name, players.birth_date FROM players medium gold: SELECT first_name , birth_date FROM players WHERE country_code = 'USA' --- Match Fail medium pred: SELECT Avg(matches.loser_age), Avg(matches.loser_age) FROM matches WHERE matches.year = 'terminal' medium gold: SELECT avg(loser_age) , avg(winner_age) FROM matches --- Match Fail medium pred: SELECT Avg(matches.loser_age), Avg(matches.loser_age) FROM players JOIN matches WHERE players.first_name = 'terminal' medium gold: SELECT avg(loser_age) , avg(winner_age) FROM matches --- Match Fail easy pred: SELECT Avg(matches.score) FROM matches easy gold: SELECT avg(winner_rank) FROM matches --- Match Fail easy pred: SELECT Avg(matches.score) FROM matches easy gold: SELECT avg(winner_rank) FROM matches --- Match Fail easy pred: SELECT rankings.ranking FROM rankings ORDER BY rankings.ranking Desc LIMIT 1 easy gold: SELECT min(loser_rank) FROM matches --- Match Fail easy pred: SELECT rankings.ranking FROM rankings ORDER BY rankings.ranking Asc LIMIT 1 easy gold: SELECT min(loser_rank) FROM matches --- Match OK easy pred: SELECT Count(DISTINCT players.country_code) FROM players easy gold: SELECT count(DISTINCT country_code) FROM players --- Match OK easy pred: SELECT Count(DISTINCT players.country_code) FROM players easy gold: SELECT count(DISTINCT country_code) FROM players --- Match Fail easy pred: SELECT Count(DISTINCT players.first_name) FROM players easy gold: SELECT count(DISTINCT loser_name) FROM matches --- Match Fail easy pred: SELECT Count(DISTINCT players.first_name) FROM players easy gold: SELECT count(DISTINCT loser_name) FROM matches --- Match Fail easy pred: SELECT players.first_name FROM players GROUP BY players.first_name HAVING Count(*) > 'terminal' easy gold: SELECT tourney_name FROM matches GROUP BY tourney_name HAVING count(*) > 10 --- Match Fail easy pred: SELECT players.first_name FROM players JOIN rankings GROUP BY players.first_name HAVING Count(*) >= 'terminal' easy gold: SELECT tourney_name FROM matches GROUP BY tourney_name HAVING count(*) > 10 --- Match Fail hard pred: SELECT players.first_name FROM players JOIN matches WHERE matches.year = 'terminal' INTERSECT SELECT players.first_name FROM players JOIN matches WHERE matches.year = 'terminal' hard gold: SELECT winner_name FROM matches WHERE YEAR = 2013 INTERSECT SELECT winner_name FROM matches WHERE YEAR = 2016 --- Match Fail hard pred: SELECT players.first_name FROM players JOIN matches WHERE matches.year = 'terminal' INTERSECT SELECT players.first_name FROM players JOIN matches WHERE matches.year = 'terminal' hard gold: SELECT winner_name FROM matches WHERE YEAR = 2013 INTERSECT SELECT winner_name FROM matches WHERE YEAR = 2016 --- Match Fail medium pred: SELECT Count(*) FROM players JOIN matches WHERE matches.year = 'terminal' OR matches.year = 'terminal' medium gold: SELECT count(*) FROM matches WHERE YEAR = 2013 OR YEAR = 2016 --- Match OK medium pred: SELECT Count(*) FROM matches WHERE matches.year = 'terminal' OR matches.year = 'terminal' medium gold: SELECT count(*) FROM matches WHERE YEAR = 2013 OR YEAR = 2016 --- Match OK extra pred: SELECT players.country_code, players.first_name FROM players JOIN matches WHERE matches.tourney_name = 'terminal' INTERSECT SELECT players.country_code, players.first_name FROM players JOIN matches WHERE matches.tourney_name = 'terminal' extra gold: SELECT T1.country_code , T1.first_name FROM players AS T1 JOIN matches AS T2 ON T1.player_id = T2.winner_id WHERE T2.tourney_name = 'WTA Championships' INTERSECT SELECT T1.country_code , T1.first_name FROM players AS T1 JOIN matches AS T2 ON T1.player_id = T2.winner_id WHERE T2.tourney_name = 'Australian Open' --- Match OK extra pred: SELECT players.first_name, players.country_code FROM players JOIN matches WHERE matches.tourney_name = 'terminal' INTERSECT SELECT players.first_name, players.country_code FROM players JOIN matches WHERE matches.tourney_name = 'terminal' extra gold: SELECT T1.country_code , T1.first_name FROM players AS T1 JOIN matches AS T2 ON T1.player_id = T2.winner_id WHERE T2.tourney_name = 'WTA Championships' INTERSECT SELECT T1.country_code , T1.first_name FROM players AS T1 JOIN matches AS T2 ON T1.player_id = T2.winner_id WHERE T2.tourney_name = 'Australian Open' --- Match OK medium pred: SELECT players.first_name, players.country_code FROM players ORDER BY players.birth_date Asc LIMIT 1 medium gold: SELECT first_name , country_code FROM players ORDER BY birth_date LIMIT 1 --- Match OK medium pred: SELECT players.first_name, players.country_code FROM players ORDER BY players.birth_date Asc LIMIT 1 medium gold: SELECT first_name , country_code FROM players ORDER BY birth_date LIMIT 1 --- Match OK medium pred: SELECT players.first_name, players.last_name FROM players ORDER BY players.birth_date Asc medium gold: SELECT first_name , last_name FROM players ORDER BY birth_date --- Match OK medium pred: SELECT players.first_name, players.last_name FROM players ORDER BY players.birth_date Asc medium gold: SELECT first_name , last_name FROM players ORDER BY birth_date --- Match Fail medium pred: SELECT players.first_name, players.last_name FROM players ORDER BY players.birth_date Asc medium gold: SELECT first_name , last_name FROM players WHERE hand = 'L' ORDER BY birth_date --- Match Fail medium pred: SELECT players.first_name, players.last_name FROM players WHERE players.first_name = 'terminal' ORDER BY players.birth_date Asc medium gold: SELECT first_name , last_name FROM players WHERE hand = 'L' ORDER BY birth_date --- Match Fail hard pred: SELECT players.first_name, players.country_code FROM players JOIN rankings GROUP BY rankings.player_id ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT T1.country_code , T1.first_name FROM players AS T1 JOIN rankings AS T2 ON T1.player_id = T2.player_id ORDER BY T2.tours DESC LIMIT 1 --- Match Fail hard pred: SELECT players.first_name, players.country_code FROM players JOIN rankings GROUP BY rankings.player_id ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT T1.country_code , T1.first_name FROM players AS T1 JOIN rankings AS T2 ON T1.player_id = T2.player_id ORDER BY T2.tours DESC LIMIT 1 --- Match OK hard pred: SELECT matches.year FROM matches GROUP BY matches.year ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT YEAR FROM matches GROUP BY YEAR ORDER BY count(*) DESC LIMIT 1 --- Match OK hard pred: SELECT matches.year FROM matches GROUP BY matches.year ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT YEAR FROM matches GROUP BY YEAR ORDER BY count(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT players.first_name, rankings.ranking FROM players JOIN rankings ORDER BY rankings.tours Desc LIMIT 1 hard gold: SELECT winner_name , winner_rank_points FROM matches GROUP BY winner_name ORDER BY count(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT players.first_name, rankings.ranking FROM players JOIN rankings ORDER BY rankings.ranking_points Desc LIMIT 1 hard gold: SELECT winner_name , winner_rank_points FROM matches GROUP BY winner_name ORDER BY count(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT matches.loser_name FROM matches WHERE matches.tourney_name = 'terminal' ORDER BY matches.score Desc LIMIT 1 hard gold: SELECT winner_name FROM matches WHERE tourney_name = 'Australian Open' ORDER BY winner_rank_points DESC LIMIT 1 --- Match Fail hard pred: SELECT players.first_name FROM players JOIN rankings JOIN matches WHERE matches.tourney_name = 'terminal' ORDER BY rankings.ranking_points Desc LIMIT 1 hard gold: SELECT winner_name FROM matches WHERE tourney_name = 'Australian Open' ORDER BY winner_rank_points DESC LIMIT 1 --- Match Fail medium pred: SELECT players.first_name, matches.loser_seed FROM players JOIN matches ORDER BY matches.loser_seed Desc LIMIT 1 medium gold: SELECT winner_name , loser_name FROM matches ORDER BY minutes DESC LIMIT 1 --- Match Fail medium pred: SELECT players.first_name, players.last_name FROM players JOIN matches ORDER BY matches.loser_hand Asc LIMIT 1 medium gold: SELECT winner_name , loser_name FROM matches ORDER BY minutes DESC LIMIT 1 --- Match Fail medium pred: SELECT Avg(matches.score), players.first_name FROM players JOIN matches GROUP BY players.first_name medium gold: SELECT avg(ranking) , T1.first_name FROM players AS T1 JOIN rankings AS T2 ON T1.player_id = T2.player_id GROUP BY T1.first_name --- Match OK medium pred: SELECT players.first_name, Avg(rankings.ranking) FROM players JOIN rankings GROUP BY players.first_name medium gold: SELECT avg(ranking) , T1.first_name FROM players AS T1 JOIN rankings AS T2 ON T1.player_id = T2.player_id GROUP BY T1.first_name --- Match OK medium pred: SELECT players.first_name, Sum(rankings.ranking_points) FROM rankings JOIN players GROUP BY players.first_name medium gold: SELECT sum(ranking_points) , T1.first_name FROM players AS T1 JOIN rankings AS T2 ON T1.player_id = T2.player_id GROUP BY T1.first_name --- Match Fail medium pred: SELECT players.first_name, Sum(rankings.ranking_points) FROM players JOIN rankings GROUP BY rankings.player_id medium gold: SELECT sum(ranking_points) , T1.first_name FROM players AS T1 JOIN rankings AS T2 ON T1.player_id = T2.player_id GROUP BY T1.first_name --- Match OK medium pred: SELECT players.country_code, Count(*) FROM players GROUP BY players.country_code medium gold: SELECT count(*) , country_code FROM players GROUP BY country_code --- Match OK medium pred: SELECT players.country_code, Count(*) FROM players GROUP BY players.country_code medium gold: SELECT count(*) , country_code FROM players GROUP BY country_code --- Match OK hard pred: SELECT players.country_code FROM players GROUP BY players.country_code ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT country_code FROM players GROUP BY country_code ORDER BY count(*) DESC LIMIT 1 --- Match OK hard pred: SELECT players.country_code FROM players GROUP BY players.country_code ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT country_code FROM players GROUP BY country_code ORDER BY count(*) DESC LIMIT 1 --- Match OK easy pred: SELECT players.country_code FROM players GROUP BY players.country_code HAVING Count(*) > 'terminal' easy gold: SELECT country_code FROM players GROUP BY country_code HAVING count(*) > 50 --- Match OK easy pred: SELECT players.country_code FROM players GROUP BY players.country_code HAVING Count(*) > 'terminal' easy gold: SELECT country_code FROM players GROUP BY country_code HAVING count(*) > 50 --- Match Fail medium pred: SELECT rankings.ranking, Count(*) FROM rankings GROUP BY rankings.ranking medium gold: SELECT sum(tours) , ranking_date FROM rankings GROUP BY ranking_date --- Match Fail medium pred: SELECT rankings.ranking_date, Sum(rankings.tours) FROM rankings GROUP BY rankings.ranking medium gold: SELECT sum(tours) , ranking_date FROM rankings GROUP BY ranking_date --- Match OK medium pred: SELECT matches.year, Count(*) FROM matches GROUP BY matches.year medium gold: SELECT count(*) , YEAR FROM matches GROUP BY YEAR --- Match OK medium pred: SELECT matches.year, Count(*) FROM matches GROUP BY matches.year medium gold: SELECT count(*) , YEAR FROM matches GROUP BY YEAR --- Match Fail medium pred: SELECT players.first_name, rankings.ranking FROM players JOIN rankings JOIN matches ORDER BY matches.loser_age Asc LIMIT 1 medium gold: SELECT DISTINCT winner_name , winner_rank FROM matches ORDER BY winner_age LIMIT 3 --- Match Fail medium pred: SELECT players.first_name, rankings.ranking FROM players JOIN matches ORDER BY matches.loser_age Asc LIMIT 1 medium gold: SELECT DISTINCT winner_name , winner_rank FROM matches ORDER BY winner_age LIMIT 3 --- Match Fail medium pred: SELECT Count(DISTINCT matches.winner_ht) FROM players JOIN matches WHERE players.first_name = 'terminal' medium gold: SELECT count(DISTINCT winner_name) FROM matches WHERE tourney_name = 'WTA Championships' AND winner_hand = 'L' --- Match Fail medium pred: SELECT Count(*) FROM matches WHERE matches.tourney_name = 'terminal' medium gold: SELECT count(DISTINCT winner_name) FROM matches WHERE tourney_name = 'WTA Championships' AND winner_hand = 'L' --- Match Fail hard pred: SELECT players.first_name, players.country_code, players.birth_date FROM players JOIN matches ORDER BY matches.score Desc LIMIT 1 hard gold: SELECT T1.first_name , T1.country_code , T1.birth_date FROM players AS T1 JOIN matches AS T2 ON T1.player_id = T2.winner_id ORDER BY T2.winner_rank_points DESC LIMIT 1 --- Match Fail hard pred: SELECT players.first_name, players.country_code, players.birth_date FROM players JOIN rankings ORDER BY rankings.ranking_points Desc LIMIT 1 hard gold: SELECT T1.first_name , T1.country_code , T1.birth_date FROM players AS T1 JOIN matches AS T2 ON T1.player_id = T2.winner_id ORDER BY T2.winner_rank_points DESC LIMIT 1 --- Match Fail medium pred: SELECT players.country_code, Count(*) FROM players GROUP BY players.country_code medium gold: SELECT count(*) , hand FROM players GROUP BY hand --- Match Fail medium pred: SELECT players.country_code, Count(*) FROM players GROUP BY players.country_code medium gold: SELECT count(*) , hand FROM players GROUP BY hand --- Match Fail easy pred: SELECT Count(*) FROM battle WHERE battle.name = 'terminal' easy gold: SELECT count(*) FROM ship WHERE disposition_of_ship = 'Captured' --- Match Fail medium pred: SELECT ship.name, ship.tonnage FROM ship ORDER BY ship.tonnage Desc medium gold: SELECT name , tonnage FROM ship ORDER BY name DESC --- Match Fail medium pred: SELECT battle.name, battle.date, battle.result FROM battle medium gold: SELECT name , date FROM battle --- Match Fail medium pred: SELECT Max(death.injured), Avg(death.injured) FROM death medium gold: SELECT max(killed) , min(killed) FROM death --- Match Fail easy pred: SELECT Avg(death.injured), death.caused_by_ship_id FROM death GROUP BY death.caused_by_ship_id easy gold: SELECT avg(injured) FROM death --- Match Fail medium pred: SELECT ship.location, death.injured FROM ship JOIN death WHERE ship.tonnage = 'terminal' medium gold: SELECT T1.killed , T1.injured FROM death AS T1 JOIN ship AS t2 ON T1.caused_by_ship_id = T2.id WHERE T2.tonnage = 't' --- Match OK medium pred: SELECT battle.name, battle.result FROM battle WHERE battle.bulgarian_commander != 'terminal' medium gold: SELECT name , RESULT FROM battle WHERE bulgarian_commander != 'Boril' --- Match Fail medium pred: SELECT DISTINCT ship.id, ship.name FROM battle JOIN ship WHERE ship.ship_type = 'terminal' medium gold: SELECT DISTINCT T1.id , T1.name FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle WHERE T2.ship_type = 'Brig' --- Match Fail hard pred: SELECT ship.id, ship.name FROM death JOIN ship GROUP BY ship.id HAVING Count(*) > 'terminal' hard gold: SELECT T1.id , T1.name FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle JOIN death AS T3 ON T2.id = T3.caused_by_ship_id GROUP BY T1.id HAVING sum(T3.killed) > 10 --- Match Fail extra pred: SELECT ship.id, ship.name FROM ship JOIN death GROUP BY ship.id ORDER BY Sum(death.injured) Desc LIMIT 1 extra gold: SELECT T2.id , T2.name FROM death AS T1 JOIN ship AS t2 ON T1.caused_by_ship_id = T2.id GROUP BY T2.id ORDER BY count(*) DESC LIMIT 1 --- Match Fail medium pred: SELECT DISTINCT battle.name FROM ship JOIN battle WHERE battle.latin_commander = 'terminal' INTERSECT SELECT DISTINCT battle.name FROM battle WHERE battle.latin_commander = 'terminal' medium gold: SELECT name FROM battle WHERE bulgarian_commander = 'Kaloyan' AND latin_commander = 'Baldwin I' --- Match Fail easy pred: SELECT Count(DISTINCT death.note) FROM death easy gold: SELECT count(DISTINCT RESULT) FROM battle --- Match Fail extra pred: SELECT Count(*) FROM ship WHERE ship.id NOT IN (SELECT death.caused_by_ship_id FROM death WHERE death.killed != 'terminal') extra gold: SELECT count(*) FROM battle WHERE id NOT IN ( SELECT lost_in_battle FROM ship WHERE tonnage = '225' ); --- Match OK extra pred: SELECT battle.name, battle.date FROM battle JOIN ship WHERE ship.name = 'terminal' INTERSECT SELECT battle.name, battle.date FROM battle JOIN ship WHERE ship.name = 'terminal' extra gold: SELECT T1.name , T1.date FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle WHERE T2.name = 'Lettice' INTERSECT SELECT T1.name , T1.date FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle WHERE T2.name = 'HMS Atalanta' --- Match Fail extra pred: SELECT battle.name, battle.result, battle.latin_commander FROM battle JOIN ship WHERE ship.disposition_of_ship != 'terminal' extra gold: SELECT name , RESULT , bulgarian_commander FROM battle EXCEPT SELECT T1.name , T1.result , T1.bulgarian_commander FROM battle AS T1 JOIN ship AS T2 ON T1.id = T2.lost_in_battle WHERE T2.location = 'English Channel' --- Match Fail medium pred: SELECT * FROM ship WHERE ship.location LIKE 'terminal' medium gold: SELECT note FROM death WHERE note LIKE '%East%' --- Match Fail medium pred: SELECT * FROM Addresses WHERE Sections.section_name = 'terminal' EXCEPT SELECT * FROM Students WHERE Sections.section_name = 'terminal' medium gold: SELECT line_1 , line_2 FROM addresses --- Match Fail medium pred: SELECT Min(*), Addresses.line_1 FROM Addresses medium gold: SELECT line_1 , line_2 FROM addresses --- Match OK easy pred: SELECT Count(*) FROM Courses easy gold: SELECT count(*) FROM Courses --- Match OK easy pred: SELECT Count(*) FROM Courses easy gold: SELECT count(*) FROM Courses --- Match OK easy pred: SELECT Courses.course_description FROM Courses WHERE Courses.course_name = 'terminal' easy gold: SELECT course_description FROM Courses WHERE course_name = 'math' --- Match OK easy pred: SELECT Courses.course_description FROM Courses WHERE Courses.course_name = 'terminal' easy gold: SELECT course_description FROM Courses WHERE course_name = 'math' --- Match OK easy pred: SELECT Addresses.zip_postcode FROM Addresses WHERE Addresses.city = 'terminal' easy gold: SELECT zip_postcode FROM Addresses WHERE city = 'Port Chelsea' --- Match OK easy pred: SELECT Addresses.zip_postcode FROM Addresses WHERE Addresses.city = 'terminal' easy gold: SELECT zip_postcode FROM Addresses WHERE city = 'Port Chelsea' --- Match Fail extra pred: SELECT Departments.department_name, Departments.department_id FROM Departments JOIN Degree_Programs GROUP BY Departments.department_id, Departments.department_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T2.department_name , T1.department_id FROM Degree_Programs AS T1 JOIN Departments AS T2 ON T1.department_id = T2.department_id GROUP BY T1.department_id ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT Departments.department_name, Degree_Programs.department_id FROM Departments JOIN Degree_Programs GROUP BY Degree_Programs.department_id ORDER BY Count(*) Desc LIMIT 1 extra gold: select t2.department_name , t1.department_id from degree_programs as t1 join departments as t2 on t1.department_id = t2.department_id group by t1.department_id order by count(*) desc limit 1 --- Match Fail easy pred: SELECT Count(DISTINCT Departments.department_name) FROM Departments easy gold: SELECT count(DISTINCT department_id) FROM Degree_Programs --- Match Fail easy pred: SELECT Count(DISTINCT Departments.department_name) FROM Departments easy gold: SELECT count(DISTINCT department_id) FROM Degree_Programs --- Match OK easy pred: SELECT Count(DISTINCT Degree_Programs.degree_summary_name) FROM Degree_Programs easy gold: SELECT count(DISTINCT degree_summary_name) FROM Degree_Programs --- Match Fail easy pred: SELECT Count(DISTINCT Courses.course_name) FROM Courses easy gold: SELECT count(DISTINCT degree_summary_name) FROM Degree_Programs --- Match Fail medium pred: SELECT Count(*) FROM Courses JOIN Degree_Programs JOIN Departments WHERE Departments.department_name = 'terminal' medium gold: SELECT count(*) FROM Departments AS T1 JOIN Degree_Programs AS T2 ON T1.department_id = T2.department_id WHERE T1.department_name = 'engineer' --- Match OK medium pred: SELECT Count(*) FROM Departments JOIN Degree_Programs WHERE Departments.department_name = 'terminal' medium gold: SELECT count(*) FROM Departments AS T1 JOIN Degree_Programs AS T2 ON T1.department_id = T2.department_id WHERE T1.department_name = 'engineer' --- Match OK medium pred: SELECT Sections.section_name, Sections.section_description FROM Sections medium gold: SELECT section_name , section_description FROM Sections --- Match OK medium pred: SELECT Sections.section_name, Sections.section_description FROM Sections medium gold: SELECT section_name , section_description FROM Sections --- Match Fail medium pred: SELECT Courses.course_name, Courses.course_id FROM Courses JOIN Student_Enrolment_Courses GROUP BY Courses.course_id HAVING Count(*) <= 'terminal' medium gold: SELECT T1.course_name , T1.course_id FROM Courses AS T1 JOIN Sections AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id HAVING count(*) <= 2 --- Match Fail medium pred: SELECT Courses.course_name, Courses.course_id FROM Courses JOIN Sections GROUP BY Sections.course_id HAVING Count(*) < 'terminal' medium gold: SELECT T1.course_name , T1.course_id FROM Courses AS T1 JOIN Sections AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_id HAVING count(*) <= 2 --- Match Fail easy pred: SELECT Semesters.semester_id FROM Semesters ORDER BY Semesters.semester_name Asc easy gold: SELECT section_name FROM Sections ORDER BY section_name DESC --- Match Fail easy pred: SELECT Addresses.state_province_county FROM Addresses ORDER BY Addresses.state_province_county Asc easy gold: SELECT section_name FROM Sections ORDER BY section_name DESC --- Match Fail extra pred: SELECT Student_Enrolment.semester_id, Student_Enrolment.degree_program_id FROM Student_Enrolment JOIN Student_Enrolment_Courses GROUP BY Student_Enrolment.semester_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.semester_name , T1.semester_id FROM Semesters AS T1 JOIN Student_Enrolment AS T2 ON T1.semester_id = T2.semester_id GROUP BY T1.semester_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Student_Enrolment.degree_program_id, Student_Enrolment.degree_program_id FROM Students JOIN Student_Enrolment GROUP BY Student_Enrolment.degree_program_id, Student_Enrolment.degree_program_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.semester_name , T1.semester_id FROM Semesters AS T1 JOIN Student_Enrolment AS T2 ON T1.semester_id = T2.semester_id GROUP BY T1.semester_id ORDER BY count(*) DESC LIMIT 1 --- Match OK medium pred: SELECT Departments.department_description FROM Departments WHERE Departments.department_name LIKE 'terminal' medium gold: SELECT department_description FROM Departments WHERE department_name LIKE '%computer%' --- Match OK medium pred: SELECT Departments.department_description FROM Departments WHERE Departments.department_name LIKE 'terminal' medium gold: SELECT department_description FROM Departments WHERE department_name LIKE '%computer%' --- Match Fail medium pred: SELECT Students.first_name, Students.middle_name, Students.middle_name, Students.last_name FROM Students JOIN Student_Enrolment WHERE Student_Enrolment.semester_id = 'terminal' INTERSECT SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students JOIN Student_Enrolment WHERE Student_Enrolment.semester_id = 'terminal' medium gold: SELECT T1.first_name , T1.middle_name , T1.last_name , T1.student_id FROM Students AS T1 JOIN Student_Enrolment AS T2 ON T1.student_id = T2.student_id GROUP BY T1.student_id HAVING count(*) = 2 --- Match Fail medium pred: SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students JOIN Student_Enrolment WHERE Student_Enrolment_Courses.course_id = 'terminal' INTERSECT SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students JOIN Student_Enrolment WHERE Student_Enrolment_Courses.course_id = 'terminal' medium gold: SELECT T1.first_name , T1.middle_name , T1.last_name , T1.student_id FROM Students AS T1 JOIN Student_Enrolment AS T2 ON T1.student_id = T2.student_id GROUP BY T1.student_id HAVING count(*) = 2 --- Match Fail hard pred: SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students JOIN Student_Enrolment JOIN Courses WHERE Courses.course_name = 'terminal' hard gold: SELECT DISTINCT T1.first_name , T1.middle_name , T1.last_name FROM Students AS T1 JOIN Student_Enrolment AS T2 ON T1.student_id = T2.student_id JOIN Degree_Programs AS T3 ON T2.degree_program_id = T3.degree_program_id WHERE T3.degree_summary_name = 'Bachelor' --- Match Fail hard pred: SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students JOIN Student_Enrolment JOIN Courses WHERE Courses.course_name = 'terminal' hard gold: SELECT DISTINCT T1.first_name , T1.middle_name , T1.last_name FROM Students AS T1 JOIN Student_Enrolment AS T2 ON T1.student_id = T2.student_id JOIN Degree_Programs AS T3 ON T2.degree_program_id = T3.degree_program_id WHERE T3.degree_summary_name = 'Bachelor' --- Match Fail extra pred: SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses GROUP BY Courses.course_name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.degree_summary_name FROM Degree_Programs AS T1 JOIN Student_Enrolment AS T2 ON T1.degree_program_id = T2.degree_program_id GROUP BY T1.degree_summary_name ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Students.first_name FROM Students JOIN Student_Enrolment GROUP BY Student_Enrolment.degree_program_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.degree_summary_name FROM Degree_Programs AS T1 JOIN Student_Enrolment AS T2 ON T1.degree_program_id = T2.degree_program_id GROUP BY T1.degree_summary_name ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Student_Enrolment_Courses.course_id, Courses.other_details FROM Courses JOIN Student_Enrolment_Courses GROUP BY Student_Enrolment_Courses.course_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.degree_program_id , T1.degree_summary_name FROM Degree_Programs AS T1 JOIN Student_Enrolment AS T2 ON T1.degree_program_id = T2.degree_program_id GROUP BY T1.degree_program_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Student_Enrolment_Courses.course_id, Courses.other_details FROM Courses JOIN Student_Enrolment_Courses GROUP BY Student_Enrolment_Courses.course_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.degree_program_id , T1.degree_summary_name FROM Degree_Programs AS T1 JOIN Student_Enrolment AS T2 ON T1.degree_program_id = T2.degree_program_id GROUP BY T1.degree_program_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Students.student_id, Students.middle_name, Students.middle_name, Students.last_name FROM Student_Enrolment JOIN Students GROUP BY Student_Enrolment.student_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.student_id , T1.first_name , T1.middle_name , T1.last_name , count(*) , T1.student_id FROM Students AS T1 JOIN Student_Enrolment AS T2 ON T1.student_id = T2.student_id GROUP BY T1.student_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students JOIN Student_Enrolment GROUP BY Student_Enrolment.student_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.student_id , T1.first_name , T1.middle_name , T1.last_name , count(*) , T1.student_id FROM Students AS T1 JOIN Student_Enrolment AS T2 ON T1.student_id = T2.student_id GROUP BY T1.student_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT Courses.course_name FROM Courses EXCEPT SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses hard gold: SELECT semester_name FROM Semesters WHERE semester_id NOT IN( SELECT semester_id FROM Student_Enrolment ) --- Match Fail hard pred: SELECT Semesters.semester_name FROM Semesters EXCEPT SELECT Semesters.semester_name FROM Semesters JOIN Student_Enrolment hard gold: SELECT semester_name FROM Semesters WHERE semester_id NOT IN( SELECT semester_id FROM Student_Enrolment ) --- Match OK easy pred: SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses easy gold: SELECT DISTINCT T1.course_name FROM Courses AS T1 JOIN Student_Enrolment_Courses AS T2 ON T1.course_id = T2.course_id --- Match Fail easy pred: SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses GROUP BY Courses.course_name HAVING Count(*) = 'terminal' easy gold: SELECT DISTINCT T1.course_name FROM Courses AS T1 JOIN Student_Enrolment_Courses AS T2 ON T1.course_id = T2.course_id --- Match OK extra pred: SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses GROUP BY Courses.course_name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.course_name FROM Courses AS T1 JOIN Student_Enrolment_Courses AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_name ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT Courses.course_name FROM Courses JOIN Student_Enrolment_Courses GROUP BY Courses.course_name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.course_name FROM Courses AS T1 JOIN Student_Enrolment_Courses AS T2 ON T1.course_id = T2.course_id GROUP BY T1.course_name ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Students.last_name FROM Students WHERE Students.student_id IN (SELECT Student_Enrolment.student_id FROM Addresses WHERE Addresses.state_province_county = 'terminal' EXCEPT SELECT Student_Enrolment.student_id FROM Addresses JOIN Student_Enrolment WHERE Addresses.state_province_county = 'terminal') extra gold: SELECT T1.last_name FROM Students AS T1 JOIN Addresses AS T2 ON T1.current_address_id = T2.address_id WHERE T2.state_province_county = 'NorthCarolina' EXCEPT SELECT DISTINCT T3.last_name FROM Students AS T3 JOIN Student_Enrolment AS T4 ON T3.student_id = T4.student_id --- Match Fail extra pred: SELECT Students.last_name FROM Students WHERE Students.student_id IN (SELECT Student_Enrolment.student_id FROM Addresses WHERE Addresses.state_province_county = 'terminal') extra gold: SELECT T1.last_name FROM Students AS T1 JOIN Addresses AS T2 ON T1.current_address_id = T2.address_id WHERE T2.state_province_county = 'NorthCarolina' EXCEPT SELECT DISTINCT T3.last_name FROM Students AS T3 JOIN Student_Enrolment AS T4 ON T3.student_id = T4.student_id --- Match OK medium pred: SELECT Transcripts.transcript_date, Transcript_Contents.transcript_id FROM Transcripts JOIN Transcript_Contents GROUP BY Transcript_Contents.transcript_id HAVING Count(*) >= 'terminal' medium gold: SELECT T2.transcript_date , T1.transcript_id FROM Transcript_Contents AS T1 JOIN Transcripts AS T2 ON T1.transcript_id = T2.transcript_id GROUP BY T1.transcript_id HAVING count(*) >= 2 --- Match OK medium pred: SELECT Transcripts.transcript_date, Transcripts.transcript_id FROM Transcripts JOIN Transcript_Contents GROUP BY Transcripts.transcript_id HAVING Count(*) >= 'terminal' medium gold: SELECT T2.transcript_date , T1.transcript_id FROM Transcript_Contents AS T1 JOIN Transcripts AS T2 ON T1.transcript_id = T2.transcript_id GROUP BY T1.transcript_id HAVING count(*) >= 2 --- Match OK medium pred: SELECT Students.cell_mobile_number FROM Students WHERE Students.first_name = 'terminal' AND Students.last_name = 'terminal' medium gold: SELECT cell_mobile_number FROM Students WHERE first_name = 'Timmothy' AND last_name = 'Ward' --- Match OK medium pred: SELECT Students.cell_mobile_number FROM Students WHERE Students.first_name = 'terminal' AND Students.last_name = 'terminal' medium gold: select cell_mobile_number from students where first_name = 'timmothy' and last_name = 'ward' --- Match Fail medium pred: SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students ORDER BY Students.first_name Asc LIMIT 1 medium gold: SELECT first_name , middle_name , last_name FROM Students ORDER BY date_first_registered ASC LIMIT 1 --- Match Fail medium pred: SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students ORDER BY Students.first_name Asc LIMIT 1 medium gold: SELECT first_name , middle_name , last_name FROM Students ORDER BY date_first_registered ASC LIMIT 1 --- Match Fail medium pred: SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students ORDER BY Students.date_first_registered Asc LIMIT 1 medium gold: SELECT first_name , middle_name , last_name FROM Students ORDER BY date_left ASC LIMIT 1 --- Match Fail medium pred: SELECT Students.first_name, Students.middle_name, Students.last_name FROM Students WHERE Students.student_id = 'terminal' medium gold: SELECT first_name , middle_name , last_name FROM Students ORDER BY date_left ASC LIMIT 1 --- Match Fail easy pred: SELECT Students.first_name FROM Students easy gold: SELECT first_name FROM Students WHERE current_address_id != permanent_address_id --- Match Fail easy pred: SELECT Students.first_name FROM Students ORDER BY Students.email_address Asc LIMIT 1 easy gold: SELECT first_name FROM Students WHERE current_address_id != permanent_address_id --- Match Fail extra pred: SELECT Students.email_address, Count(*) FROM Students JOIN Student_Enrolment GROUP BY Students.email_address ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.address_id , T1.line_1 , T1.line_2 FROM Addresses AS T1 JOIN Students AS T2 ON T1.address_id = T2.current_address_id GROUP BY T1.address_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Students.current_address_id, Addresses.line_3, Students.permanent_address_id FROM Students JOIN Addresses GROUP BY Students.current_address_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.address_id , T1.line_1 , T1.line_2 FROM Addresses AS T1 JOIN Students AS T2 ON T1.address_id = T2.current_address_id GROUP BY T1.address_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail easy pred: SELECT Avg(Students.date_first_registered) FROM Students easy gold: SELECT avg(transcript_date) FROM Transcripts --- Match OK easy pred: SELECT Avg(Transcripts.transcript_date) FROM Transcripts easy gold: SELECT avg(transcript_date) FROM Transcripts --- Match OK medium pred: SELECT Transcripts.transcript_date, Transcripts.other_details FROM Transcripts ORDER BY Transcripts.transcript_date Asc LIMIT 1 medium gold: SELECT transcript_date , other_details FROM Transcripts ORDER BY transcript_date ASC LIMIT 1 --- Match Fail medium pred: SELECT Transcripts.transcript_date, Transcripts.other_details FROM Transcripts ORDER BY Transcripts.other_details Asc LIMIT 1 medium gold: SELECT transcript_date , other_details FROM Transcripts ORDER BY transcript_date ASC LIMIT 1 --- Match OK easy pred: SELECT Count(*) FROM Transcripts easy gold: SELECT count(*) FROM Transcripts --- Match OK easy pred: SELECT Count(*) FROM Transcripts easy gold: SELECT count(*) FROM Transcripts --- Match OK medium pred: SELECT Transcripts.transcript_date FROM Transcripts ORDER BY Transcripts.transcript_date Desc LIMIT 1 medium gold: SELECT transcript_date FROM Transcripts ORDER BY transcript_date DESC LIMIT 1 --- Match Fail medium pred: SELECT Transcripts.transcript_id FROM Transcripts ORDER BY Transcripts.transcript_date Desc LIMIT 1 medium gold: SELECT transcript_date FROM Transcripts ORDER BY transcript_date DESC LIMIT 1 --- Match Fail hard pred: SELECT Count(*), Transcript_Contents.transcript_id FROM Courses JOIN Transcript_Contents GROUP BY Transcript_Contents.transcript_id ORDER BY Count(*) Desc hard gold: SELECT count(*) , student_course_id FROM Transcript_Contents GROUP BY student_course_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT Student_Enrolment_Courses.course_id, Count(*) FROM Courses JOIN Sections GROUP BY Transcript_Contents.transcript_id ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT count(*) , student_course_id FROM Transcript_Contents GROUP BY student_course_id ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT Transcript_Contents.transcript_id, Transcripts.transcript_date FROM Transcript_Contents JOIN Transcripts GROUP BY Transcript_Contents.transcript_id ORDER BY Count(*) Asc LIMIT 1 extra gold: SELECT T2.transcript_date , T1.transcript_id FROM Transcript_Contents AS T1 JOIN Transcripts AS T2 ON T1.transcript_id = T2.transcript_id GROUP BY T1.transcript_id ORDER BY count(*) ASC LIMIT 1 --- Match OK extra pred: SELECT Transcripts.transcript_date, Transcripts.transcript_id FROM Transcripts JOIN Transcript_Contents GROUP BY Transcript_Contents.transcript_id ORDER BY Count(*) Asc LIMIT 1 extra gold: SELECT T2.transcript_date , T1.transcript_id FROM Transcript_Contents AS T1 JOIN Transcripts AS T2 ON T1.transcript_id = T2.transcript_id GROUP BY T1.transcript_id ORDER BY count(*) ASC LIMIT 1 --- Match Fail extra pred: SELECT Student_Enrolment.semester_id FROM Courses JOIN Student_Enrolment_Courses WHERE Courses.course_name = 'terminal' INTERSECT SELECT Student_Enrolment.semester_id FROM Courses JOIN Student_Enrolment_Courses WHERE Courses.course_name = 'terminal' extra gold: SELECT DISTINCT T2.semester_id FROM Degree_Programs AS T1 JOIN Student_Enrolment AS T2 ON T1.degree_program_id = T2.degree_program_id WHERE degree_summary_name = 'Master' INTERSECT SELECT DISTINCT T2.semester_id FROM Degree_Programs AS T1 JOIN Student_Enrolment AS T2 ON T1.degree_program_id = T2.degree_program_id WHERE degree_summary_name = 'Bachelor' --- Match Fail extra pred: SELECT Student_Enrolment.semester_id FROM Student_Enrolment WHERE Student_Enrolment.student_id = 'terminal' INTERSECT SELECT Student_Enrolment.semester_id FROM Student_Enrolment WHERE Student_Enrolment.student_id = 'terminal' extra gold: SELECT DISTINCT T2.semester_id FROM Degree_Programs AS T1 JOIN Student_Enrolment AS T2 ON T1.degree_program_id = T2.degree_program_id WHERE degree_summary_name = 'Master' INTERSECT SELECT DISTINCT T2.semester_id FROM Degree_Programs AS T1 JOIN Student_Enrolment AS T2 ON T1.degree_program_id = T2.degree_program_id WHERE degree_summary_name = 'Bachelor' --- Match OK easy pred: SELECT Count(DISTINCT Students.current_address_id) FROM Students easy gold: SELECT count(DISTINCT current_address_id) FROM Students --- Match Fail easy pred: SELECT DISTINCT Students.email_address FROM Students JOIN Addresses easy gold: SELECT count(DISTINCT current_address_id) FROM Students --- Match Fail easy pred: SELECT * FROM Student_Enrolment JOIN Semesters ORDER BY Semesters.semester_name Asc easy gold: SELECT other_student_details FROM Students ORDER BY other_student_details DESC --- Match Fail easy pred: SELECT Student_Enrolment.other_details FROM Student_Enrolment ORDER BY Student_Enrolment.other_details Asc easy gold: SELECT other_student_details FROM Students ORDER BY other_student_details DESC --- Match Fail easy pred: SELECT Addresses.state_province_county FROM Addresses JOIN Sections WHERE Sections.section_name = 'terminal' easy gold: SELECT section_description FROM Sections WHERE section_name = 'h' --- Match OK easy pred: SELECT Sections.section_description FROM Sections WHERE Sections.section_name = 'terminal' easy gold: SELECT section_description FROM Sections WHERE section_name = 'h' --- Match OK hard pred: SELECT Students.first_name FROM Students JOIN Addresses WHERE Addresses.country = 'terminal' OR Students.cell_mobile_number = 'terminal' hard gold: select t1.first_name from students as t1 join addresses as t2 on t1.permanent_address_id = t2.address_id where t2.country = 'haiti' or t1.cell_mobile_number = '09700166582' --- Match OK hard pred: SELECT Students.first_name FROM Students JOIN Addresses WHERE Addresses.country = 'terminal' OR Students.cell_mobile_number = 'terminal' hard gold: select t1.first_name from students as t1 join addresses as t2 on t1.permanent_address_id = t2.address_id where t2.country = 'haiti' or t1.cell_mobile_number = '09700166582' --- Match OK easy pred: SELECT Cartoon.Title FROM Cartoon ORDER BY Cartoon.Title Asc easy gold: SELECT Title FROM Cartoon ORDER BY title --- Match OK easy pred: SELECT Cartoon.Title FROM Cartoon ORDER BY Cartoon.Title Asc easy gold: SELECT Title FROM Cartoon ORDER BY title --- Match OK easy pred: SELECT Cartoon.Title FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' easy gold: SELECT Title FROM Cartoon WHERE Directed_by = "Ben Jones"; --- Match OK easy pred: SELECT Cartoon.Title FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' easy gold: SELECT Title FROM Cartoon WHERE Directed_by = "Ben Jones"; --- Match Fail easy pred: SELECT Count(DISTINCT Cartoon.Title) FROM Cartoon WHERE Cartoon.Written_by = 'terminal' easy gold: SELECT count(*) FROM Cartoon WHERE Written_by = "Joseph Kuhr"; --- Match Fail easy pred: SELECT Count(DISTINCT Cartoon.Title) FROM Cartoon WHERE Cartoon.Written_by = 'terminal' easy gold: SELECT count(*) FROM Cartoon WHERE Written_by = "Joseph Kuhr"; --- Match Fail medium pred: SELECT Cartoon.Title, Cartoon.Directed_by FROM TV_series JOIN Cartoon ORDER BY TV_series.Air_Date Asc medium gold: SELECT title , Directed_by FROM Cartoon ORDER BY Original_air_date --- Match Fail medium pred: SELECT Cartoon.Title, Cartoon.Directed_by FROM Cartoon JOIN TV_series ORDER BY TV_series.Air_Date Asc medium gold: SELECT title , Directed_by FROM Cartoon ORDER BY Original_air_date --- Match OK medium pred: SELECT Cartoon.Title FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' OR Cartoon.Directed_by = 'terminal' medium gold: SELECT Title FROM Cartoon WHERE Directed_by = "Ben Jones" OR Directed_by = "Brandon Vietti"; --- Match OK medium pred: SELECT Cartoon.Title FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' OR Cartoon.Directed_by = 'terminal' medium gold: SELECT Title FROM Cartoon WHERE Directed_by = "Ben Jones" OR Directed_by = "Brandon Vietti"; --- Match OK hard pred: SELECT TV_Channel.Country, Count(*) FROM TV_Channel GROUP BY TV_Channel.Country ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT Country , count(*) FROM TV_Channel GROUP BY Country ORDER BY count(*) DESC LIMIT 1; --- Match OK hard pred: SELECT TV_Channel.Country, Count(*) FROM TV_Channel GROUP BY TV_Channel.Country ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT Country , count(*) FROM TV_Channel GROUP BY Country ORDER BY count(*) DESC LIMIT 1; --- Match OK medium pred: SELECT Count(DISTINCT TV_Channel.series_name), Count(DISTINCT TV_Channel.Content) FROM TV_Channel medium gold: SELECT count(DISTINCT series_name) , count(DISTINCT content) FROM TV_Channel; --- Match Fail medium pred: SELECT Count(DISTINCT TV_Channel.Content), Count(DISTINCT TV_Channel.Content) FROM TV_Channel medium gold: SELECT count(DISTINCT series_name) , count(DISTINCT content) FROM TV_Channel; --- Match OK easy pred: SELECT TV_Channel.Content FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' easy gold: SELECT Content FROM TV_Channel WHERE series_name = "Sky Radio"; --- Match OK easy pred: SELECT TV_Channel.Content FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' easy gold: SELECT Content FROM TV_Channel WHERE series_name = "Sky Radio"; --- Match Fail easy pred: SELECT TV_Channel.Hight_definition_TV FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' easy gold: SELECT Package_Option FROM TV_Channel WHERE series_name = "Sky Radio"; --- Match Fail easy pred: SELECT TV_Channel.Content FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' easy gold: SELECT Package_Option FROM TV_Channel WHERE series_name = "Sky Radio"; --- Match OK easy pred: SELECT Count(*) FROM TV_Channel WHERE TV_Channel.Language = 'terminal' easy gold: SELECT count(*) FROM TV_Channel WHERE LANGUAGE = "English"; --- Match OK easy pred: SELECT Count(*) FROM TV_Channel WHERE TV_Channel.Language = 'terminal' easy gold: SELECT count(*) FROM TV_Channel WHERE LANGUAGE = "English"; --- Match OK hard pred: SELECT TV_Channel.Language, Count(*) FROM TV_Channel GROUP BY TV_Channel.Language ORDER BY Count(*) Asc LIMIT 1 hard gold: SELECT LANGUAGE , count(*) FROM TV_Channel GROUP BY LANGUAGE ORDER BY count(*) ASC LIMIT 1; --- Match OK hard pred: SELECT TV_Channel.Language, Count(*) FROM TV_Channel GROUP BY TV_Channel.Language ORDER BY Count(*) Asc LIMIT 1 hard gold: SELECT LANGUAGE , count(*) FROM TV_Channel GROUP BY LANGUAGE ORDER BY count(*) ASC LIMIT 1; --- Match OK medium pred: SELECT TV_Channel.Language, Count(*) FROM TV_Channel GROUP BY TV_Channel.Language medium gold: SELECT LANGUAGE , count(*) FROM TV_Channel GROUP BY LANGUAGE --- Match OK medium pred: SELECT TV_Channel.Language, Count(*) FROM TV_Channel GROUP BY TV_Channel.Language medium gold: SELECT LANGUAGE , count(*) FROM TV_Channel GROUP BY LANGUAGE --- Match Fail medium pred: SELECT TV_Channel.Hight_definition_TV FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' medium gold: SELECT T1.series_name FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T2.Title = "The Rise of the Blue Beetle!"; --- Match Fail medium pred: SELECT TV_series.Episode FROM TV_series JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' medium gold: SELECT T1.series_name FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T2.Title = "The Rise of the Blue Beetle!"; --- Match OK medium pred: SELECT Cartoon.Title FROM Cartoon JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' medium gold: SELECT T2.Title FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio"; --- Match OK medium pred: SELECT Cartoon.Title FROM Cartoon JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' medium gold: SELECT T2.Title FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio"; --- Match Fail easy pred: SELECT TV_Channel.Hight_definition_TV FROM TV_series JOIN TV_Channel ORDER BY TV_series.Rating Asc easy gold: SELECT Episode FROM TV_series ORDER BY rating --- Match Fail easy pred: SELECT TV_series.Rating FROM TV_series ORDER BY TV_series.Rating Asc easy gold: SELECT Episode FROM TV_series ORDER BY rating --- Match Fail medium pred: SELECT TV_series.Viewers_m, TV_series.Rating FROM TV_series ORDER BY TV_series.Rating Desc LIMIT 1 medium gold: SELECT Episode , Rating FROM TV_series ORDER BY Rating DESC LIMIT 3; --- Match Fail medium pred: SELECT TV_series.Rating, TV_series.Rating FROM TV_series ORDER BY TV_series.Rating Asc LIMIT 1 medium gold: SELECT Episode , Rating FROM TV_series ORDER BY Rating DESC LIMIT 3; --- Match Fail medium pred: SELECT Min(TV_series.Rating), Min(TV_series.Rating) FROM TV_series JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' medium gold: SELECT max(SHARE) , min(SHARE) FROM TV_series; --- Match Fail medium pred: SELECT Max(TV_series.Rating), Min(TV_series.Rating) FROM TV_series medium gold: SELECT max(SHARE) , min(SHARE) FROM TV_series; --- Match Fail easy pred: SELECT TV_series.Air_Date FROM TV_series JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' easy gold: SELECT Air_Date FROM TV_series WHERE Episode = "A Love of a Lifetime"; --- Match OK easy pred: SELECT TV_series.Air_Date FROM TV_series WHERE TV_series.Episode = 'terminal' easy gold: SELECT Air_Date FROM TV_series WHERE Episode = "A Love of a Lifetime"; --- Match Fail easy pred: SELECT TV_series.Weekly_Rank FROM TV_series JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' AND TV_Channel.series_name = 'terminal' easy gold: SELECT Weekly_Rank FROM TV_series WHERE Episode = "A Love of a Lifetime"; --- Match Fail easy pred: SELECT TV_series.Rating FROM TV_series WHERE TV_series.Episode = 'terminal' easy gold: SELECT Weekly_Rank FROM TV_series WHERE Episode = "A Love of a Lifetime"; --- Match Fail medium pred: SELECT TV_Channel.Hight_definition_TV FROM TV_series JOIN TV_Channel WHERE TV_series.Episode = 'terminal' medium gold: SELECT T1.series_name FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T2.Episode = "A Love of a Lifetime"; --- Match OK medium pred: SELECT TV_Channel.series_name FROM TV_series JOIN TV_Channel WHERE TV_series.Episode = 'terminal' medium gold: SELECT T1.series_name FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T2.Episode = "A Love of a Lifetime"; --- Match Fail medium pred: SELECT TV_Channel.Hight_definition_TV FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' medium gold: SELECT T2.Episode FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio"; --- Match Fail medium pred: SELECT TV_Channel.Hight_definition_TV FROM TV_Channel WHERE TV_Channel.series_name = 'terminal' medium gold: SELECT T2.Episode FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio"; --- Match OK medium pred: SELECT Cartoon.Directed_by, Count(*) FROM Cartoon GROUP BY Cartoon.Directed_by medium gold: SELECT count(*) , Directed_by FROM cartoon GROUP BY Directed_by --- Match OK medium pred: SELECT Cartoon.Directed_by, Count(*) FROM Cartoon GROUP BY Cartoon.Directed_by medium gold: SELECT count(*) , Directed_by FROM cartoon GROUP BY Directed_by --- Match Fail medium pred: SELECT Cartoon.Production_code, Cartoon.Channel FROM Cartoon JOIN TV_series ORDER BY TV_series.Air_Date Desc LIMIT 1 medium gold: select production_code , channel from cartoon order by original_air_date desc limit 1 --- Match OK medium pred: SELECT Cartoon.Production_code, Cartoon.Channel FROM Cartoon ORDER BY Cartoon.Original_air_date Desc LIMIT 1 medium gold: select production_code , channel from cartoon order by original_air_date desc limit 1 --- Match Fail medium pred: SELECT TV_series.id, TV_series.Episode FROM TV_series JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' medium gold: SELECT package_option , series_name FROM TV_Channel WHERE hight_definition_TV = "yes" --- Match Fail medium pred: SELECT TV_series.Episode, TV_series.Episode FROM TV_series JOIN TV_Channel WHERE TV_Channel.series_name = 'terminal' medium gold: SELECT package_option , series_name FROM TV_Channel WHERE hight_definition_TV = "yes" --- Match OK medium pred: SELECT DISTINCT TV_Channel.Country FROM Cartoon JOIN TV_Channel WHERE Cartoon.Written_by = 'terminal' medium gold: SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by = 'Todd Casey' --- Match OK medium pred: SELECT TV_Channel.Country FROM Cartoon JOIN TV_Channel WHERE Cartoon.Written_by = 'terminal' medium gold: SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by = 'Todd Casey' --- Match Fail hard pred: SELECT TV_Channel.Hight_definition_TV FROM TV_Channel EXCEPT SELECT Cartoon.Channel FROM Cartoon WHERE Cartoon.Written_by = 'terminal' hard gold: SELECT country FROM TV_Channel EXCEPT SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by = 'Todd Casey' --- Match OK hard pred: SELECT TV_Channel.Country FROM TV_Channel EXCEPT SELECT TV_Channel.Country FROM Cartoon JOIN TV_Channel WHERE Cartoon.Written_by = 'terminal' hard gold: SELECT country FROM TV_Channel EXCEPT SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by = 'Todd Casey' --- Match Fail extra pred: SELECT TV_Channel.series_name, TV_Channel.Country FROM Cartoon JOIN TV_Channel WHERE Cartoon.Directed_by = 'terminal' AND Cartoon.Directed_by = 'terminal' extra gold: SELECT T1.series_name , T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by = 'Michael Chang' INTERSECT SELECT T1.series_name , T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by = 'Ben Jones' --- Match OK extra pred: SELECT TV_Channel.series_name, TV_Channel.Country FROM Cartoon JOIN TV_Channel WHERE Cartoon.Directed_by = 'terminal' INTERSECT SELECT TV_Channel.series_name, TV_Channel.Country FROM Cartoon JOIN TV_Channel WHERE Cartoon.Directed_by = 'terminal' extra gold: SELECT T1.series_name , T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by = 'Michael Chang' INTERSECT SELECT T1.series_name , T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by = 'Ben Jones' --- Match Fail medium pred: SELECT TV_Channel.Hight_definition_TV, TV_Channel.Pixel_aspect_ratio_PAR FROM TV_Channel EXCEPT SELECT TV_Channel.Hight_definition_TV, TV_Channel.Pixel_aspect_ratio_PAR FROM TV_Channel WHERE TV_Channel.Language = 'terminal' medium gold: SELECT Pixel_aspect_ratio_PAR , country FROM tv_channel WHERE LANGUAGE != 'English' --- Match Fail medium pred: SELECT TV_Channel.Hight_definition_TV, TV_Channel.Country FROM TV_Channel WHERE TV_Channel.Language = 'terminal' EXCEPT SELECT TV_Channel.Hight_definition_TV, TV_Channel.Country FROM TV_Channel WHERE TV_Channel.Language = 'terminal' medium gold: SELECT Pixel_aspect_ratio_PAR , country FROM tv_channel WHERE LANGUAGE != 'English' --- Match Fail easy pred: SELECT TV_Channel.id FROM TV_Channel WHERE TV_Channel.Pay_per_view_PPV > 'terminal' GROUP BY TV_Channel.Hight_definition_TV HAVING Count(*) > 'terminal' easy gold: SELECT id FROM tv_channel GROUP BY country HAVING count(*) > 2 --- Match Fail easy pred: SELECT TV_Channel.Hight_definition_TV FROM TV_Channel GROUP BY TV_Channel.Hight_definition_TV HAVING Count(*) > 'terminal' easy gold: SELECT id FROM tv_channel GROUP BY country HAVING count(*) > 2 --- Match Fail hard pred: SELECT TV_Channel.id FROM TV_Channel EXCEPT SELECT Cartoon.id FROM Cartoon WHERE Cartoon.Directed_by = 'terminal' hard gold: SELECT id FROM TV_Channel EXCEPT SELECT channel FROM cartoon WHERE directed_by = 'Ben Jones' --- Match Fail hard pred: SELECT TV_Channel.id FROM TV_Channel EXCEPT SELECT Cartoon.id FROM Cartoon JOIN TV_Channel WHERE Cartoon.Directed_by = 'terminal' hard gold: SELECT id FROM TV_Channel EXCEPT SELECT channel FROM cartoon WHERE directed_by = 'Ben Jones' --- Match Fail hard pred: SELECT TV_Channel.Content FROM TV_Channel EXCEPT SELECT TV_Channel.Content FROM Cartoon JOIN TV_Channel WHERE Cartoon.Directed_by = 'terminal' hard gold: SELECT package_option FROM TV_Channel WHERE id NOT IN (SELECT channel FROM cartoon WHERE directed_by = 'Ben Jones') --- Match Fail hard pred: SELECT TV_Channel.Hight_definition_TV FROM TV_Channel EXCEPT SELECT TV_Channel.Hight_definition_TV FROM Cartoon JOIN TV_Channel WHERE Cartoon.Directed_by = 'terminal' hard gold: SELECT package_option FROM TV_Channel WHERE id NOT IN (SELECT channel FROM cartoon WHERE directed_by = 'Ben Jones') --- Match OK easy pred: SELECT Count(*) FROM poker_player easy gold: SELECT count(*) FROM poker_player --- Match OK easy pred: SELECT Count(*) FROM poker_player easy gold: SELECT count(*) FROM poker_player --- Match Fail easy pred: SELECT poker_player.Best_Finish FROM poker_player ORDER BY poker_player.Best_Finish Desc easy gold: SELECT Earnings FROM poker_player ORDER BY Earnings DESC --- Match Fail easy pred: SELECT poker_player.Best_Finish FROM poker_player ORDER BY poker_player.Best_Finish Desc easy gold: SELECT Earnings FROM poker_player ORDER BY Earnings DESC --- Match Fail medium pred: SELECT poker_player.Earnings, poker_player.Final_Table_Made FROM poker_player medium gold: SELECT Final_Table_Made , Best_Finish FROM poker_player --- Match Fail medium pred: SELECT Max(poker_player.Final_Table_Made), people.Name FROM poker_player JOIN people medium gold: SELECT Final_Table_Made , Best_Finish FROM poker_player --- Match Fail easy pred: SELECT Avg(poker_player.Best_Finish) FROM poker_player easy gold: SELECT avg(Earnings) FROM poker_player --- Match Fail easy pred: SELECT Avg(poker_player.Best_Finish) FROM poker_player easy gold: SELECT avg(Earnings) FROM poker_player --- Match Fail medium pred: SELECT poker_player.Money_Rank FROM poker_player ORDER BY poker_player.Best_Finish Desc LIMIT 1 medium gold: SELECT Money_Rank FROM poker_player ORDER BY Earnings DESC LIMIT 1 --- Match Fail medium pred: SELECT poker_player.Final_Table_Made FROM poker_player ORDER BY poker_player.Final_Table_Made Desc LIMIT 1 medium gold: SELECT Money_Rank FROM poker_player ORDER BY Earnings DESC LIMIT 1 --- Match Fail easy pred: SELECT people.Name FROM poker_player JOIN people WHERE people.Height < 'terminal' easy gold: SELECT max(Final_Table_Made) FROM poker_player WHERE Earnings < 200000 --- Match Fail easy pred: SELECT people.Nationality FROM poker_player JOIN people WHERE poker_player.Final_Table_Made < 'terminal' easy gold: SELECT max(Final_Table_Made) FROM poker_player WHERE Earnings < 200000 --- Match OK easy pred: SELECT people.Name FROM poker_player JOIN people easy gold: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID --- Match OK easy pred: SELECT people.Name FROM poker_player JOIN people easy gold: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID --- Match OK medium pred: SELECT people.Name FROM poker_player JOIN people WHERE poker_player.Earnings > 'terminal' medium gold: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Earnings > 300000 --- Match OK medium pred: SELECT people.Name FROM poker_player JOIN people WHERE poker_player.Earnings > 'terminal' medium gold: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Earnings > 300000 --- Match OK medium pred: SELECT people.Name FROM poker_player JOIN people ORDER BY poker_player.Final_Table_Made Asc medium gold: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID ORDER BY T2.Final_Table_Made --- Match Fail medium pred: SELECT people.Name FROM poker_player JOIN people ORDER BY people.Name Asc medium gold: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID ORDER BY T2.Final_Table_Made --- Match Fail hard pred: SELECT people.Birth_Date FROM poker_player JOIN people ORDER BY poker_player.Best_Finish Asc LIMIT 1 hard gold: SELECT T1.Birth_Date FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID ORDER BY T2.Earnings ASC LIMIT 1 --- Match Fail hard pred: SELECT people.Birth_Date FROM poker_player JOIN people ORDER BY poker_player.Best_Finish Asc LIMIT 1 hard gold: SELECT T1.Birth_Date FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID ORDER BY T2.Earnings ASC LIMIT 1 --- Match OK hard pred: SELECT poker_player.Money_Rank FROM poker_player JOIN people ORDER BY people.Height Desc LIMIT 1 hard gold: SELECT T2.Money_Rank FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID ORDER BY T1.Height DESC LIMIT 1 --- Match OK hard pred: SELECT poker_player.Money_Rank FROM poker_player JOIN people ORDER BY people.Height Desc LIMIT 1 hard gold: SELECT T2.Money_Rank FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID ORDER BY T1.Height DESC LIMIT 1 --- Match Fail medium pred: SELECT Avg(poker_player.Best_Finish) FROM poker_player JOIN people WHERE people.Height > 'terminal' medium gold: SELECT avg(T2.Earnings) FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID WHERE T1.Height > 200 --- Match Fail medium pred: SELECT Avg(poker_player.Best_Finish) FROM poker_player JOIN people WHERE people.Height > 'terminal' medium gold: SELECT avg(T2.Earnings) FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID WHERE T1.Height > 200 --- Match Fail medium pred: SELECT people.Name FROM poker_player JOIN people ORDER BY poker_player.Best_Finish Desc medium gold: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID ORDER BY T2.Earnings DESC --- Match Fail medium pred: SELECT people.Name FROM poker_player JOIN people ORDER BY poker_player.Final_Table_Made Desc medium gold: SELECT T1.Name FROM people AS T1 JOIN poker_player AS T2 ON T1.People_ID = T2.People_ID ORDER BY T2.Earnings DESC --- Match OK medium pred: SELECT people.Nationality, Count(*) FROM people GROUP BY people.Nationality medium gold: SELECT Nationality , COUNT(*) FROM people GROUP BY Nationality --- Match OK medium pred: SELECT people.Nationality, Count(*) FROM people GROUP BY people.Nationality medium gold: SELECT Nationality , COUNT(*) FROM people GROUP BY Nationality --- Match OK hard pred: SELECT people.Nationality FROM people GROUP BY people.Nationality ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT Nationality FROM people GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1 --- Match OK hard pred: SELECT people.Nationality FROM people GROUP BY people.Nationality ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT Nationality FROM people GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1 --- Match OK easy pred: SELECT people.Nationality FROM people GROUP BY people.Nationality HAVING Count(*) >= 'terminal' easy gold: SELECT Nationality FROM people GROUP BY Nationality HAVING COUNT(*) >= 2 --- Match OK easy pred: SELECT people.Nationality FROM people GROUP BY people.Nationality HAVING Count(*) >= 'terminal' easy gold: SELECT Nationality FROM people GROUP BY Nationality HAVING COUNT(*) >= 2 --- Match OK medium pred: SELECT people.Name, people.Birth_Date FROM people ORDER BY people.Name Asc medium gold: SELECT Name , Birth_Date FROM people ORDER BY Name ASC --- Match OK medium pred: SELECT people.Name, people.Birth_Date FROM people ORDER BY people.Name Asc medium gold: SELECT Name , Birth_Date FROM people ORDER BY Name ASC --- Match OK easy pred: SELECT people.Name FROM people WHERE people.Nationality != 'terminal' easy gold: SELECT Name FROM people WHERE Nationality != "Russia" --- Match OK easy pred: SELECT people.Name FROM people WHERE people.Nationality != 'terminal' easy gold: SELECT Name FROM people WHERE Nationality != "Russia" --- Match OK hard pred: SELECT people.Name FROM people WHERE people.People_ID NOT IN (SELECT poker_player.People_ID FROM poker_player) hard gold: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM poker_player) --- Match OK hard pred: SELECT people.Name FROM people WHERE people.People_ID NOT IN (SELECT poker_player.People_ID FROM poker_player) hard gold: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM poker_player) --- Match OK easy pred: SELECT Count(DISTINCT people.Nationality) FROM people easy gold: SELECT count(DISTINCT Nationality) FROM people --- Match OK easy pred: SELECT Count(DISTINCT people.Nationality) FROM people easy gold: SELECT count(DISTINCT Nationality) FROM people --- Match Fail easy pred: SELECT Count(DISTINCT AREA_CODE_STATE.state) FROM AREA_CODE_STATE easy gold: SELECT count(*) FROM area_code_state --- Match Fail medium pred: SELECT VOTES.state, CONTESTANTS.contestant_name FROM VOTES JOIN CONTESTANTS ORDER BY VOTES.created Desc medium gold: SELECT contestant_number , contestant_name FROM contestants ORDER BY contestant_name DESC --- Match OK medium pred: SELECT VOTES.vote_id, VOTES.phone_number, VOTES.state FROM VOTES medium gold: SELECT vote_id , phone_number , state FROM votes --- Match Fail medium pred: SELECT Max(AREA_CODE_STATE.area_code), Min(VOTES.created) FROM AREA_CODE_STATE JOIN VOTES medium gold: SELECT max(area_code) , min(area_code) FROM area_code_state --- Match OK easy pred: SELECT Max(VOTES.created) FROM VOTES WHERE VOTES.state = 'terminal' easy gold: SELECT max(created) FROM votes WHERE state = 'CA' --- Match Fail easy pred: SELECT * FROM VOTES JOIN CONTESTANTS WHERE CONTESTANTS.contestant_name != 'terminal' easy gold: SELECT contestant_name FROM contestants WHERE contestant_name != 'Jessie Alloway' --- Match OK medium pred: SELECT DISTINCT VOTES.state, VOTES.created FROM VOTES medium gold: SELECT DISTINCT state , created FROM votes --- Match Fail medium pred: SELECT VOTES.state, CONTESTANTS.contestant_name FROM VOTES JOIN CONTESTANTS GROUP BY VOTES.state HAVING Count(*) >= 'terminal' medium gold: SELECT T1.contestant_number , T1.contestant_name FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number = T2.contestant_number GROUP BY T1.contestant_number HAVING count(*) >= 2 --- Match Fail extra pred: SELECT CONTESTANTS.contestant_name, Count(*) FROM VOTES JOIN CONTESTANTS GROUP BY CONTESTANTS.contestant_name ORDER BY Count(*) Asc LIMIT 1 extra gold: SELECT T1.contestant_number , T1.contestant_name FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number = T2.contestant_number GROUP BY T1.contestant_number ORDER BY count(*) ASC LIMIT 1 --- Match OK medium pred: SELECT Count(*) FROM VOTES WHERE VOTES.state = 'terminal' OR VOTES.state = 'terminal' medium gold: SELECT count(*) FROM votes WHERE state = 'NY' OR state = 'CA' --- Match Fail extra pred: SELECT Count(*) FROM VOTES WHERE VOTES.state NOT IN (SELECT * FROM VOTES) extra gold: SELECT count(*) FROM contestants WHERE contestant_number NOT IN ( SELECT contestant_number FROM votes ) --- Match OK extra pred: SELECT AREA_CODE_STATE.area_code FROM AREA_CODE_STATE JOIN VOTES GROUP BY AREA_CODE_STATE.area_code ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.area_code FROM area_code_state AS T1 JOIN votes AS T2 ON T1.state = T2.state GROUP BY T1.area_code ORDER BY count(*) DESC LIMIT 1 --- Match OK medium pred: SELECT VOTES.created, VOTES.state, VOTES.phone_number FROM VOTES JOIN CONTESTANTS WHERE CONTESTANTS.contestant_name = 'terminal' medium gold: SELECT T2.created , T2.state , T2.phone_number FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number = T2.contestant_number WHERE T1.contestant_name = 'Tabatha Gehling' --- Match OK extra pred: SELECT AREA_CODE_STATE.area_code FROM VOTES JOIN AREA_CODE_STATE JOIN CONTESTANTS WHERE CONTESTANTS.contestant_name = 'terminal' INTERSECT SELECT AREA_CODE_STATE.area_code FROM VOTES JOIN AREA_CODE_STATE JOIN CONTESTANTS WHERE CONTESTANTS.contestant_name = 'terminal' extra gold: SELECT T3.area_code FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number = T2.contestant_number JOIN area_code_state AS T3 ON T2.state = T3.state WHERE T1.contestant_name = 'Tabatha Gehling' INTERSECT SELECT T3.area_code FROM contestants AS T1 JOIN votes AS T2 ON T1.contestant_number = T2.contestant_number JOIN area_code_state AS T3 ON T2.state = T3.state WHERE T1.contestant_name = 'Kelly Clauss' --- Match Fail medium pred: SELECT CONTESTANTS.contestant_name FROM VOTES JOIN CONTESTANTS WHERE CONTESTANTS.contestant_name LIKE 'terminal' medium gold: select contestant_name from contestants where contestant_name like "%al%" --- Match OK easy pred: SELECT country.Name FROM country WHERE country.IndepYear > 'terminal' easy gold: SELECT Name FROM country WHERE IndepYear > 1950 --- Match OK easy pred: SELECT country.Name FROM country WHERE country.IndepYear > 'terminal' easy gold: SELECT Name FROM country WHERE IndepYear > 1950 --- Match Fail easy pred: SELECT Count(*) FROM country easy gold: SELECT count(*) FROM country WHERE GovernmentForm = "Republic" --- Match Fail easy pred: SELECT Count(*) FROM country easy gold: SELECT count(*) FROM country WHERE GovernmentForm = "Republic" --- Match Fail easy pred: SELECT Sum(country.Continent) FROM country WHERE country.Region = 'terminal' easy gold: SELECT sum(SurfaceArea) FROM country WHERE Region = "Caribbean" --- Match Fail easy pred: SELECT Sum(country.SurfaceArea) FROM country WHERE country.Continent = 'terminal' easy gold: SELECT sum(SurfaceArea) FROM country WHERE Region = "Caribbean" --- Match Fail easy pred: SELECT country.Population FROM country WHERE country.Name = 'terminal' easy gold: SELECT Continent FROM country WHERE Name = "Anguilla" --- Match Fail easy pred: SELECT country.Name FROM country WHERE country.Code2 = 'terminal' easy gold: SELECT Continent FROM country WHERE Name = "Anguilla" --- Match OK medium pred: SELECT country.Region FROM country JOIN city WHERE city.Name = 'terminal' medium gold: SELECT Region FROM country AS T1 JOIN city AS T2 ON T1.Code = T2.CountryCode WHERE T2.Name = "Kabul" --- Match OK medium pred: SELECT country.Region FROM country JOIN city WHERE city.Name = 'terminal' medium gold: SELECT Region FROM country AS T1 JOIN city AS T2 ON T1.Code = T2.CountryCode WHERE T2.Name = "Kabul" --- Match Fail extra pred: SELECT city.Name FROM country JOIN city WHERE country.LocalName = 'terminal' GROUP BY country.Name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = "Aruba" ORDER BY Percentage DESC LIMIT 1 --- Match Fail extra pred: SELECT country.Name FROM country WHERE country.LocalName = 'terminal' extra gold: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = "Aruba" ORDER BY Percentage DESC LIMIT 1 --- Match Fail medium pred: SELECT country.Population, country.IndepYear FROM country medium gold: SELECT Population , LifeExpectancy FROM country WHERE Name = "Brazil" --- Match Fail medium pred: SELECT country.Population, country.IndepYear FROM country medium gold: SELECT Population , LifeExpectancy FROM country WHERE Name = "Brazil" --- Match OK medium pred: SELECT country.Region, country.Population FROM country WHERE country.Name = 'terminal' medium gold: SELECT Population , Region FROM country WHERE Name = "Angola" --- Match OK medium pred: SELECT country.Region, country.Population FROM country WHERE country.Name = 'terminal' medium gold: SELECT Population , Region FROM country WHERE Name = "Angola" --- Match Fail easy pred: SELECT Avg(country.GNPOld) FROM country WHERE country.Region = 'terminal' easy gold: SELECT avg(LifeExpectancy) FROM country WHERE Region = "Central Africa" --- Match Fail easy pred: SELECT Avg(countrylanguage.Language) FROM country JOIN countrylanguage WHERE country.Region = 'terminal' easy gold: SELECT avg(LifeExpectancy) FROM country WHERE Region = "Central Africa" --- Match Fail hard pred: SELECT country.Name FROM country JOIN countrylanguage WHERE country.Continent IN (SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = (SELECT Min(countrylanguage.Language) FROM countrylanguage)) hard gold: SELECT Name FROM country WHERE Continent = "Asia" ORDER BY LifeExpectancy LIMIT 1 --- Match Fail hard pred: SELECT country.Name FROM country JOIN countrylanguage WHERE country.Continent = 'terminal' AND country.Population = (SELECT Min(countrylanguage.Language) FROM countrylanguage WHERE countrylanguage.CountryCode = 'terminal') hard gold: SELECT Name FROM country WHERE Continent = "Asia" ORDER BY LifeExpectancy LIMIT 1 --- Match Fail medium pred: SELECT Sum(country.Population), Sum(country.GNP) FROM country WHERE country.LocalName = 'terminal' medium gold: SELECT sum(Population) , max(GNP) FROM country WHERE Continent = "Asia" --- Match Fail medium pred: SELECT Max(country.GNP), Count(*) FROM country WHERE country.LocalName = 'terminal' medium gold: SELECT sum(Population) , max(GNP) FROM country WHERE Continent = "Asia" --- Match Fail medium pred: SELECT Avg(country.IndepYear) FROM country WHERE country.LocalName = 'terminal' medium gold: SELECT avg(LifeExpectancy) FROM country WHERE Continent = "Africa" AND GovernmentForm = "Republic" --- Match Fail medium pred: SELECT Avg(country.GNPOld) FROM country JOIN city WHERE city.Name = 'terminal' medium gold: SELECT avg(LifeExpectancy) FROM country WHERE Continent = "Africa" AND GovernmentForm = "Republic" --- Match Fail medium pred: SELECT Sum(country.SurfaceArea) FROM country WHERE country.Population = 'terminal' INTERSECT SELECT country.SurfaceArea FROM country WHERE country.Population = 'terminal' medium gold: SELECT sum(SurfaceArea) FROM country WHERE Continent = "Asia" OR Continent = "Europe" --- Match Fail medium pred: SELECT country.SurfaceArea FROM country WHERE country.Population = 'terminal' OR country.Population = 'terminal' medium gold: SELECT sum(SurfaceArea) FROM country WHERE Continent = "Asia" OR Continent = "Europe" --- Match Fail easy pred: SELECT city.Population FROM city WHERE city.District = 'terminal' easy gold: SELECT sum(Population) FROM city WHERE District = "Gelderland" --- Match Fail easy pred: SELECT Sum(city.Population) FROM city WHERE city.Name = 'terminal' easy gold: SELECT sum(Population) FROM city WHERE District = "Gelderland" --- Match Fail medium pred: SELECT Avg(country.GNP), Avg(country.Population) FROM country WHERE country.Region = 'terminal' medium gold: SELECT avg(GNP) , sum(population) FROM country WHERE GovernmentForm = "US Territory" --- Match Fail medium pred: SELECT Avg(country.GNP), Avg(country.Population) FROM country WHERE country.Region = 'terminal' medium gold: SELECT avg(GNP) , sum(population) FROM country WHERE GovernmentForm = "US Territory" --- Match OK easy pred: SELECT Count(DISTINCT countrylanguage.Language) FROM countrylanguage easy gold: SELECT count(DISTINCT LANGUAGE) FROM countrylanguage --- Match Fail easy pred: SELECT Count(DISTINCT country.Name) FROM country easy gold: SELECT count(DISTINCT LANGUAGE) FROM countrylanguage --- Match Fail easy pred: SELECT Count(*) FROM country easy gold: SELECT count(DISTINCT GovernmentForm) FROM country WHERE Continent = "Africa" --- Match Fail easy pred: SELECT Count(DISTINCT country.GovernmentForm) FROM country easy gold: SELECT count(DISTINCT GovernmentForm) FROM country WHERE Continent = "Africa" --- Match Fail medium pred: SELECT Count(*) FROM country WHERE country.LocalName = 'terminal' medium gold: SELECT COUNT(T2.Language) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = "Aruba" --- Match Fail medium pred: SELECT Count(*) FROM country WHERE country.Name = 'terminal' medium gold: SELECT COUNT(T2.Language) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = "Aruba" --- Match Fail medium pred: SELECT Count(*) FROM country JOIN countrylanguage WHERE country.GovernmentForm = 'terminal' medium gold: SELECT COUNT(*) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = "Afghanistan" AND IsOfficial = "T" --- Match Fail medium pred: SELECT Count(*) FROM countrylanguage JOIN country WHERE country.Population = 'terminal' medium gold: SELECT COUNT(*) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = "Afghanistan" AND IsOfficial = "T" --- Match Fail extra pred: SELECT country.Name FROM country JOIN countrylanguage GROUP BY countrylanguage.CountryCode ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Name ORDER BY COUNT(*) DESC LIMIT 1 --- Match OK extra pred: SELECT country.Name FROM country JOIN countrylanguage GROUP BY country.Name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Name ORDER BY COUNT(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT country.Population FROM country JOIN countrylanguage GROUP BY country.Name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.Continent FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Continent ORDER BY COUNT(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT country.Name FROM country JOIN countrylanguage GROUP BY countrylanguage.CountryCode ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.Continent FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Continent ORDER BY COUNT(*) DESC LIMIT 1 --- Match Fail easy pred: SELECT country.Name, Count(*) FROM country WHERE countrylanguage.Language = 'terminal' INTERSECT SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal' easy gold: SELECT COUNT(*) FROM (SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "Dutch") --- Match Fail easy pred: SELECT Count(*) FROM countrylanguage easy gold: SELECT COUNT(*) FROM (SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "Dutch") --- Match OK extra pred: SELECT country.Name FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' INTERSECT SELECT country.Name FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' extra gold: SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "French" --- Match OK extra pred: SELECT country.Name FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' INTERSECT SELECT country.Name FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' extra gold: SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "French" --- Match Fail extra pred: SELECT country.Name FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' INTERSECT SELECT country.Name FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' extra gold: SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" AND T2.IsOfficial = "T" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "French" AND T2.IsOfficial = "T" --- Match Fail extra pred: SELECT country.Name FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' INTERSECT SELECT country.Name FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' extra gold: SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" AND T2.IsOfficial = "T" INTERSECT SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "French" AND T2.IsOfficial = "T" --- Match Fail medium pred: SELECT Count(DISTINCT countrylanguage.CountryCode) FROM countrylanguage medium gold: SELECT COUNT( DISTINCT Continent) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "Chinese" --- Match Fail medium pred: SELECT Count(*) FROM country medium gold: SELECT COUNT( DISTINCT Continent) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "Chinese" --- Match Fail hard pred: SELECT country.Region FROM country WHERE country.Continent = 'terminal' OR country.Continent = 'terminal' hard gold: SELECT DISTINCT T1.Region FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" OR T2.Language = "Dutch" --- Match Fail hard pred: SELECT country.Region FROM country WHERE country.Continent = 'terminal' OR country.Continent = 'terminal' hard gold: SELECT DISTINCT T1.Region FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" OR T2.Language = "Dutch" --- Match Fail extra pred: SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal' OR countrylanguage.Language = 'terminal' extra gold: select t1.name from country as t1 join countrylanguage as t2 on t1.code = t2.countrycode where t2.language = "english" and isofficial = "t" union select t1.name from country as t1 join countrylanguage as t2 on t1.code = t2.countrycode where t2.language = "dutch" and isofficial = "t" --- Match Fail extra pred: SELECT country.Name FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' OR countrylanguage.Language = 'terminal' extra gold: SELECT * FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" AND IsOfficial = "T" UNION SELECT * FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "Dutch" AND IsOfficial = "T" --- Match Fail extra pred: SELECT country.Name FROM country JOIN city WHERE country.Population = 'terminal' GROUP BY country.Name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Continent = "Asia" GROUP BY T2.Language ORDER BY COUNT (*) DESC LIMIT 1 --- Match Fail extra pred: SELECT country.Name FROM country JOIN countrylanguage GROUP BY country.Name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Continent = "Asia" GROUP BY T2.Language ORDER BY COUNT (*) DESC LIMIT 1 --- Match Fail hard pred: SELECT countrylanguage.Language FROM countrylanguage JOIN country GROUP BY countrylanguage.Language HAVING Count(*) = 'terminal' hard gold: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.GovernmentForm = "Republic" GROUP BY T2.Language HAVING COUNT(*) = 1 --- Match Fail hard pred: SELECT countrylanguage.Language FROM countrylanguage hard gold: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.GovernmentForm = "Republic" GROUP BY T2.Language HAVING COUNT(*) = 1 --- Match Fail extra pred: SELECT city.Name FROM city WHERE city.Population = (SELECT Max(city.Population) FROM city WHERE city.CountryCode = 'terminal') AND city.CountryCode = 'terminal' extra gold: SELECT T1.Name , T1.Population FROM city AS T1 JOIN countrylanguage AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.Language = "English" ORDER BY T1.Population DESC LIMIT 1 --- Match Fail extra pred: SELECT city.Name FROM city WHERE city.Population = (SELECT Max(city.Population) FROM city) extra gold: SELECT T1.Name , T1.Population FROM city AS T1 JOIN countrylanguage AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.Language = "English" ORDER BY T1.Population DESC LIMIT 1 --- Match Fail hard pred: SELECT country.Name, country.Population, country.IndepYear FROM country WHERE country.SurfaceArea = (SELECT Max(country.SurfaceArea) FROM country) hard gold: SELECT Name , Population , LifeExpectancy FROM country WHERE Continent = "Asia" ORDER BY SurfaceArea DESC LIMIT 1 --- Match Fail hard pred: SELECT country.Name, country.Population, country.IndepYear FROM country WHERE country.GovernmentForm = 'terminal' ORDER BY country.GNPOld Desc LIMIT 1 hard gold: SELECT Name , Population , LifeExpectancy FROM country WHERE Continent = "Asia" ORDER BY SurfaceArea DESC LIMIT 1 --- Match Fail extra pred: SELECT Avg(country.GNPOld) FROM country WHERE country.Capital NOT IN (SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal') extra gold: SELECT avg(LifeExpectancy) FROM country WHERE Name NOT IN (SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" AND T2.IsOfficial = "T") --- Match Fail extra pred: SELECT Avg(country.GNPOld) FROM country WHERE country.Capital NOT IN (SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal') extra gold: SELECT avg(LifeExpectancy) FROM country WHERE Name NOT IN (SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English" AND T2.IsOfficial = "T") --- Match Fail extra pred: SELECT Sum(country.Population) FROM country WHERE country.Code NOT IN (SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal') extra gold: SELECT sum(Population) FROM country WHERE Name NOT IN (SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English") --- Match Fail extra pred: SELECT Count(*) FROM country WHERE country.Code NOT IN (SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal') extra gold: SELECT sum(Population) FROM country WHERE Name NOT IN (SELECT T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T2.Language = "English") --- Match Fail medium pred: SELECT countrylanguage.Language FROM countrylanguage JOIN country WHERE country.HeadOfState = 'terminal' medium gold: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.HeadOfState = "Beatrix" AND T2.IsOfficial = "T" --- Match Fail medium pred: SELECT countrylanguage.Language FROM country JOIN countrylanguage WHERE country.HeadOfState = 'terminal' medium gold: SELECT T2.Language FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.HeadOfState = "Beatrix" AND T2.IsOfficial = "T" --- Match Fail medium pred: SELECT Count(*) FROM country WHERE country.IndepYear < 'terminal' medium gold: SELECT count(DISTINCT T2.Language) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE IndepYear < 1930 AND T2.IsOfficial = "T" --- Match Fail medium pred: SELECT Count(DISTINCT countrylanguage.Language) FROM country JOIN countrylanguage WHERE country.IndepYear < 'terminal' medium gold: SELECT count(DISTINCT T2.Language) FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode WHERE IndepYear < 1930 AND T2.IsOfficial = "T" --- Match Fail hard pred: SELECT country.Name FROM country WHERE country.Region > (SELECT country.Region FROM country) hard gold: SELECT Name FROM country WHERE SurfaceArea > (SELECT min(SurfaceArea) FROM country WHERE Continent = "Europe") --- Match Fail hard pred: SELECT country.SurfaceArea FROM country WHERE country.SurfaceArea > (SELECT Max(country.SurfaceArea) FROM country) hard gold: SELECT Name FROM country WHERE SurfaceArea > (SELECT min(SurfaceArea) FROM country WHERE Continent = "Europe") --- Match Fail extra pred: SELECT country.Name FROM country WHERE country.Population < (SELECT Min(country.Population) FROM country WHERE country.GovernmentForm = 'terminal') extra gold: SELECT Name FROM country WHERE Continent = "Africa" AND population < (SELECT max(population) FROM country WHERE Continent = "Asia") --- Match Fail extra pred: SELECT country.Name FROM country JOIN city WHERE country.Population < (SELECT Min(country.Population) FROM country JOIN city WHERE city.Name = 'terminal') extra gold: SELECT Name FROM country WHERE Continent = "Africa" AND population < (SELECT min(population) FROM country WHERE Continent = "Asia") --- Match Fail extra pred: SELECT country.Name FROM countrylanguage JOIN country WHERE country.Population > (SELECT Avg(country.Population) FROM countrylanguage JOIN country WHERE city.Name = 'terminal') extra gold: SELECT Name FROM country WHERE Continent = "Asia" AND population > (SELECT max(population) FROM country WHERE Continent = "Africa") --- Match Fail extra pred: SELECT country.Name FROM country WHERE country.Population > (SELECT Avg(country.Population) FROM country WHERE country.GovernmentForm = 'terminal') extra gold: SELECT Name FROM country WHERE Continent = "Asia" AND population > (SELECT min(population) FROM country WHERE Continent = "Africa") --- Match Fail hard pred: SELECT country.Code FROM country EXCEPT SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal' hard gold: SELECT CountryCode FROM countrylanguage EXCEPT SELECT CountryCode FROM countrylanguage WHERE LANGUAGE = "English" --- Match Fail hard pred: SELECT country.Code FROM country EXCEPT SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal' hard gold: SELECT CountryCode FROM countrylanguage EXCEPT SELECT CountryCode FROM countrylanguage WHERE LANGUAGE = "English" --- Match Fail easy pred: SELECT country.Code FROM country WHERE countrylanguage.Language > 'terminal' UNION SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal' easy gold: SELECT DISTINCT CountryCode FROM countrylanguage WHERE LANGUAGE != "English" --- Match Fail easy pred: SELECT country.Code FROM country JOIN countrylanguage WHERE countrylanguage.Language != 'terminal' easy gold: SELECT DISTINCT CountryCode FROM countrylanguage WHERE LANGUAGE != "English" --- Match Fail hard pred: SELECT country.Code FROM country WHERE country.Code2 = 'terminal' EXCEPT SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal' hard gold: SELECT Code FROM country WHERE GovernmentForm != "Republic" EXCEPT SELECT CountryCode FROM countrylanguage WHERE LANGUAGE = "English" --- Match Fail hard pred: SELECT country.Code FROM country WHERE country.LocalName = 'terminal' EXCEPT SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal' hard gold: SELECT Code FROM country WHERE GovernmentForm != "Republic" EXCEPT SELECT CountryCode FROM countrylanguage WHERE LANGUAGE = "English" --- Match Fail extra pred: SELECT city.Name FROM city WHERE city.CountryCode IN (SELECT countrylanguage.CountryCode FROM countrylanguage WHERE countrylanguage.Language = 'terminal') extra gold: SELECT DISTINCT T2.Name FROM country AS T1 JOIN city AS T2 ON T2.CountryCode = T1.Code WHERE T1.Continent = 'Europe' AND T1.Name NOT IN (SELECT T3.Name FROM country AS T3 JOIN countrylanguage AS T4 ON T3.Code = T4.CountryCode WHERE T4.IsOfficial = 'T' AND T4.Language = 'English') --- Match Fail extra pred: SELECT city.Name FROM city WHERE countrylanguage.Language = 'terminal' EXCEPT SELECT country.LocalName FROM city JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' extra gold: SELECT DISTINCT T2.Name FROM country AS T1 JOIN city AS T2 ON T2.CountryCode = T1.Code WHERE T1.Continent = 'Europe' AND T1.Name NOT IN (SELECT T3.Name FROM country AS T3 JOIN countrylanguage AS T4 ON T3.Code = T4.CountryCode WHERE T4.IsOfficial = 'T' AND T4.Language = 'English') --- Match Fail hard pred: SELECT city.Name FROM country JOIN city WHERE country.GovernmentForm = 'terminal' AND country.GovernmentForm = 'terminal' hard gold: select distinct t3.name from country as t1 join countrylanguage as t2 on t1.code = t2.countrycode join city as t3 on t1.code = t3.countrycode where t2.isofficial = 't' and t2.language = 'chinese' and t1.continent = "asia" --- Match Fail hard pred: SELECT DISTINCT city.Name FROM city JOIN country WHERE country.LocalName = 'terminal' hard gold: SELECT DISTINCT T3.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode JOIN city AS T3 ON T1.Code = T3.CountryCode WHERE T2.IsOfficial = 'T' AND T2.Language = 'Chinese' AND T1.Continent = "Asia" --- Match OK medium pred: SELECT country.Name, country.IndepYear, country.SurfaceArea FROM country ORDER BY country.Population Asc LIMIT 1 medium gold: SELECT Name , SurfaceArea , IndepYear FROM country ORDER BY Population LIMIT 1 --- Match OK medium pred: SELECT country.Name, country.IndepYear, country.SurfaceArea FROM country ORDER BY country.Population Asc LIMIT 1 medium gold: SELECT Name , SurfaceArea , IndepYear FROM country ORDER BY Population LIMIT 1 --- Match Fail medium pred: SELECT country.Population, country.Name, country.SurfaceArea FROM country ORDER BY country.Region Desc LIMIT 1 medium gold: SELECT Name , population , HeadOfState FROM country ORDER BY SurfaceArea DESC LIMIT 1 --- Match Fail medium pred: SELECT country.Name, country.Population, country.SurfaceArea FROM country ORDER BY country.SurfaceArea Desc LIMIT 1 medium gold: SELECT Name , population , HeadOfState FROM country ORDER BY SurfaceArea DESC LIMIT 1 --- Match Fail medium pred: SELECT country.Name, Count(*) FROM country JOIN countrylanguage GROUP BY countrylanguage.CountryCode HAVING Count(*) >= 'terminal' medium gold: SELECT COUNT(T2.Language) , T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Name HAVING COUNT(*) > 2 --- Match Fail medium pred: SELECT country.Name, Count(*) FROM country JOIN countrylanguage GROUP BY countrylanguage.CountryCode HAVING Count(*) > 'terminal' medium gold: SELECT COUNT(T2.Language) , T1.Name FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code = T2.CountryCode GROUP BY T1.Name HAVING COUNT(*) > 2 --- Match Fail extra pred: SELECT Count(*), city.District FROM city WHERE city.Population > (SELECT Avg(city.Population) FROM city) extra gold: SELECT count(*) , District FROM city WHERE Population > (SELECT avg(Population) FROM city) GROUP BY District --- Match Fail extra pred: SELECT Count(*), city.District FROM city WHERE city.Population > (SELECT Avg(city.Population) FROM city) extra gold: SELECT count(*) , District FROM city WHERE Population > (SELECT avg(Population) FROM city) GROUP BY District --- Match Fail medium pred: SELECT country.Name, country.Population FROM country WHERE country.GNPOld > 'terminal' GROUP BY country.GovernmentForm medium gold: SELECT sum(Population) , GovernmentForm FROM country GROUP BY GovernmentForm HAVING avg(LifeExpectancy) > 72 --- Match Fail medium pred: SELECT Avg(country.Population), country.IndepYear FROM city JOIN country WHERE country.Population > 'terminal' GROUP BY city.Name medium gold: SELECT sum(Population) , GovernmentForm FROM country GROUP BY GovernmentForm HAVING avg(LifeExpectancy) > 72 --- Match Fail medium pred: SELECT Avg(country.LifeExpectancy), country.Population FROM country JOIN countrylanguage WHERE country.Population < 'terminal' GROUP BY countrylanguage.CountryCode medium gold: SELECT sum(Population) , avg(LifeExpectancy) , Continent FROM country GROUP BY Continent HAVING avg(LifeExpectancy) < 72 --- Match Fail medium pred: SELECT country.GovernmentForm, country.Population, country.Population FROM country WHERE country.GNPOld < 'terminal' medium gold: SELECT sum(Population) , avg(LifeExpectancy) , Continent FROM country GROUP BY Continent HAVING avg(LifeExpectancy) < 72 --- Match Fail medium pred: SELECT country.LocalName, country.SurfaceArea FROM country ORDER BY country.SurfaceArea Desc LIMIT 1 medium gold: SELECT Name , SurfaceArea FROM country ORDER BY SurfaceArea DESC LIMIT 5 --- Match Fail medium pred: SELECT country.LocalName, country.SurfaceArea FROM country ORDER BY country.SurfaceArea Desc LIMIT 1 medium gold: SELECT Name , SurfaceArea FROM country ORDER BY SurfaceArea DESC LIMIT 5 --- Match OK medium pred: SELECT country.Name FROM country ORDER BY country.Population Desc LIMIT 1 medium gold: SELECT Name FROM country ORDER BY Population DESC LIMIT 3 --- Match OK medium pred: SELECT country.Name FROM country ORDER BY country.Population Desc LIMIT 1 medium gold: SELECT Name FROM country ORDER BY Population DESC LIMIT 3 --- Match OK medium pred: SELECT country.Name FROM country ORDER BY country.Population Asc LIMIT 1 medium gold: SELECT Name FROM country ORDER BY Population ASC LIMIT 3 --- Match OK medium pred: SELECT country.Name FROM country ORDER BY country.Population Asc LIMIT 1 medium gold: SELECT Name FROM country ORDER BY Population ASC LIMIT 3 --- Match Fail easy pred: SELECT Count(*) FROM country easy gold: SELECT count(*) FROM country WHERE continent = "Asia" --- Match Fail easy pred: SELECT Count(*) FROM country easy gold: SELECT count(*) FROM country WHERE continent = "Asia" --- Match Fail medium pred: SELECT country.Name FROM country WHERE country.GovernmentForm = 'terminal' AND country.Population >= 'terminal' medium gold: SELECT Name FROM country WHERE continent = "Europe" AND Population = "80000" --- Match Fail medium pred: SELECT country.Name FROM country WHERE country.Population >= 'terminal' medium gold: SELECT Name FROM country WHERE continent = "Europe" AND Population = "80000" --- Match Fail hard pred: SELECT country.Population, country.SurfaceArea FROM country WHERE country.SurfaceArea > 'terminal' AND country.SurfaceArea > 'terminal' hard gold: select sum(population) , avg(surfacearea) from country where continent = "north america" and surfacearea > 3000 --- Match Fail hard pred: SELECT country.Population, country.Region FROM country WHERE country.Continent > 'terminal' hard gold: select sum(population) , avg(surfacearea) from country where continent = "north america" and surfacearea > 3000 --- Match OK easy pred: SELECT city.Name FROM city WHERE city.Population BETWEEN 'terminal' AND 'terminal' easy gold: SELECT name FROM city WHERE Population BETWEEN 160000 AND 900000 --- Match OK easy pred: SELECT city.Name FROM city WHERE city.Population BETWEEN 'terminal' AND 'terminal' easy gold: select name from city where population between 160000 and 900000 --- Match Fail hard pred: SELECT country.Name FROM country JOIN countrylanguage GROUP BY country.Name ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT LANGUAGE FROM countrylanguage GROUP BY LANGUAGE ORDER BY count(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT country.Name FROM country JOIN countrylanguage GROUP BY country.GovernmentForm ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT LANGUAGE FROM countrylanguage GROUP BY LANGUAGE ORDER BY count(*) DESC LIMIT 1 --- Match Fail medium pred: SELECT country.Name FROM country JOIN city GROUP BY city.Name ORDER BY Sum(country.Population) Desc LIMIT 1 medium gold: SELECT LANGUAGE , CountryCode , max(Percentage) FROM countrylanguage GROUP BY CountryCode --- Match Fail medium pred: SELECT country.Code, countrylanguage.Language FROM country JOIN city GROUP BY city.CountryCode ORDER BY Sum(city.Population) Desc LIMIT 1 medium gold: SELECT LANGUAGE , CountryCode , max(Percentage) FROM countrylanguage GROUP BY CountryCode --- Match Fail extra pred: SELECT Count(*) FROM country ORDER BY country.Population Desc LIMIT 1 extra gold: SELECT count(*) , max(Percentage) FROM countrylanguage WHERE LANGUAGE = "Spanish" GROUP BY CountryCode --- Match Fail extra pred: SELECT Count(*) FROM countrylanguage extra gold: SELECT count(*) , max(Percentage) FROM countrylanguage WHERE LANGUAGE = "Spanish" GROUP BY CountryCode --- Match Fail medium pred: SELECT country.Code FROM country ORDER BY country.Population Desc LIMIT 1 medium gold: SELECT CountryCode , max(Percentage) FROM countrylanguage WHERE LANGUAGE = "Spanish" GROUP BY CountryCode --- Match Fail medium pred: SELECT country.Code FROM country JOIN countrylanguage WHERE countrylanguage.Language = 'terminal' medium gold: SELECT CountryCode , max(Percentage) FROM countrylanguage WHERE LANGUAGE = "Spanish" GROUP BY CountryCode --- Match OK easy pred: SELECT Count(*) FROM conductor easy gold: SELECT count(*) FROM conductor --- Match OK easy pred: SELECT Count(*) FROM conductor easy gold: SELECT count(*) FROM conductor --- Match OK easy pred: SELECT conductor.Name FROM conductor ORDER BY conductor.Age Asc easy gold: SELECT Name FROM conductor ORDER BY Age ASC --- Match OK easy pred: SELECT conductor.Name FROM conductor ORDER BY conductor.Age Asc easy gold: SELECT Name FROM conductor ORDER BY Age ASC --- Match OK easy pred: SELECT conductor.Name FROM conductor WHERE conductor.Nationality != 'terminal' easy gold: SELECT Name FROM conductor WHERE Nationality != 'USA' --- Match OK easy pred: SELECT conductor.Name FROM conductor WHERE conductor.Nationality != 'terminal' easy gold: SELECT Name FROM conductor WHERE Nationality != 'USA' --- Match OK easy pred: SELECT orchestra.Record_Company FROM orchestra ORDER BY orchestra.Year_of_Founded Desc easy gold: SELECT Record_Company FROM orchestra ORDER BY Year_of_Founded DESC --- Match Fail easy pred: SELECT orchestra.Record_Company FROM orchestra ORDER BY orchestra.Year_of_Founded Asc easy gold: SELECT Record_Company FROM orchestra ORDER BY Year_of_Founded DESC --- Match OK easy pred: SELECT Avg(show.Attendance) FROM show easy gold: SELECT avg(Attendance) FROM SHOW --- Match OK easy pred: SELECT Avg(show.Attendance) FROM show easy gold: SELECT avg(Attendance) FROM SHOW --- Match OK medium pred: SELECT Max(performance.Share), Min(performance.Share) FROM performance WHERE performance.Type != 'terminal' medium gold: SELECT max(SHARE) , min(SHARE) FROM performance WHERE TYPE != "Live final" --- Match OK medium pred: SELECT Max(performance.Share), Min(performance.Share) FROM performance WHERE performance.Type != 'terminal' medium gold: SELECT max(SHARE) , min(SHARE) FROM performance WHERE TYPE != "Live final" --- Match OK easy pred: SELECT Count(DISTINCT conductor.Nationality) FROM conductor easy gold: SELECT count(DISTINCT Nationality) FROM conductor --- Match OK easy pred: SELECT Count(DISTINCT conductor.Nationality) FROM conductor easy gold: SELECT count(DISTINCT Nationality) FROM conductor --- Match OK easy pred: SELECT conductor.Name FROM conductor ORDER BY conductor.Year_of_Work Desc easy gold: SELECT Name FROM conductor ORDER BY Year_of_Work DESC --- Match OK easy pred: SELECT conductor.Name FROM conductor ORDER BY conductor.Year_of_Work Desc easy gold: SELECT Name FROM conductor ORDER BY Year_of_Work DESC --- Match OK medium pred: SELECT conductor.Name FROM conductor ORDER BY conductor.Year_of_Work Desc LIMIT 1 medium gold: SELECT Name FROM conductor ORDER BY Year_of_Work DESC LIMIT 1 --- Match OK medium pred: SELECT conductor.Name FROM conductor ORDER BY conductor.Year_of_Work Desc LIMIT 1 medium gold: SELECT Name FROM conductor ORDER BY Year_of_Work DESC LIMIT 1 --- Match Fail medium pred: SELECT conductor.Name, orchestra.Orchestra FROM orchestra JOIN conductor JOIN performance medium gold: SELECT T1.Name , T2.Orchestra FROM conductor AS T1 JOIN orchestra AS T2 ON T1.Conductor_ID = T2.Conductor_ID --- Match Fail medium pred: SELECT conductor.Name, orchestra.Orchestra FROM orchestra JOIN conductor JOIN performance medium gold: SELECT T1.Name , T2.Orchestra FROM conductor AS T1 JOIN orchestra AS T2 ON T1.Conductor_ID = T2.Conductor_ID --- Match OK medium pred: SELECT conductor.Name FROM orchestra JOIN conductor GROUP BY orchestra.Conductor_ID HAVING Count(*) > 'terminal' medium gold: SELECT T1.Name FROM conductor AS T1 JOIN orchestra AS T2 ON T1.Conductor_ID = T2.Conductor_ID GROUP BY T2.Conductor_ID HAVING COUNT(*) > 1 --- Match OK medium pred: SELECT conductor.Name FROM conductor JOIN orchestra GROUP BY orchestra.Conductor_ID HAVING Count(*) > 'terminal' medium gold: SELECT T1.Name FROM conductor AS T1 JOIN orchestra AS T2 ON T1.Conductor_ID = T2.Conductor_ID GROUP BY T2.Conductor_ID HAVING COUNT(*) > 1 --- Match OK extra pred: SELECT conductor.Name FROM conductor JOIN orchestra GROUP BY orchestra.Conductor_ID ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.Name FROM conductor AS T1 JOIN orchestra AS T2 ON T1.Conductor_ID = T2.Conductor_ID GROUP BY T2.Conductor_ID ORDER BY COUNT(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT conductor.Name FROM conductor JOIN orchestra GROUP BY conductor.Name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.Name FROM conductor AS T1 JOIN orchestra AS T2 ON T1.Conductor_ID = T2.Conductor_ID GROUP BY T2.Conductor_ID ORDER BY COUNT(*) DESC LIMIT 1 --- Match OK medium pred: SELECT conductor.Name FROM orchestra JOIN conductor WHERE orchestra.Year_of_Founded > 'terminal' medium gold: SELECT T1.Name FROM conductor AS T1 JOIN orchestra AS T2 ON T1.Conductor_ID = T2.Conductor_ID WHERE Year_of_Founded > 2008 --- Match Fail medium pred: SELECT conductor.Name FROM orchestra JOIN conductor JOIN performance WHERE orchestra.Year_of_Founded = 'terminal' OR orchestra.Year_of_Founded > 'terminal' medium gold: SELECT T1.Name FROM conductor AS T1 JOIN orchestra AS T2 ON T1.Conductor_ID = T2.Conductor_ID WHERE Year_of_Founded > 2008 --- Match OK medium pred: SELECT orchestra.Record_Company, Count(*) FROM orchestra GROUP BY orchestra.Record_Company medium gold: SELECT Record_Company , COUNT(*) FROM orchestra GROUP BY Record_Company --- Match Fail medium pred: SELECT orchestra.Orchestra, Count(*) FROM orchestra GROUP BY orchestra.Orchestra medium gold: SELECT Record_Company , COUNT(*) FROM orchestra GROUP BY Record_Company --- Match Fail medium pred: SELECT orchestra.Orchestra FROM orchestra ORDER BY orchestra.Orchestra Asc medium gold: SELECT Major_Record_Format FROM orchestra GROUP BY Major_Record_Format ORDER BY COUNT(*) ASC --- Match Fail medium pred: SELECT performance.Type FROM performance JOIN orchestra GROUP BY performance.Type ORDER BY Count(*) Desc medium gold: SELECT Major_Record_Format FROM orchestra GROUP BY Major_Record_Format ORDER BY COUNT(*) ASC --- Match Fail hard pred: SELECT orchestra.Orchestra FROM orchestra GROUP BY orchestra.Orchestra ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT Record_Company FROM orchestra GROUP BY Record_Company ORDER BY COUNT(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT conductor.Nationality FROM conductor JOIN orchestra GROUP BY conductor.Nationality ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT Record_Company FROM orchestra GROUP BY Record_Company ORDER BY COUNT(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT conductor.Name FROM conductor WHERE conductor.Conductor_ID NOT IN (SELECT performance.Orchestra_ID FROM performance) hard gold: SELECT Orchestra FROM orchestra WHERE Orchestra_ID NOT IN (SELECT Orchestra_ID FROM performance) --- Match OK hard pred: SELECT orchestra.Orchestra FROM orchestra WHERE orchestra.Orchestra_ID NOT IN (SELECT performance.Orchestra_ID FROM performance) hard gold: SELECT Orchestra FROM orchestra WHERE Orchestra_ID NOT IN (SELECT Orchestra_ID FROM performance) --- Match Fail hard pred: SELECT orchestra.Record_Company FROM orchestra JOIN conductor WHERE orchestra.Year_of_Founded < 'terminal' INTERSECT SELECT orchestra.Record_Company FROM orchestra WHERE orchestra.Year_of_Founded > 'terminal' hard gold: SELECT Record_Company FROM orchestra WHERE Year_of_Founded < 2003 INTERSECT SELECT Record_Company FROM orchestra WHERE Year_of_Founded > 2003 --- Match Fail hard pred: SELECT conductor.Nationality FROM orchestra JOIN conductor WHERE orchestra.Year_of_Founded < 'terminal' INTERSECT SELECT conductor.Nationality FROM orchestra WHERE orchestra.Year_of_Founded > 'terminal' hard gold: SELECT Record_Company FROM orchestra WHERE Year_of_Founded < 2003 INTERSECT SELECT Record_Company FROM orchestra WHERE Year_of_Founded > 2003 --- Match Fail medium pred: SELECT Count(*) FROM performance JOIN orchestra WHERE performance.Type = 'terminal' OR performance.Type = 'terminal' medium gold: SELECT COUNT(*) FROM orchestra WHERE Major_Record_Format = "CD" OR Major_Record_Format = "DVD" --- Match Fail medium pred: SELECT Count(*) FROM performance JOIN orchestra WHERE performance.Type = 'terminal' OR performance.Type = 'terminal' medium gold: SELECT COUNT(*) FROM orchestra WHERE Major_Record_Format = "CD" OR Major_Record_Format = "DVD" --- Match Fail medium pred: SELECT orchestra.Year_of_Founded FROM orchestra GROUP BY orchestra.Year_of_Founded HAVING Count(*) > 'terminal' medium gold: SELECT Year_of_Founded FROM orchestra AS T1 JOIN performance AS T2 ON T1.Orchestra_ID = T2.Orchestra_ID GROUP BY T2.Orchestra_ID HAVING COUNT(*) > 1 --- Match Fail medium pred: SELECT orchestra.Year_of_Founded FROM conductor JOIN orchestra GROUP BY orchestra.Year_of_Founded HAVING Count(*) > 'terminal' medium gold: SELECT Year_of_Founded FROM orchestra AS T1 JOIN performance AS T2 ON T1.Orchestra_ID = T2.Orchestra_ID GROUP BY T2.Orchestra_ID HAVING COUNT(*) > 1 --- Match Fail easy pred: SELECT Count(*) FROM Highschooler WHERE Highschooler.grade = 'terminal' easy gold: SELECT count(*) FROM Highschooler --- Match Fail easy pred: SELECT Count(*) FROM Highschooler WHERE Highschooler.grade = 'terminal' easy gold: SELECT count(*) FROM Highschooler --- Match Fail medium pred: SELECT Highschooler.name, Highschooler.grade FROM Highschooler WHERE Highschooler.ID = 'terminal' medium gold: SELECT name , grade FROM Highschooler --- Match Fail medium pred: SELECT Highschooler.name, Highschooler.grade FROM Highschooler WHERE Highschooler.grade = 'terminal' medium gold: SELECT name , grade FROM Highschooler --- Match Fail easy pred: SELECT Highschooler.grade FROM Highschooler WHERE Highschooler.name = 'terminal' easy gold: SELECT grade FROM Highschooler --- Match Fail easy pred: SELECT Avg(Highschooler.grade) FROM Highschooler WHERE Highschooler.name = 'terminal' easy gold: SELECT grade FROM Highschooler --- Match OK easy pred: SELECT Highschooler.grade FROM Highschooler WHERE Highschooler.name = 'terminal' easy gold: SELECT grade FROM Highschooler WHERE name = "Kyle" --- Match OK easy pred: SELECT Highschooler.grade FROM Highschooler WHERE Highschooler.name = 'terminal' easy gold: SELECT grade FROM Highschooler WHERE name = "Kyle" --- Match OK easy pred: SELECT Highschooler.name FROM Highschooler WHERE Highschooler.grade = 'terminal' easy gold: SELECT name FROM Highschooler WHERE grade = 10 --- Match OK easy pred: SELECT Highschooler.name FROM Highschooler WHERE Highschooler.grade = 'terminal' easy gold: SELECT name FROM Highschooler WHERE grade = 10 --- Match Fail easy pred: SELECT Friend.student_id FROM Friend JOIN Highschooler WHERE Highschooler.name = 'terminal' easy gold: SELECT ID FROM Highschooler WHERE name = "Kyle" --- Match OK easy pred: SELECT Highschooler.ID FROM Highschooler WHERE Highschooler.name = 'terminal' easy gold: SELECT ID FROM Highschooler WHERE name = "Kyle" --- Match OK medium pred: SELECT Count(*) FROM Highschooler WHERE Highschooler.grade = 'terminal' OR Highschooler.grade = 'terminal' medium gold: SELECT count(*) FROM Highschooler WHERE grade = 9 OR grade = 10 --- Match OK medium pred: SELECT Count(*) FROM Highschooler WHERE Highschooler.grade = 'terminal' OR Highschooler.grade = 'terminal' medium gold: SELECT count(*) FROM Highschooler WHERE grade = 9 OR grade = 10 --- Match OK medium pred: SELECT Count(*), Highschooler.grade FROM Highschooler GROUP BY Highschooler.grade medium gold: SELECT grade , count(*) FROM Highschooler GROUP BY grade --- Match Fail medium pred: SELECT Avg(DISTINCT Highschooler.grade), Highschooler.grade FROM Friend JOIN Highschooler GROUP BY Highschooler.grade medium gold: SELECT grade , count(*) FROM Highschooler GROUP BY grade --- Match Fail hard pred: SELECT Highschooler.grade FROM Highschooler WHERE * < 'terminal' GROUP BY Highschooler.grade ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT grade FROM Highschooler GROUP BY grade ORDER BY count(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT Highschooler.name FROM Highschooler WHERE Highschooler.grade = (SELECT Highschooler.grade FROM Highschooler GROUP BY Highschooler.grade ORDER BY Count(*) Desc LIMIT 1) hard gold: SELECT grade FROM Highschooler GROUP BY grade ORDER BY count(*) DESC LIMIT 1 --- Match Fail easy pred: SELECT Highschooler.grade FROM Friend JOIN Highschooler GROUP BY Highschooler.grade HAVING Count(*) >= 'terminal' easy gold: SELECT grade FROM Highschooler GROUP BY grade HAVING count(*) >= 4 --- Match Fail easy pred: SELECT * FROM Friend JOIN Highschooler WHERE Highschooler.grade LIKE 'terminal' easy gold: SELECT grade FROM Highschooler GROUP BY grade HAVING count(*) >= 4 --- Match OK medium pred: SELECT Friend.student_id, Count(*) FROM Friend GROUP BY Friend.student_id medium gold: SELECT student_id , count(*) FROM Friend GROUP BY student_id --- Match OK medium pred: SELECT Count(*), Friend.friend_id FROM Friend GROUP BY Friend.friend_id medium gold: SELECT student_id , count(*) FROM Friend GROUP BY student_id --- Match Fail medium pred: SELECT Highschooler.name, Avg(*) FROM Friend JOIN Highschooler WHERE Highschooler.grade = 'terminal' GROUP BY Friend.student_id medium gold: SELECT T2.name , count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id --- Match Fail medium pred: SELECT Highschooler.name, Avg(*) FROM Friend JOIN Highschooler WHERE Highschooler.grade = 'terminal' GROUP BY Highschooler.name medium gold: SELECT T2.name , count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id --- Match Fail extra pred: SELECT Highschooler.name FROM Friend JOIN Highschooler GROUP BY Highschooler.name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade = 'terminal' GROUP BY Friend.student_id ORDER BY Avg(*) Desc LIMIT 1 extra gold: SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail medium pred: SELECT Highschooler.name FROM Friend JOIN Highschooler WHERE Highschooler.grade = 'terminal' GROUP BY Friend.student_id HAVING Count(*) >= 'terminal' medium gold: SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id HAVING count(*) >= 3 --- Match Fail medium pred: SELECT Highschooler.name FROM Friend JOIN Highschooler WHERE Highschooler.grade = 'terminal' GROUP BY Friend.student_id HAVING Count(*) >= 'terminal' medium gold: SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id HAVING count(*) >= 3 --- Match Fail hard pred: SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.name = 'terminal' hard gold: SELECT T3.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id JOIN Highschooler AS T3 ON T1.friend_id = T3.id WHERE T2.name = "Kyle" --- Match Fail hard pred: SELECT Highschooler.name FROM Friend JOIN Highschooler WHERE Highschooler.name = 'terminal' hard gold: SELECT T3.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id JOIN Highschooler AS T3 ON T1.friend_id = T3.id WHERE T2.name = "Kyle" --- Match Fail medium pred: SELECT Count(*) FROM Friend JOIN Highschooler WHERE Highschooler.name = 'terminal' AND Highschooler.grade = 'terminal' medium gold: SELECT count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id WHERE T2.name = "Kyle" --- Match OK medium pred: SELECT Count(*) FROM Friend JOIN Highschooler WHERE Highschooler.name = 'terminal' medium gold: SELECT count(*) FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id WHERE T2.name = "Kyle" --- Match OK hard pred: SELECT Highschooler.ID FROM Highschooler EXCEPT SELECT Friend.student_id FROM Friend hard gold: SELECT id FROM Highschooler EXCEPT SELECT student_id FROM Friend --- Match Fail hard pred: SELECT Highschooler.ID FROM Highschooler WHERE Highschooler.grade = 'terminal' EXCEPT SELECT Friend.student_id FROM Friend WHERE Highschooler.grade = 'terminal' hard gold: SELECT id FROM Highschooler EXCEPT SELECT student_id FROM Friend --- Match Fail hard pred: SELECT Highschooler.name FROM Highschooler WHERE Highschooler.ID NOT IN (SELECT Friend.student_id FROM Friend WHERE Highschooler.grade = 'terminal') hard gold: SELECT name FROM Highschooler EXCEPT SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id --- Match Fail hard pred: SELECT Highschooler.name FROM Highschooler WHERE Highschooler.ID NOT IN (SELECT Friend.student_id FROM Friend) hard gold: SELECT name FROM Highschooler EXCEPT SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id --- Match Fail hard pred: SELECT Friend.student_id FROM Friend WHERE Friend.friend_id IN (SELECT Friend.student_id FROM Friend WHERE Highschooler.grade = 'terminal' INTERSECT SELECT Friend.student_id FROM Friend WHERE Highschooler.grade = 'terminal') hard gold: SELECT student_id FROM Friend INTERSECT SELECT liked_id FROM Likes --- Match Fail hard pred: SELECT Highschooler.ID FROM Highschooler WHERE Highschooler.name = 'terminal' INTERSECT SELECT Friend.student_id FROM Highschooler JOIN Friend WHERE Highschooler.name = 'terminal' hard gold: SELECT student_id FROM Friend INTERSECT SELECT liked_id FROM Likes --- Match Fail hard pred: SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Friend.friend_id = 'terminal' INTERSECT SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Friend.friend_id = 'terminal' hard gold: SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id INTERSECT SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.liked_id = T2.id --- Match Fail hard pred: SELECT Highschooler.name FROM Highschooler JOIN Friend WHERE Highschooler.grade > 'terminal' INTERSECT SELECT Highschooler.name FROM Highschooler WHERE Highschooler.grade = 'terminal' hard gold: SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id INTERSECT SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.liked_id = T2.id --- Match OK medium pred: SELECT Likes.liked_id, Count(*) FROM Likes GROUP BY Likes.liked_id medium gold: SELECT student_id , count(*) FROM Likes GROUP BY student_id --- Match OK medium pred: SELECT Likes.student_id, Count(*) FROM Likes GROUP BY Likes.liked_id medium gold: SELECT student_id , count(*) FROM Likes GROUP BY student_id --- Match Fail medium pred: SELECT Highschooler.name, Avg(*) FROM Likes JOIN Highschooler WHERE Highschooler.grade = 'terminal' GROUP BY Highschooler.name medium gold: SELECT T2.name , count(*) FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id --- Match Fail medium pred: SELECT Highschooler.name, Avg(*) FROM Likes JOIN Highschooler WHERE Highschooler.grade = 'terminal' GROUP BY Highschooler.name medium gold: SELECT T2.name , count(*) FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id --- Match Fail extra pred: SELECT Highschooler.name FROM Likes JOIN Highschooler WHERE Highschooler.grade = 'terminal' GROUP BY Highschooler.name ORDER BY Avg(*) Desc LIMIT 1 extra gold: SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Highschooler.name FROM Friend JOIN Highschooler GROUP BY Highschooler.name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id ORDER BY count(*) DESC LIMIT 1 --- Match OK medium pred: SELECT Highschooler.name FROM Likes JOIN Highschooler GROUP BY Likes.student_id HAVING Count(*) >= 'terminal' medium gold: SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id HAVING count(*) >= 2 --- Match OK medium pred: SELECT Highschooler.name FROM Likes JOIN Highschooler GROUP BY Likes.student_id HAVING Count(*) >= 'terminal' medium gold: SELECT T2.name FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id GROUP BY T1.student_id HAVING count(*) >= 2 --- Match Fail hard pred: SELECT Highschooler.name FROM Friend JOIN Highschooler WHERE Highschooler.grade > 'terminal' INTERSECT SELECT Highschooler.name FROM Highschooler WHERE Highschooler.grade > 'terminal' hard gold: SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id WHERE T2.grade > 5 GROUP BY T1.student_id HAVING count(*) >= 2 --- Match Fail hard pred: SELECT Highschooler.name FROM Friend JOIN Highschooler WHERE Highschooler.grade > 'terminal' INTERSECT SELECT Highschooler.name FROM Highschooler WHERE Highschooler.grade > 'terminal' hard gold: SELECT T2.name FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id WHERE T2.grade > 5 GROUP BY T1.student_id HAVING count(*) >= 2 --- Match OK medium pred: SELECT Count(*) FROM Likes JOIN Highschooler WHERE Highschooler.name = 'terminal' medium gold: SELECT count(*) FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id WHERE T2.name = "Kyle" --- Match Fail medium pred: SELECT Avg(*) FROM Likes JOIN Highschooler WHERE Highschooler.name = 'terminal' medium gold: SELECT count(*) FROM Likes AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id WHERE T2.name = "Kyle" --- Match Fail hard pred: SELECT Avg(Highschooler.grade) FROM Friend JOIN Highschooler WHERE Friend.friend_id = 'terminal' hard gold: SELECT avg(grade) FROM Highschooler WHERE id IN (SELECT T1.student_id FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id) --- Match Fail hard pred: SELECT Avg(Highschooler.grade) FROM Friend JOIN Highschooler WHERE Friend.student_id = 'terminal' hard gold: SELECT avg(grade) FROM Highschooler WHERE id IN (SELECT T1.student_id FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id) --- Match Fail extra pred: SELECT Min(Highschooler.grade) FROM Highschooler WHERE Highschooler.ID NOT IN (SELECT Friend.student_id FROM Friend) extra gold: SELECT min(grade) FROM Highschooler WHERE id NOT IN (SELECT T1.student_id FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id) --- Match Fail extra pred: SELECT Highschooler.grade FROM Highschooler WHERE Highschooler.ID NOT IN (SELECT Friend.student_id FROM Friend WHERE Friend.friend_id = 'terminal') extra gold: SELECT min(grade) FROM Highschooler WHERE id NOT IN (SELECT T1.student_id FROM Friend AS T1 JOIN Highschooler AS T2 ON T1.student_id = T2.id) --- Match Fail hard pred: SELECT Professionals.state FROM Professionals UNION SELECT Professionals.state FROM Professionals hard gold: SELECT state FROM Owners INTERSECT SELECT state FROM Professionals --- Match Fail hard pred: SELECT Professionals.state FROM Professionals UNION SELECT Professionals.state FROM Professionals hard gold: SELECT state FROM Owners INTERSECT SELECT state FROM Professionals --- Match Fail hard pred: SELECT Avg(Dogs.age) FROM Dogs hard gold: SELECT avg(age) FROM Dogs WHERE dog_id IN ( SELECT dog_id FROM Treatments ) --- Match Fail hard pred: SELECT Avg(Dogs.age) FROM Dogs hard gold: SELECT avg(age) FROM Dogs WHERE dog_id IN ( SELECT dog_id FROM Treatments ) --- Match Fail extra pred: SELECT Professionals.street, Professionals.last_name, Professionals.cell_number FROM Professionals JOIN Treatments WHERE Professionals.state = 'terminal' GROUP BY Professionals.street HAVING Count(*) > 'terminal' extra gold: SELECT professional_id , last_name , cell_number FROM Professionals WHERE state = 'Indiana' UNION SELECT T1.professional_id , T1.last_name , T1.cell_number FROM Professionals AS T1 JOIN Treatments AS T2 ON T1.professional_id = T2.professional_id GROUP BY T1.professional_id HAVING count(*) > 2 --- Match Fail extra pred: SELECT Professionals.last_name, Professionals.last_name, Professionals.cell_number FROM Professionals JOIN Owners WHERE Professionals.state = 'terminal' OR Professionals.cell_number > 'terminal' GROUP BY Owners.owner_id HAVING Count(*) > 'terminal' extra gold: SELECT professional_id , last_name , cell_number FROM Professionals WHERE state = 'Indiana' UNION SELECT T1.professional_id , T1.last_name , T1.cell_number FROM Professionals AS T1 JOIN Treatments AS T2 ON T1.professional_id = T2.professional_id GROUP BY T1.professional_id HAVING count(*) > 2 --- Match Fail hard pred: SELECT Dogs.name FROM Dogs WHERE Treatments.cost_of_treatment > 'terminal' EXCEPT SELECT Dogs.name FROM Dogs JOIN Treatments WHERE Treatments.cost_of_treatment > 'terminal' hard gold: select name from dogs where dog_id not in ( select dog_id from treatments group by dog_id having sum(cost_of_treatment) > 1000 ) --- Match Fail hard pred: SELECT Dogs.name FROM Dogs WHERE Dogs.owner_id NOT IN (SELECT Owners.first_name FROM Dogs JOIN Treatments GROUP BY Dogs.owner_id HAVING Count(*) > 'terminal') hard gold: select name from dogs where dog_id not in ( select dog_id from treatments group by dog_id having sum(cost_of_treatment) > 1000 ) --- Match Fail hard pred: SELECT Professionals.first_name FROM Professionals WHERE Professionals.role_code = 'terminal' EXCEPT SELECT Professionals.first_name FROM Professionals WHERE Professionals.role_code = 'terminal' hard gold: SELECT first_name FROM Professionals UNION SELECT first_name FROM Owners EXCEPT SELECT name FROM Dogs --- Match Fail hard pred: SELECT Professionals.first_name FROM Professionals WHERE Professionals.role_code != 'terminal' EXCEPT SELECT Professionals.first_name FROM Professionals WHERE Professionals.role_code = 'terminal' hard gold: SELECT first_name FROM Professionals UNION SELECT first_name FROM Owners EXCEPT SELECT name FROM Dogs --- Match Fail extra pred: SELECT Professionals.professional_id, Professionals.email_address, Professionals.home_phone FROM Professionals EXCEPT SELECT Professionals.professional_id, Professionals.email_address, Professionals.home_phone FROM Professionals JOIN Dogs WHERE Professionals.zip_code = 'terminal' extra gold: SELECT professional_id , role_code , email_address FROM Professionals EXCEPT SELECT T1.professional_id , T1.role_code , T1.email_address FROM Professionals AS T1 JOIN Treatments AS T2 ON T1.professional_id = T2.professional_id --- Match Fail extra pred: SELECT Professionals.professional_id, Professionals.email_address, Professionals.home_phone FROM Professionals JOIN Treatments EXCEPT SELECT Professionals.professional_id, Professionals.email_address, Professionals.home_phone FROM Professionals JOIN Treatments WHERE Dogs.name = 'terminal' extra gold: SELECT professional_id , role_code , email_address FROM Professionals EXCEPT SELECT T1.professional_id , T1.role_code , T1.email_address FROM Professionals AS T1 JOIN Treatments AS T2 ON T1.professional_id = T2.professional_id --- Match Fail extra pred: SELECT Professionals.professional_id, Professionals.first_name, Professionals.last_name FROM Professionals JOIN Owners GROUP BY Owners.cell_number, Professionals.last_name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.owner_id , T2.first_name , T2.last_name FROM Dogs AS T1 JOIN Owners AS T2 ON T1.owner_id = T2.owner_id GROUP BY T1.owner_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Professionals.first_name, Professionals.first_name, Professionals.last_name FROM Professionals JOIN Treatments GROUP BY Professionals.professional_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.owner_id , T2.first_name , T2.last_name FROM Dogs AS T1 JOIN Owners AS T2 ON T1.owner_id = T2.owner_id GROUP BY T1.owner_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail medium pred: SELECT Professionals.role_code, Professionals.first_name, Professionals.first_name FROM Professionals JOIN Treatments GROUP BY Professionals.professional_id HAVING Count(*) >= 'terminal' medium gold: SELECT T1.professional_id , T1.role_code , T1.first_name FROM Professionals AS T1 JOIN Treatments AS T2 ON T1.professional_id = T2.professional_id GROUP BY T1.professional_id HAVING count(*) >= 2 --- Match OK medium pred: SELECT Professionals.role_code, Professionals.first_name, Treatments.professional_id FROM Professionals JOIN Treatments GROUP BY Treatments.professional_id HAVING Count(*) >= 'terminal' medium gold: SELECT T1.professional_id , T1.role_code , T1.first_name FROM Professionals AS T1 JOIN Treatments AS T2 ON T1.professional_id = T2.professional_id GROUP BY T1.professional_id HAVING count(*) >= 2 --- Match Fail extra pred: SELECT Owners.first_name FROM Owners GROUP BY Owners.zip_code ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.breed_name FROM Breeds AS T1 JOIN Dogs AS T2 ON T1.breed_code = T2.breed_code GROUP BY T1.breed_name ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Dogs.name FROM Dogs JOIN Professionals GROUP BY Professionals.role_code ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.breed_name FROM Breeds AS T1 JOIN Dogs AS T2 ON T1.breed_code = T2.breed_code GROUP BY T1.breed_name ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Professionals.professional_id, Professionals.last_name FROM Professionals JOIN Treatments GROUP BY Professionals.professional_id, Professionals.last_name ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.owner_id , T1.last_name FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id JOIN Treatments AS T3 ON T2.dog_id = T3.dog_id GROUP BY T1.owner_id ORDER BY count(*) DESC LIMIT 1 --- Match Fail extra pred: SELECT Owners.first_name, Owners.last_name FROM Dogs JOIN Owners JOIN Professionals GROUP BY Dogs.owner_id ORDER BY Count(*) Desc LIMIT 1 extra gold: SELECT T1.owner_id , T1.last_name FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id JOIN Treatments AS T3 ON T2.dog_id = T3.dog_id GROUP BY T1.owner_id ORDER BY count(*) DESC LIMIT 1 --- Match OK extra pred: SELECT Treatment_Types.treatment_type_description FROM Treatment_Types JOIN Treatments GROUP BY Treatments.treatment_type_code ORDER BY Sum(Treatments.cost_of_treatment) Asc LIMIT 1 extra gold: SELECT T1.treatment_type_description FROM Treatment_types AS T1 JOIN Treatments AS T2 ON T1.treatment_type_code = T2.treatment_type_code GROUP BY T1.treatment_type_code ORDER BY sum(cost_of_treatment) ASC LIMIT 1 --- Match OK extra pred: SELECT Treatment_Types.treatment_type_description FROM Treatment_Types JOIN Treatments GROUP BY Treatments.treatment_type_code ORDER BY Sum(Treatments.cost_of_treatment) Asc LIMIT 1 extra gold: SELECT T1.treatment_type_description FROM Treatment_types AS T1 JOIN Treatments AS T2 ON T1.treatment_type_code = T2.treatment_type_code GROUP BY T1.treatment_type_code ORDER BY sum(cost_of_treatment) ASC LIMIT 1 --- Match Fail extra pred: SELECT Dogs.abandoned_yn, Professionals.zip_code FROM Professionals JOIN Dogs GROUP BY Dogs.abandoned_yn ORDER BY Sum(Dogs.date_departed) Desc LIMIT 1 extra gold: SELECT T1.owner_id , T1.zip_code FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id JOIN Treatments AS T3 ON T2.dog_id = T3.dog_id GROUP BY T1.owner_id ORDER BY sum(T3.cost_of_treatment) DESC LIMIT 1 --- Match Fail extra pred: SELECT Professionals.email_address, Professionals.zip_code FROM Professionals JOIN Treatments GROUP BY Professionals.professional_id ORDER BY Sum(Treatments.cost_of_treatment) Desc LIMIT 1 extra gold: SELECT T1.owner_id , T1.zip_code FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id JOIN Treatments AS T3 ON T2.dog_id = T3.dog_id GROUP BY T1.owner_id ORDER BY sum(T3.cost_of_treatment) DESC LIMIT 1 --- Match Fail medium pred: SELECT Professionals.professional_id, Professionals.home_phone FROM Professionals JOIN Treatments GROUP BY Treatments.professional_id HAVING Count(*) >= 'terminal' medium gold: SELECT T1.professional_id , T1.cell_number FROM Professionals AS T1 JOIN Treatments AS T2 ON T1.professional_id = T2.professional_id GROUP BY T1.professional_id HAVING count(*) >= 2 --- Match Fail medium pred: SELECT Treatments.professional_id, Count(*) FROM Treatments GROUP BY Treatments.professional_id HAVING Count(*) >= 'terminal' medium gold: SELECT T1.professional_id , T1.cell_number FROM Professionals AS T1 JOIN Treatments AS T2 ON T1.professional_id = T2.professional_id GROUP BY T1.professional_id HAVING count(*) >= 2 --- Match OK extra pred: SELECT Professionals.first_name, Professionals.last_name FROM Professionals JOIN Treatments WHERE Treatments.cost_of_treatment < (SELECT Avg(Treatments.cost_of_treatment) FROM Treatments) extra gold: SELECT DISTINCT T1.first_name , T1.last_name FROM Professionals AS T1 JOIN Treatments AS T2 WHERE cost_of_treatment < ( SELECT avg(cost_of_treatment) FROM Treatments ) --- Match OK extra pred: SELECT Professionals.first_name, Professionals.last_name FROM Professionals JOIN Treatments WHERE Treatments.cost_of_treatment < (SELECT Avg(Treatments.cost_of_treatment) FROM Treatments) extra gold: SELECT DISTINCT T1.first_name , T1.last_name FROM Professionals AS T1 JOIN Treatments AS T2 WHERE cost_of_treatment < ( SELECT avg(cost_of_treatment) FROM Treatments ) --- Match Fail medium pred: SELECT Dogs.date_departed, Professionals.last_name FROM Professionals JOIN Dogs medium gold: SELECT T1.date_of_treatment , T2.first_name FROM Treatments AS T1 JOIN Professionals AS T2 ON T1.professional_id = T2.professional_id --- Match Fail medium pred: SELECT Professionals.email_address, Professionals.first_name FROM Professionals medium gold: SELECT T1.date_of_treatment , T2.first_name FROM Treatments AS T1 JOIN Professionals AS T2 ON T1.professional_id = T2.professional_id --- Match OK medium pred: SELECT Treatments.cost_of_treatment, Treatment_Types.treatment_type_description FROM Treatment_Types JOIN Treatments medium gold: SELECT T1.cost_of_treatment , T2.treatment_type_description FROM Treatments AS T1 JOIN treatment_types AS T2 ON T1.treatment_type_code = T2.treatment_type_code --- Match Fail medium pred: SELECT Treatment_Types.treatment_type_code, Treatment_Types.treatment_type_description FROM Treatment_Types JOIN Treatments medium gold: SELECT T1.cost_of_treatment , T2.treatment_type_description FROM Treatments AS T1 JOIN treatment_types AS T2 ON T1.treatment_type_code = T2.treatment_type_code --- Match Fail medium pred: SELECT Professionals.first_name, Professionals.last_name, Owners.last_name FROM Professionals JOIN Owners medium gold: SELECT T1.first_name , T1.last_name , T2.size_code FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id --- Match Fail medium pred: SELECT Professionals.first_name, Professionals.last_name, Professionals.last_name FROM Professionals medium gold: SELECT T1.first_name , T1.last_name , T2.size_code FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id --- Match OK medium pred: SELECT Owners.first_name, Dogs.name FROM Owners JOIN Dogs medium gold: SELECT T1.first_name , T2.name FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id --- Match Fail medium pred: SELECT Professionals.first_name, Dogs.name FROM Professionals JOIN Dogs medium gold: SELECT T1.first_name , T2.name FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id --- Match Fail extra pred: SELECT Professionals.first_name, Professionals.last_name FROM Dogs JOIN Professionals ORDER BY Dogs.date_departed Desc LIMIT 1 extra gold: SELECT T1.name , T2.date_of_treatment FROM Dogs AS T1 JOIN Treatments AS T2 ON T1.dog_id = T2.dog_id WHERE T1.breed_code = ( SELECT breed_code FROM Dogs GROUP BY breed_code ORDER BY count(*) ASC LIMIT 1 ) --- Match Fail extra pred: SELECT Dogs.name, Dogs.date_departed FROM Dogs ORDER BY Dogs.date_departed Desc LIMIT 1 extra gold: SELECT T1.name , T2.date_of_treatment FROM Dogs AS T1 JOIN Treatments AS T2 ON T1.dog_id = T2.dog_id WHERE T1.breed_code = ( SELECT breed_code FROM Dogs GROUP BY breed_code ORDER BY count(*) ASC LIMIT 1 ) --- Match Fail medium pred: SELECT Owners.first_name, Dogs.name FROM Owners JOIN Dogs JOIN Professionals WHERE Owners.state = 'terminal' medium gold: SELECT T1.first_name , T2.name FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id WHERE T1.state = 'Virginia' --- Match Fail medium pred: SELECT Owners.first_name, Owners.last_name FROM Owners WHERE Owners.state = 'terminal' medium gold: SELECT T1.first_name , T2.name FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id WHERE T1.state = 'Virginia' --- Match Fail medium pred: SELECT Dogs.date_of_birth, Treatments.cost_of_treatment FROM Dogs JOIN Treatments medium gold: SELECT DISTINCT T1.date_arrived , T1.date_departed FROM Dogs AS T1 JOIN Treatments AS T2 ON T1.dog_id = T2.dog_id --- Match Fail medium pred: SELECT Dogs.date_of_birth, Dogs.date_adopted FROM Dogs medium gold: SELECT DISTINCT T1.date_arrived , T1.date_departed FROM Dogs AS T1 JOIN Treatments AS T2 ON T1.dog_id = T2.dog_id --- Match Fail extra pred: SELECT Professionals.last_name FROM Professionals JOIN Dogs WHERE Dogs.age = (SELECT Min(Dogs.age) FROM Dogs) extra gold: SELECT T1.last_name FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id WHERE T2.age = ( SELECT max(age) FROM Dogs ) --- Match Fail extra pred: SELECT Professionals.last_name FROM Professionals JOIN Dogs WHERE Dogs.age = (SELECT Min(Dogs.age) FROM Dogs) extra gold: SELECT T1.last_name FROM Owners AS T1 JOIN Dogs AS T2 ON T1.owner_id = T2.owner_id WHERE T2.age = ( SELECT max(age) FROM Dogs ) --- Match OK medium pred: SELECT Professionals.email_address FROM Professionals WHERE Professionals.state = 'terminal' OR Professionals.state = 'terminal' medium gold: SELECT email_address FROM Professionals WHERE state = 'Hawaii' OR state = 'Wisconsin' --- Match OK medium pred: SELECT Professionals.email_address FROM Professionals WHERE Professionals.state = 'terminal' OR Professionals.state = 'terminal' medium gold: SELECT email_address FROM Professionals WHERE state = 'Hawaii' OR state = 'Wisconsin' --- Match Fail medium pred: SELECT Dogs.date_of_birth, Dogs.date_arrived FROM Dogs medium gold: SELECT date_arrived , date_departed FROM Dogs --- Match Fail medium pred: SELECT Dogs.date_of_birth, Dogs.date_adopted FROM Dogs medium gold: SELECT date_arrived , date_departed FROM Dogs --- Match Fail easy pred: SELECT Count(*) FROM Dogs easy gold: SELECT count(DISTINCT dog_id) FROM Treatments --- Match Fail easy pred: SELECT Count(*) FROM Dogs easy gold: SELECT count(DISTINCT dog_id) FROM Treatments --- Match Fail easy pred: SELECT Count(*) FROM Professionals JOIN Treatments JOIN Dogs WHERE Dogs.name = 'terminal' easy gold: SELECT count(DISTINCT professional_id) FROM Treatments --- Match Fail easy pred: SELECT Count(*) FROM Professionals easy gold: SELECT count(DISTINCT professional_id) FROM Treatments --- Match Fail medium pred: SELECT Professionals.role_code, Professionals.city, Professionals.state FROM Professionals WHERE Professionals.role_code LIKE 'terminal' medium gold: SELECT role_code , street , city , state FROM professionals WHERE city LIKE '%West%' --- Match Fail medium pred: SELECT Professionals.role_code, Professionals.city, Professionals.state FROM Professionals WHERE Professionals.first_name = 'terminal' medium gold: SELECT role_code , street , city , state FROM professionals WHERE city LIKE '%West%' --- Match Fail medium pred: SELECT Professionals.first_name, Professionals.email_address, Professionals.home_phone FROM Professionals WHERE Professionals.state LIKE 'terminal' medium gold: SELECT first_name , last_name , email_address FROM Owners WHERE state LIKE '%North%' --- Match Fail medium pred: SELECT Owners.first_name, Owners.last_name, Professionals.home_phone FROM Owners JOIN Professionals WHERE Professionals.state LIKE 'terminal' medium gold: SELECT first_name , last_name , email_address FROM Owners WHERE state LIKE '%North%' --- Match OK hard pred: SELECT Count(*) FROM Dogs WHERE Dogs.age < (SELECT Avg(Dogs.age) FROM Dogs) hard gold: SELECT count(*) FROM Dogs WHERE age < ( SELECT avg(age) FROM Dogs ) --- Match OK hard pred: SELECT Count(*) FROM Dogs WHERE Dogs.age < (SELECT Avg(Dogs.age) FROM Dogs) hard gold: SELECT count(*) FROM Dogs WHERE age < ( SELECT avg(age) FROM Dogs ) --- Match Fail medium pred: SELECT Treatments.date_of_treatment FROM Treatments ORDER BY Treatments.date_of_treatment Asc LIMIT 1 medium gold: SELECT cost_of_treatment FROM Treatments ORDER BY date_of_treatment DESC LIMIT 1 --- Match Fail medium pred: SELECT Treatments.cost_of_treatment FROM Treatments ORDER BY Treatments.cost_of_treatment Desc LIMIT 1 medium gold: SELECT cost_of_treatment FROM Treatments ORDER BY date_of_treatment DESC LIMIT 1 --- Match Fail extra pred: SELECT Count(*) FROM Dogs WHERE Dogs.dog_id NOT IN (SELECT Dogs.owner_id FROM Dogs) extra gold: SELECT count(*) FROM Dogs WHERE dog_id NOT IN ( SELECT dog_id FROM Treatments ) --- Match Fail extra pred: SELECT Count(*) FROM Dogs WHERE Dogs.dog_id NOT IN (SELECT Treatments.dog_id FROM Dogs) extra gold: select count(*) from dogs where dog_id not in ( select dog_id from treatments ) --- Match Fail extra pred: SELECT Count(*) FROM Professionals WHERE Professionals.cell_number NOT IN (SELECT Dogs.owner_id FROM Dogs) extra gold: SELECT count(*) FROM Owners WHERE owner_id NOT IN ( SELECT owner_id FROM Dogs ) --- Match Fail extra pred: SELECT Count(*) FROM Professionals WHERE Professionals.professional_id NOT IN (SELECT Dogs.owner_id FROM Dogs) extra gold: SELECT count(*) FROM Owners WHERE owner_id NOT IN ( SELECT owner_id FROM Dogs ) --- Match OK extra pred: SELECT Count(*) FROM Professionals WHERE Professionals.professional_id NOT IN (SELECT Treatments.professional_id FROM Treatments) extra gold: SELECT count(*) FROM Professionals WHERE professional_id NOT IN ( SELECT professional_id FROM Treatments ) --- Match OK extra pred: SELECT Count(*) FROM Professionals WHERE Professionals.professional_id NOT IN (SELECT Treatments.professional_id FROM Treatments) extra gold: SELECT count(*) FROM Professionals WHERE professional_id NOT IN ( SELECT professional_id FROM Treatments ) --- Match Fail medium pred: SELECT Dogs.name, Dogs.age, Dogs.weight FROM Owners JOIN Dogs WHERE Breeds.breed_name = 'terminal' INTERSECT SELECT Dogs.name, Dogs.age, Dogs.weight FROM Owners JOIN Dogs WHERE Breeds.breed_name = 'terminal' medium gold: SELECT name , age , weight FROM Dogs WHERE abandoned_yn = 1 --- Match Fail medium pred: SELECT Dogs.name, Dogs.age, Dogs.weight FROM Dogs JOIN Owners WHERE Treatments.cost_of_treatment = 'terminal' EXCEPT SELECT Dogs.name, Dogs.age, Dogs.weight FROM Dogs JOIN Owners WHERE Owners.first_name = 'terminal' medium gold: SELECT name , age , weight FROM Dogs WHERE abandoned_yn = 1 --- Match OK easy pred: SELECT Avg(Dogs.age) FROM Dogs easy gold: SELECT avg(age) FROM Dogs --- Match OK easy pred: SELECT Avg(Dogs.age) FROM Dogs easy gold: SELECT avg(age) FROM Dogs --- Match OK easy pred: SELECT Max(Dogs.age) FROM Dogs easy gold: SELECT max(age) FROM Dogs --- Match OK easy pred: SELECT Max(Dogs.age) FROM Dogs easy gold: SELECT max(age) FROM Dogs --- Match Fail medium pred: SELECT Treatments.treatment_type_code, Max(Treatments.cost_of_treatment) FROM Treatments GROUP BY Treatments.treatment_type_code medium gold: SELECT charge_type , charge_amount FROM Charges --- Match Fail medium pred: SELECT Treatments.treatment_type_code, Count(*) FROM Treatments GROUP BY Treatments.treatment_type_code medium gold: SELECT charge_type , charge_amount FROM Charges --- Match Fail easy pred: SELECT Treatments.treatment_type_code FROM Treatments ORDER BY Treatments.cost_of_treatment Desc LIMIT 1 easy gold: SELECT max(charge_amount) FROM Charges --- Match Fail easy pred: SELECT Treatments.treatment_type_code FROM Treatments ORDER BY Treatments.cost_of_treatment Desc LIMIT 1 easy gold: SELECT max(charge_amount) FROM Charges --- Match OK medium pred: SELECT Professionals.email_address, Professionals.home_phone, Professionals.cell_number FROM Professionals medium gold: SELECT email_address , cell_number , home_phone FROM professionals --- Match OK medium pred: SELECT Professionals.email_address, Professionals.home_phone, Professionals.cell_number FROM Professionals medium gold: SELECT email_address , cell_number , home_phone FROM professionals --- Match Fail medium pred: SELECT Treatment_Types.treatment_type_code, Treatment_Types.treatment_type_description FROM Treatments JOIN Treatment_Types medium gold: SELECT DISTINCT breed_code , size_code FROM dogs --- Match Fail medium pred: SELECT DISTINCT Treatment_Types.treatment_type_code, Treatment_Types.treatment_type_description FROM Treatment_Types medium gold: SELECT DISTINCT breed_code , size_code FROM dogs --- Match Fail medium pred: SELECT Professionals.first_name, Professionals.last_name FROM Professionals JOIN Treatments medium gold: SELECT DISTINCT T1.first_name , T3.treatment_type_description FROM professionals AS T1 JOIN Treatments AS T2 ON T1.professional_id = T2.professional_id JOIN Treatment_types AS T3 ON T2.treatment_type_code = T3.treatment_type_code --- Match Fail medium pred: SELECT Professionals.first_name, Professionals.last_name FROM Professionals medium gold: SELECT DISTINCT T1.first_name , T3.treatment_type_description FROM professionals AS T1 JOIN Treatments AS T2 ON T1.professional_id = T2.professional_id JOIN Treatment_types AS T3 ON T2.treatment_type_code = T3.treatment_type_code --- Match OK easy pred: SELECT Count(*) FROM singer easy gold: SELECT count(*) FROM singer --- Match Fail easy pred: SELECT Count(*) FROM song easy gold: SELECT count(*) FROM singer --- Match Fail easy pred: SELECT singer.Name FROM singer ORDER BY singer.Birth_Year Asc easy gold: SELECT Name FROM singer ORDER BY Net_Worth_Millions ASC --- Match Fail easy pred: SELECT singer.Name FROM singer ORDER BY singer.Birth_Year Asc easy gold: SELECT Name FROM singer ORDER BY Net_Worth_Millions ASC --- Match Fail medium pred: SELECT singer.Birth_Year, song.Highest_Position FROM singer JOIN song medium gold: SELECT Birth_Year , Citizenship FROM singer --- Match OK medium pred: SELECT singer.Birth_Year, singer.Citizenship FROM singer medium gold: SELECT Birth_Year , Citizenship FROM singer --- Match OK easy pred: SELECT singer.Name FROM singer WHERE singer.Citizenship != 'terminal' easy gold: SELECT Name FROM singer WHERE Citizenship != "France" --- Match OK easy pred: SELECT singer.Name FROM singer WHERE singer.Citizenship != 'terminal' easy gold: SELECT Name FROM singer WHERE Citizenship != "France" --- Match Fail medium pred: SELECT singer.Name FROM singer JOIN song WHERE singer.Birth_Year = 'terminal' OR singer.Birth_Year = 'terminal' medium gold: SELECT Name FROM singer WHERE Birth_Year = 1948 OR Birth_Year = 1949 --- Match OK medium pred: SELECT singer.Name FROM singer WHERE singer.Birth_Year = 'terminal' OR singer.Birth_Year = 'terminal' medium gold: SELECT Name FROM singer WHERE Birth_Year = 1948 OR Birth_Year = 1949 --- Match Fail medium pred: SELECT singer.Name FROM singer JOIN song ORDER BY song.Title Desc LIMIT 1 medium gold: SELECT Name FROM singer ORDER BY Net_Worth_Millions DESC LIMIT 1 --- Match Fail medium pred: SELECT singer.Name FROM singer JOIN song GROUP BY singer.Name ORDER BY Count(*) Desc LIMIT 1 medium gold: SELECT Name FROM singer ORDER BY Net_Worth_Millions DESC LIMIT 1 --- Match Fail medium pred: SELECT song.Highest_Position, Count(*) FROM song GROUP BY song.Highest_Position medium gold: SELECT Citizenship , COUNT(*) FROM singer GROUP BY Citizenship --- Match Fail medium pred: SELECT song.Highest_Position, Count(*) FROM song GROUP BY song.Highest_Position medium gold: SELECT Citizenship , COUNT(*) FROM singer GROUP BY Citizenship --- Match Fail hard pred: SELECT song.Highest_Position FROM song GROUP BY song.Highest_Position ORDER BY Count(*) Desc LIMIT 1 hard gold: SELECT Citizenship FROM singer GROUP BY Citizenship ORDER BY COUNT(*) DESC LIMIT 1 --- Match Fail hard pred: SELECT song.Highest_Position FROM song GROUP BY song.Highest_Position ORDER BY Count(*) Desc LIMIT 1 hard gold: select citizenship from singer group by citizenship order by count(*) desc limit 1 --- Match Fail medium pred: SELECT song.Highest_Position, Max(*) FROM song GROUP BY song.Highest_Position medium gold: SELECT Citizenship , max(Net_Worth_Millions) FROM singer GROUP BY Citizenship --- Match Fail medium pred: SELECT song.Highest_Position, Sum(singer.Birth_Year) FROM singer JOIN song GROUP BY song.Highest_Position medium gold: SELECT Citizenship , max(Net_Worth_Millions) FROM singer GROUP BY Citizenship --- Match OK medium pred: SELECT song.Title, singer.Name FROM song JOIN singer medium gold: SELECT T2.Title , T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID = T2.Singer_ID --- Match OK medium pred: SELECT song.Title, singer.Name FROM song JOIN singer medium gold: SELECT T2.Title , T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID = T2.Singer_ID --- Match OK medium pred: SELECT DISTINCT singer.Name FROM singer JOIN song WHERE song.Sales > 'terminal' medium gold: SELECT DISTINCT T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID = T2.Singer_ID WHERE T2.Sales > 300000 --- Match Fail medium pred: SELECT DISTINCT song.Title FROM song WHERE song.Sales > 'terminal' medium gold: SELECT DISTINCT T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID = T2.Singer_ID WHERE T2.Sales > 300000 --- Match OK medium pred: SELECT singer.Name FROM singer JOIN song GROUP BY singer.Name HAVING Count(*) > 'terminal' medium gold: SELECT T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID = T2.Singer_ID GROUP BY T1.Name HAVING COUNT(*) > 1 --- Match OK medium pred: SELECT singer.Name FROM singer JOIN song GROUP BY singer.Name HAVING Count(*) > 'terminal' medium gold: SELECT T1.Name FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID = T2.Singer_ID GROUP BY T1.Name HAVING COUNT(*) > 1 --- Match OK medium pred: SELECT singer.Name, Sum(song.Sales) FROM singer JOIN song GROUP BY singer.Name medium gold: SELECT T1.Name , sum(T2.Sales) FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID = T2.Singer_ID GROUP BY T1.Name --- Match OK medium pred: SELECT singer.Name, Sum(song.Sales) FROM singer JOIN song GROUP BY singer.Name medium gold: SELECT T1.Name , sum(T2.Sales) FROM singer AS T1 JOIN song AS T2 ON T1.Singer_ID = T2.Singer_ID GROUP BY T1.Name --- Match OK hard pred: SELECT singer.Name FROM singer WHERE singer.Singer_ID NOT IN (SELECT song.Singer_ID FROM song) hard gold: SELECT Name FROM singer WHERE Singer_ID NOT IN (SELECT Singer_ID FROM song) --- Match Fail hard pred: SELECT song.Highest_Position FROM singer JOIN song WHERE singer.Name != 'terminal' hard gold: SELECT Name FROM singer WHERE Singer_ID NOT IN (SELECT Singer_ID FROM song) --- Match Fail hard pred: SELECT song.Highest_Position FROM singer JOIN song WHERE singer.Birth_Year < 'terminal' INTERSECT SELECT singer.Name FROM singer JOIN song WHERE singer.Birth_Year < 'terminal' hard gold: SELECT Citizenship FROM singer WHERE Birth_Year < 1945 INTERSECT SELECT Citizenship FROM singer WHERE Birth_Year > 1955 --- Match Fail hard pred: SELECT singer.Name FROM singer WHERE singer.Birth_Year < 'terminal' INTERSECT SELECT singer.Name FROM singer WHERE singer.Birth_Year < 'terminal' hard gold: SELECT Citizenship FROM singer WHERE Birth_Year < 1945 INTERSECT SELECT Citizenship FROM singer WHERE Birth_Year > 1955 --- Match Fail easy pred: SELECT Count(*) FROM Ref_Feature_Types easy gold: SELECT count(*) FROM Other_Available_Features --- Match OK medium pred: SELECT Ref_Feature_Types.feature_type_name FROM Ref_Feature_Types JOIN Other_Available_Features WHERE Other_Available_Features.feature_name = 'terminal' medium gold: SELECT T2.feature_type_name FROM Other_Available_Features AS T1 JOIN Ref_Feature_Types AS T2 ON T1.feature_type_code = T2.feature_type_code WHERE T1.feature_name = "AirCon" --- Match Fail medium pred: SELECT Ref_Property_Types.property_type_description FROM Ref_Property_Types WHERE Ref_Property_Types.property_type_code = 'terminal' medium gold: SELECT T2.property_type_description FROM Properties AS T1 JOIN Ref_Property_Types AS T2 ON T1.property_type_code = T2.property_type_code GROUP BY T1.property_type_code --- Match Fail hard pred: SELECT Properties.property_name FROM Properties WHERE Properties.room_count > 'terminal' OR Properties.room_count > 'terminal' hard gold: SELECT property_name FROM Properties WHERE property_type_code = "House" UNION SELECT property_name FROM Properties WHERE property_type_code = "Apartment" AND room_count > 1 --- easy medium hard extra all count 248 446 174 166 1034 ====================== EXACT MATCHING ACCURACY ===================== exact match 0.560 0.422 0.333 0.277 0.417 ---------------------PARTIAL MATCHING ACCURACY---------------------- select 0.742 0.646 0.764 0.608 0.683 select(no AGG) 0.750 0.675 0.776 0.614 0.700 where 0.731 0.589 0.489 0.367 0.560 where(no OP) 0.759 0.604 0.553 0.478 0.605 group(no Having) 0.667 0.623 0.564 0.544 0.595 group 0.619 0.592 0.538 0.544 0.572 order 0.481 0.403 0.635 0.835 0.609 and/or 1.000 0.964 0.977 0.902 0.965 IUEN 0.000 0.000 0.271 0.429 0.275 keywords 0.839 0.837 0.747 0.776 0.808 ---------------------- PARTIAL MATCHING RECALL ---------------------- select 0.742 0.646 0.764 0.608 0.683 select(no AGG) 0.750 0.675 0.776 0.614 0.700 where 0.731 0.637 0.489 0.351 0.573 where(no OP) 0.759 0.654 0.553 0.457 0.619 group(no Having) 0.700 0.609 0.564 0.544 0.590 group 0.650 0.579 0.538 0.544 0.568 order 0.591 0.413 0.600 0.835 0.619 and/or 0.996 0.995 0.988 0.967 0.990 IUEN 0.000 0.000 0.310 0.353 0.329 keywords 0.867 0.841 0.730 0.771 0.810 ---------------------- PARTIAL MATCHING F1 -------------------------- select 0.742 0.646 0.764 0.608 0.683 select(no AGG) 0.750 0.675 0.776 0.614 0.700 where 0.731 0.612 0.489 0.359 0.567 where(no OP) 0.759 0.628 0.553 0.467 0.612 group(no Having) 0.683 0.616 0.564 0.544 0.593 group 0.634 0.586 0.538 0.544 0.570 order 0.531 0.408 0.617 0.835 0.614 and/or 0.998 0.979 0.982 0.933 0.977 IUEN 1.000 1.000 0.289 0.387 0.299 keywords 0.852 0.839 0.738 0.773 0.809