Database: european_football_1
Question: How many matches played in the 2019 season of Scottish Championship league were ended with an equal result of 2-2?
Evidence: matches refer to Div; Scottish Championship is a name of the league; equal result of 2-2 refers to FTAG = 2 AND FTHG = 2;
SQL: SELECT COUNT(T1.Div) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T1.season = 2019 AND T2.name = 'Scottish Championship' AND T1.FTAG = 2 AND T1.FTHG = 2

Database: regional_sales
Question: To which region does the sales team that has used the WARE-MKL1006 warehouse the most times for its shipments belong?
Evidence: "WARE-MKL1006" is the WarehouseCode; most shipment to region refers to Max(Count(Region))
SQL: SELECT T2.Region FROM `Sales Orders` AS T1 INNER JOIN `Sales Team` AS T2 ON T2.SalesTeamID = T1._SalesTeamID WHERE T1.WarehouseCode = 'WARE-MKL1006' GROUP BY T2.Region ORDER BY COUNT(T1.OrderNumber) DESC LIMIT 1

Database: legislator
Question: List the full names of Republican legislators who have a nickname.
Evidence: full names refers to official_full_name; Republican refers to party = 'Republican'; nickname refers to nickname_name
SQL: SELECT T1.official_full_name FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.party = 'Republican' AND T1.nickname_name IS NOT NULL GROUP BY T1.official_full_name

Database: music_tracker
Question: Which artists have released singles with the tag 1970s?
Evidence: releaseType = 'single';
SQL: SELECT T1.artist FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T1.releaseType = 'single' AND T2.tag LIKE '1970s'

Database: movie_3
Question: What is the complete address of store id 1?
Evidence: complete address refers to address, address2, district
SQL: SELECT T3.address, T3.address2, T3.district FROM country AS T1 INNER JOIN city AS T2 ON T1.country_id = T2.country_id INNER JOIN address AS T3 ON T2.city_id = T3.city_id INNER JOIN store AS T4 ON T3.address_id = T4.address_id WHERE T4.store_id = 1

Database: donor
Question: List the school districts that have bought resources from Barnes and Noble.
Evidence: Barnes and Noble refer to vendor_name
SQL: SELECT T2.school_district FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T1.vendor_name = 'Barnes and Noble'

Database: book_publishing_company
Question: List the title name, type, and price of the titles published by New Moon Books. Arrange the list in ascending order of price.
Evidence: Eric the Read Books is a publisher which refers to pub_name;
SQL: SELECT T1.title, T1.type, T1.price FROM titles AS T1 INNER JOIN publishers AS T2 ON T1.pub_id = T2.pub_id WHERE T2.pub_name = 'New Moon Books' ORDER BY T1.price

Database: movie_3
Question: What is the description of the film ACADEMY DINOSAUR?
Evidence: "ACADEMY DINOSAUR" is the title of film
SQL: SELECT description FROM film WHERE title = 'ACADEMY DINOSAUR'

Database: movies_4
Question: Find out the popularity of the movies with the highest vote count.
Evidence: highest vote count refers to max(vote_count)
SQL: SELECT popularity FROM movie ORDER BY vote_COUNT DESC LIMIT 1

Database: movie_3
Question: What are the titles of the films starred by Russell Close?
SQL: SELECT T3.title FROM film_actor AS T1 INNER JOIN actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film AS T3 ON T1.film_id = T3.film_id WHERE T2.first_name = 'Russell' AND T2.last_name = 'Close'

Database: public_review_platform
Question: In users yelping since 2009 to 2011, how many of them have low count of fans?
Evidence: users in yelping since 2009 to 2011 refers to user_yelping_since_year BETWEEN 2009 AND 2011; low count of fans refers to user_fans = 'Low'
SQL: SELECT COUNT(user_id) FROM Users WHERE user_yelping_since_year >= 2009 AND user_yelping_since_year < 2012 AND user_fans = 'Low'

Database: retail_world
Question: What is the position title for Laura Callahan?
SQL: SELECT Title FROM Employees WHERE FirstName = 'Laura' AND LastName = 'Callahan'

