Database: european_football_1
Question: How many Away Victories happened on 2016/3/27 in the LaLiga 2 division?
Evidence: Away victories refer to FTR = 'A'; LaLiga 2 is the name of division; Date = '2016-03-27';
SQL: SELECT COUNT(T1.FTR) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'LaLiga 2' AND T1.Date = '2016-03-27' AND T1.FTR = 'A'

Database: car_retails
Question: How many checks were issued by Euro+ Shopping Channel in the year 2004?
Evidence: Euro+ Shopping Channel is a customer name; year(paymentDate) = '2004';
SQL: SELECT COUNT(T1.checkNumber) FROM payments AS T1 INNER JOIN customers AS T2 ON T1.customerNumber = T2.customerNumber WHERE customerName = 'Euro+ Shopping Channel' AND STRFTIME('%Y', T1.paymentDate) = '2004'

Database: shipping
Question: How many shipments were ordered by S K L Enterprises Inc in 2017?
Evidence: "S K L Enterprises Inc" is the cust_name; in 2017 refers to Cast(ship_date AS DATE) = 2017
SQL: SELECT COUNT(T2.ship_id) FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id WHERE T1.cust_name = 'S K L Enterprises Inc' AND STRFTIME('%Y', T2.ship_date) = '2017'

Database: movielens
Question: List the user ids and ages who gave the rate 2 to the movie No. 2409051.
SQL: SELECT T1.userid, T1.age FROM users AS T1 INNER JOIN u2base AS T2 ON T1.userid = T2.userid WHERE T2.movieid = '2409051' AND T2.rating = 2

Database: music_platform_2
Question: Name all the categories for podcast titled 'I Heart My Life Show'.
Evidence: 'I Hearty My Life Show' is the title of podcast
SQL: SELECT T1.category FROM categories AS T1 INNER JOIN podcasts AS T2 ON T2.podcast_id = T1.podcast_id WHERE T2.title = 'I Heart My Life Show'

Database: codebase_comments
Question: What is the solution path for the method "IQ.Data.DbQueryProvider.CanBeEvaluatedLocally"?
Evidence: solution path refers to Path; method refers to Name; Name = 'IQ.Data.DbQueryProvider.CanBeEvaluatedLocally'
SQL: SELECT T1.Path FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.Name = 'IQ.Data.DbQueryProvider.CanBeEvaluatedLocally'

Database: student_loan
Question: How many students have never been absent in school?
Evidence: never been absent in school refers to month = 0;
SQL: SELECT COUNT(name) FROM longest_absense_from_school WHERE month = 0

Database: movie_3
Question: Which category does BABY HALL film belong to?
Evidence: category refers to name; BABY HALL film refers to title = 'BABY HALL'
SQL: SELECT T3.`name` FROM film AS T1 INNER JOIN film_category AS T2 ON T1.film_id = T2.film_id INNER JOIN category AS T3 ON T3.category_id = T2.category_id WHERE T1.title = 'BABY HALL'

Database: donor
Question: Who is the largest donor by amount? Give the donation id and the total amount of the donation.
Evidence: largest donor by amount refers to max(donation_total); total amount of the donation refers to donation_total
SQL: SELECT donationid, donation_total FROM donations ORDER BY donation_total DESC LIMIT 1

Database: shakespeare
Question: What is the paragraph number with plain text "This is Illyria, lady"?
Evidence: paragraph number refers to ParagraphNum
SQL: SELECT ParagraphNum FROM paragraphs WHERE PlainText = 'This is Illyria, lady.'

Database: music_tracker
Question: How many christmas albums were released in 2004?
Evidence: album refers to releaseType; groupYear = 2004; tag = 'christmas';
SQL: SELECT COUNT(T1.id) FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T2.tag = 'christmas' AND T1.groupYear = 2004 AND T1.releaseType LIKE 'album'

Database: sales
Question: List the full name of the customer who purchased the most quantity of products.
Evidence: full name of the customer = FirstName, LastName; most quantity refers to MAX(Quantity);
SQL: SELECT T1.FirstName, T1.LastName FROM Customers AS T1 INNER JOIN Sales AS T2 ON T1.CustomerID = T2.CustomerID ORDER BY T2.Quantity DESC LIMIT 1

