Database: language_corpus
Question: How many words are there on the page that the word "grec" has occurred for 52 times?
Evidence: the word "grec" refers to word = 'grec'; occurred for 52 times refers to occurrences = 52
SQL: SELECT SUM(T3.words) FROM words AS T1 INNER JOIN pages_words AS T2 ON T1.wid = T2.wid INNER JOIN pages AS T3 ON T2.pid = T3.pid WHERE T1.word = 'grec' AND T2.occurrences = 52

Database: disney
Question: Name the first movie released by Disney.
Evidence: The first movie released refers to movie_title where substr(release_date, length(release_date) - 1, length(release_date)) asc limit 1;
SQL: SELECT movie_title FROM characters ORDER BY SUBSTR(release_date, LENGTH(release_date) - 1, LENGTH(release_date)) ASC LIMIT 1

Database: synthea
Question: Indicate the care plan needed for the patient living at 179 Sydni Roads, Taunton, MA 02780 US.
Evidence: living at 179 Sydni Roads, Taunton, MA 02780 US refers to address = '179 Sydni Roads Taunton MA 02780 US';
SQL: SELECT T1.DESCRIPTION FROM careplans AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T2.address = '179 Sydni Roads Taunton MA 02780 US'

Database: professional_basketball
Question: Among players who were born after 1950, who had offence rebounds rates more than 30%? Please list their last names and first names.
Evidence: born after 1950 refers to birthDate > = '1950-01-01'; offence rebound rate more than 30% refers to Divide (oRebounds, rebounds) > 0.3
SQL: SELECT DISTINCT T1.lastName, T1.firstName FROM players AS T1 INNER JOIN player_allstar AS T2 ON T1.playerID = T2.playerID WHERE T1.birthDate > 1950 AND CAST(T2.o_rebounds AS REAL) * 100 / T2.rebounds > 30

Database: disney
Question: Who is the villain in Little Mermaid?
Evidence: Little Mermaid refers to movie_title = 'Little Mermaid';
SQL: SELECT villian FROM characters WHERE movie_title = 'Little Mermaid'

Database: beer_factory
Question: What is the name of the root beer brand that has the longest history?
Evidence: name of the root beer brand refers to BrandName; longest history refers to MIN(FirstBrewedYear);
SQL: SELECT BrandName FROM rootbeerbrand WHERE FirstBrewedYear = ( SELECT MIN(FirstBrewedYear) FROM rootbeerbrand )

Database: books
Question: List down the ISBN of the books purchased by the customer with an email of fsier3e@ihg.com.
Evidence: "fsier3e@ihg.com" is the email of customer; ISBN refers to isbn13
SQL: SELECT T1.isbn13 FROM book AS T1 INNER JOIN order_line AS T2 ON T1.book_id = T2.book_id INNER JOIN cust_order AS T3 ON T3.order_id = T2.order_id INNER JOIN customer AS T4 ON T4.customer_id = T3.customer_id WHERE T4.email = 'fsier3e@ihg.com'

Database: food_inspection_2
Question: Provide the salary range of the employee involved in the inspection ID 58424.
SQL: SELECT T1.salary, T3.salary FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id INNER JOIN employee AS T3 WHERE T2.inspection_id = 58424 ORDER BY T1.salary, T3.salary DESC LIMIT 1

Database: food_inspection_2
Question: How much salary does Jessica Anthony receive?
SQL: SELECT salary FROM employee WHERE first_name = 'Jessica' AND last_name = 'Anthony'

Database: talkingdata
Question: Locate all events on devices of women under 30 years old.
Evidence: locate = longitude, latitude; women refers to gender = 'F'; under 30 years old refers to age < 30;
SQL: SELECT T1.device_id FROM gender_age AS T1 INNER JOIN events_relevant AS T2 ON T1.device_id = T2.device_id WHERE T1.gender = 'F' AND T1.age < 30

Database: restaurant
Question: List all the streets where pizza-serving restaurants are found in San Jose.
Evidence: street refers to street_name; pizza-serving restaurant refers to food_type = 'pizza'; San Jose refers to city = 'san jose'
SQL: SELECT T1.street_name FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.city = T2.city WHERE T2.food_type = 'pizza' AND T1.city = 'san jose'