Database: synthea
Question: How many patients immunized against 'monovalent rotavirus' ceased their care plan on 11/23/2013?
Evidence: immunized against monovalent rotavirus refers to immunizations.DESCRIPTION = 'rotavirus monovalent'; ceased their care plan on 11/23/2013 refers to careplans.STOP = '2013-11-23';
SQL: SELECT COUNT(DISTINCT T1.patient) FROM careplans AS T1 INNER JOIN immunizations AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'rotavirus  monovalent' AND T1.STOP = '2013-11-23'

Database: beer_factory
Question: Please list the brands of all the root beer that Frank-Paul Santangelo had purchased on 2014/7/7.
Evidence: brands of the root beer refers to BrandName; purchased on 2014/7/7 refers to transactiondate = '2014-07-07';
SQL: SELECT DISTINCT T4.BrandName FROM customers AS T1 INNER JOIN `transaction` AS T2 ON T1.CustomerID = T2.CustomerID INNER JOIN rootbeer AS T3 ON T2.RootBeerID = T3.RootBeerID INNER JOIN rootbeerbrand AS T4 ON T3.BrandID = T4.BrandID WHERE T1.First = 'Frank-Paul' AND T1.Last = 'Santangelo' AND T2.TransactionDate = '2014-07-07'

Database: movie_platform
Question: When did user 39115684 rate the movie "A Way of Life"?
Evidence: A Way of Life' refers to movie_title; user 39115684 refers to userid = 39115684;  when the user rate refers to rating_timestamp_utc;
SQL: SELECT T1.rating_score FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'A Way of Life' AND T1.user_id = 39115684

Database: sales_in_weather
Question: Among the stations with 3 stores, how many stations have a station pressure of no more than 30 on February 18, 2014?
Evidence: station with 3 stores refers to station_nbr where Count(store_nbr) = 3; station pressure of no more than 30 refers to stnpressure < 30; On February 18, 2014 refers to date = '2014-02-18'
SQL: SELECT COUNT(station_nbr) FROM weather WHERE `date` = '2014-02-18' AND stnpressure < 30 AND station_nbr IN ( SELECT station_nbr FROM relation GROUP BY station_nbr HAVING COUNT(store_nbr) = 3 )

Database: sales_in_weather
Question: How many days did the sun rise before 5 AM?
Evidence: sunrise before 5 Am refers to sunrise < time ('5:00:00')
SQL: SELECT COUNT(DISTINCT `date`) AS days FROM weather WHERE sunrise < time('05:00:00')

Database: world_development_indicators
Question: What South Asian nations have low incomes? Please include the entire names of the nations in your answer.
Evidence: South Asian nations refers to region = 'South Asia'; have low incomes refers to incomegroup = 'Low income'; the entire names refers to longname
SQL: SELECT LongName FROM Country WHERE IncomeGroup = 'Low income' AND Region = 'South Asia'

Database: movie_3
Question: Which film titles have the most expensive rental rate?
Evidence: the most expensive rental rate refers to max(rental_rate)
SQL: SELECT title FROM film WHERE rental_rate = ( SELECT MAX(rental_rate) FROM film )

Database: retail_world
Question: Who is in charge of the "Santa Monica" territory? Give the full name.
Evidence: Santa Monica refers to TerritoryDescription = 'Santa Monica'; full name = FirstName, MiddleName, LastName;
SQL: SELECT T1.FirstName, T1.LastName FROM Employees AS T1 INNER JOIN EmployeeTerritories AS T2 ON T1.EmployeeID = T2.EmployeeID INNER JOIN Territories AS T3 ON T2.TerritoryID = T3.TerritoryID WHERE T3.TerritoryDescription = 'Santa Monica'

Database: movielens
Question: What is the average rating of the newest movies from France?
Evidence: France is a country; year = 4 represents the newest date.
SQL: SELECT AVG(T1.rating) FROM u2base AS T1 INNER JOIN movies AS T2 ON T1.movieid = T2.movieid WHERE T2.country = 'france' AND T2.year = 4

Database: movies_4
Question: List all the keywords with "christmas" in them.
Evidence: keywords with "christmas" in them refers to keyword_name LIKE '%christmas%'
SQL: SELECT keyword_name FROM keyword WHERE keyword_name LIKE '%christmas%'