Database: books
Question: How many orders did Marcelia Goering place in 2021 that uses the Priority Shipping method?
Evidence: in 2021 refers to substr(order_date, 1, 4) = '2021'; priority shipping method refers to method_name = 'Priority'
SQL: SELECT COUNT(*) FROM customer AS T1 INNER JOIN cust_order AS T2 ON T1.customer_id = T2.customer_id INNER JOIN shipping_method AS T3 ON T3.method_id = T2.shipping_method_id WHERE T1.first_name = 'Marcelia' AND T1.last_name = 'Goering' AND STRFTIME('%Y', T2.order_date) = '2021' AND T3.method_name = 'Priority'

Database: restaurant
Question: Please indicate the street names of restaurants with food type is American.
SQL: SELECT T1.street_name FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.city = T2.city WHERE T2.food_type = 'American'

Database: chicago_crime
Question: List down the district's commander associated with the crime that happened at the yard and has a beat of 532.
Evidence: beat of 532 refers to beat = 532; happened in the Yard refers to location_description = 'YARD'; district commander refers to commander
SQL: SELECT T2.address, T2.commander FROM Crime AS T1 INNER JOIN District AS T2 ON T1.district_no = T2.district_no WHERE T1.location_description = 'YARD' AND T1.beat = 532

Database: shakespeare
Question: In the year 1500s, how many tragedies did Shakespeare write?
Evidence: year 1500s refers to Date between 1500 and 1599; tragedies refers to GenreType = 'Tragedy'
SQL: SELECT COUNT(id) FROM works WHERE GenreType = 'Tragedy' AND Date BETWEEN 1500 AND 1599

Database: airline
Question: What is the scheduled local departure time and the actual departure time of the flight from Philadelphia to Harrisburg with the plane's tail number N627AE on the 13th of August 2018?
Evidence: scheduled local departure time refers to CRS_DEP_TIME; actual departure time refers to DEP_TIME; from Philadelphia refers to ORIGIN = 'PHL'; to Harrisburg refers to DEST = 'MDT'; tail number refers to TAIL_NUM; TAIL_NUM = 'N627AE'; on the 13th of August 2018 refers to FL_DATE = '2018/8/13';
SQL: SELECT CRS_DEP_TIME, DEP_TIME FROM Airlines WHERE ORIGIN = 'PHL' AND DEST = 'MDT' AND TAIL_NUM = 'N627AE' AND FL_DATE = '2018/8/13'

Database: world
Question: List down the languages of the countries that have population below 8000.
Evidence: population below 8000 refers to Population < 8000;
SQL: SELECT T2.Language FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Population < 8000

Database: movielens
Question: Among the films directed by directors who direct the best, how many of them have an average rating of over 3.5?
Evidence: d_quality = 5 refers to direct the best, d_quality = 0 refers to direct the worst
SQL: SELECT COUNT(*) FROM ( SELECT DISTINCT T2.movieid FROM directors AS T1 INNER JOIN movies2directors AS T2 ON T1.directorid = T2.directorid INNER JOIN u2base AS T3 ON T2.movieid = T3.movieid WHERE T1.d_quality = 5 GROUP BY T2.movieid HAVING AVG(T3.rating) > 3.5 ) AS T1

Database: computer_student
Question: List the ID of all professors who are not faculty member along with the courses taught by him/her.
Evidence: ID of all professors refers to person.p_id where professor = 1; not faculty member refers to hasPosition = 0; courses refers to taughtBy.course_id
SQL: SELECT T2.p_id, T2.course_id FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.hasPosition <> 0

Database: restaurant
Question: Indicate street and number of the Adelitas Taqueria Restaurants.
Evidence: street refers to street_name; number refers to street_num; Adelitas Taqueria Restaurant refers to label = 'adelitas taqueria'
SQL: SELECT T1.street_name, T1.street_num FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T2.label = 'adelitas taqueria'