Database: retail_complains
Question: What is the number of complaints related to Credit cards came from female clients?
Evidence: Credit cards refers to Product = 'Credit card'; female refers to sex = 'female';
SQL: SELECT COUNT(T1.sex) FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T1.sex = 'Female' AND T2.Product = 'Credit card'

Database: menu
Question: How many dishes appear in the right upper corner of the menu page?
Evidence: appear in the right upper corner of the menu page refers to xpos > 0.75 and ypos < 0.25;
SQL: SELECT COUNT(*) FROM MenuItem AS T1 INNER JOIN Dish AS T2 ON T1.dish_id = T2.id WHERE T1.xpos > 0.75 AND T1.ypos < 0.25

Database: talkingdata
Question: Which category has the highest number of users?
Evidence: highest number of users refers to MAX(COUNT(app_id));
SQL: SELECT T.category FROM ( SELECT T2.category, COUNT(T1.app_id) AS num FROM app_labels AS T1 INNER JOIN label_categories AS T2 ON T2.label_id = T1.label_id GROUP BY T1.app_id, T2.category ) AS T ORDER BY T.num DESC LIMIT 1

Database: public_review_platform
Question: Sum up the likes get by short reviews on businesses located in City Goodyear.
Evidence: short reviews refer to tip_length = 'Short';
SQL: SELECT SUM(T2.likes) AS likes FROM Business AS T1 INNER JOIN Tips AS T2 ON T1.business_id = T2.business_id WHERE T1.city = 'Goodyear'

Database: world
Question: Give the cities and district names that belong to the country with Hajastan as its local name.
SQL: SELECT T2.Name, T2.District FROM Country AS T1 INNER JOIN City AS T2 ON T1.Code = T2.CountryCode WHERE T1.LocalName = 'Hajastan'

Database: world_development_indicators
Question: How many of the countries do not have special notes? List the long name.
Evidence: do not have special notes implies SpecialNotes are NULL;
SQL: SELECT COUNT(LongName) FROM Country WHERE SpecialNotes = '' UNION SELECT longname FROM country WHERE specialnotes = ''

Database: soccer_2016
Question: Name the teams played in a match which resulted in a tie in 2015.
Evidence: resulted in a tie refers to Win_Type = 'Tie'; in 2015 refers to SUBSTR(Match_Date, 1, 4) = 2015
SQL: SELECT T1.Team_Name FROM Team AS T1 INNER JOIN Match AS T2 ON T1.Team_Id = T2.Team_1 OR T1.Team_Id = T2.Team_2 INNER JOIN Win_By AS T3 ON T2.Win_Type = T3.Win_Id WHERE SUBSTR(T2.Match_Date, 1, 4) = '2015' AND T3.Win_Type = 'Tie' LIMIT 1

Database: superstore
Question: How many orders were made by Alan Barnes in 2015 at the Central superstore?
Evidence: in 2015 refers to "Order Date" = '2015%'
SQL: SELECT COUNT(DISTINCT T2.`Order ID`) FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T1.`Customer Name` = 'Alan Barnes' AND STRFTIME('%Y', T2.`Order Date`) = '2015'

Database: university
Question: Provide the name of the university with the highest number of male students.
Evidence: highest number of female students refers to MAX(SUBTRACT(num_students, DIVIDE(MULTIPLY(num_students, pct_female_students), 100))); name of university refers to university_name
SQL: SELECT T2.university_name FROM university_year AS T1 INNER JOIN university AS T2 ON T1.university_id = T2.id ORDER BY T1.num_students * T1.pct_female_students / 100 - T1.num_students DESC LIMIT 1

Database: bike_share_1
Question: On 10/20/2014, what is the duration of the fastest trip which started from the station with latitude and longitudes of 37.789625 and -122.400811, respectively? Indicate the bike id.
Evidence: lat = '37.789625' and long = '-122.400811' are latitude and longitude coordinates indicating location; started from the station refers to start_station_name; start_date = '10/20/2014'; duration of the fastest trip refers to MIN(duration);
SQL: SELECT MIN(T2.duration), T2.bike_id FROM station AS T1 INNER JOIN trip AS T2 ON T2.start_station_name = T1.name WHERE T2.start_date LIKE '10/20/2014%' AND T1.lat = 37.789625 AND T1.long = -122.400811