gap-text2sql / gap-text2sql-main /mrat-sql-gap /inference-results /BERTimbau-base-pt-train /spider_eval_match_ratsqlgap-bertimbau-base-step24100.txt
| 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 | |