Database: retail_world
Question: Who is the supplier of the product with the highest unit price?
Evidence: supplier of the product refers to CompanyName; highest unit price refers to MAX(UnitPrice);
SQL: SELECT T2.CompanyName FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T1.UnitPrice = ( SELECT MAX(UnitPrice) FROM Products )

Database: public_review_platform
Question: Write down the ID and opening day of a week for the business which are running in Black Canyon City.
Evidence: running refers to active = 'true'; opening day of a week means days of the week when business is open;
SQL: SELECT T2.business_id, T3.day_of_week FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id INNER JOIN Days AS T3 ON T2.day_id = T3.day_id WHERE T1.city = 'Black Canyon City' AND T1.active = 'true'

Database: donor
Question: Name and describe all projects created by New York teachers.
Evidence: project name refers to title; describe refers to short_description; New York teachers refers to teacher_ny_teaching_fellow = 't'
SQL: SELECT T1.title, T1.short_description FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.teacher_ny_teaching_fellow = 't'

Database: image_and_language
Question: What attributes are used to describe the wall on image no. 27.
Evidence: What attributes refers to ATT_CLASS; wall on image no. 27 refers to OBJ_CLASS = 'wall' and IMG_ID = 27
SQL: SELECT T4.ATT_CLASS FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID INNER JOIN IMG_OBJ_ATT AS T3 ON T1.IMG_ID = T3.IMG_ID INNER JOIN ATT_CLASSES AS T4 ON T3.ATT_CLASS_ID = T4.ATT_CLASS_ID WHERE T2.OBJ_CLASS = 'wall' AND T1.IMG_ID = 27 GROUP BY T4.ATT_CLASS

Database: public_review_platform
Question: How many business ids have opening hours from 8AM to 6PM?
Evidence: opening hours from 8AM to 6PM refer to Business_Hours where opening_time = '8AM' and closing_time = '6PM';
SQL: SELECT DISTINCT business_id FROM Business_Hours WHERE opening_time = '8AM' AND closing_time = '6PM'

Database: european_football_1
Question: How many matches of the Bundesliga division ended with an away victory in the 2021 season?
Evidence: Bundesliga is the name of division; away victory refers to FTR = 'A', where 'A' stands for away victory;
SQL: SELECT COUNT(T1.Div) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'Bundesliga' AND T1.FTR = 'A' AND T1.season = 2021

Database: chicago_crime
Question: What is the general description for case number JB106010?
Evidence: general description refers to primary_description
SQL: SELECT T1.primary_description FROM IUCR AS T1 INNER JOIN Crime AS T2 ON T1.iucr_no = T2.iucr_no WHERE T2.case_number = 'JB106010'

Database: movielens
Question: How many users have rated 1 each for the UK's second newest movies with a running time of 2?
Evidence: second newest movies refers to year = 2 since year in this database is a relative value, less is the newer
SQL: SELECT COUNT(T2.userid) FROM movies AS T1 INNER JOIN u2base AS T2 ON T1.movieid = T2.movieid WHERE T1.country = 'UK' AND T1.runningtime = 2 AND T2.rating = 1 AND T1.year = 2

Database: books
Question: How many authors are named Adam?
Evidence: authors named Adam refers to author_name LIKE 'Adam'
SQL: SELECT COUNT(*) FROM author WHERE author_name LIKE 'Adam%'

Database: ice_hockey_draft
Question: Please list the names of all the players that are over 90 kg and are right-shooted.
Evidence: names of the players refers to PlayerName; over 90 kg refers to weight_in_kg > 90; right-shooted refers to shoots = 'R';
SQL: SELECT T1.PlayerName FROM PlayerInfo AS T1 INNER JOIN weight_info AS T2 ON T1.weight = T2.weight_id WHERE T2.weight_in_kg > 90 AND T1.shoots = 'R'

Database: menu
Question: How much is the price of menu with image ID 4000009194?
Evidence: FALSE;
SQL: SELECT T3.price FROM Menu AS T1 INNER JOIN MenuPage AS T2 ON T1.id = T2.menu_id INNER JOIN MenuItem AS T3 ON T2.id = T3.menu_page_id WHERE T2.image_id = 4000009194

Database: world
Question: Provide the district of the city with a population of 201843.
SQL: SELECT District FROM City WHERE population = 201843

Database: beer_factory
Question: Tell the number of reviews given by James House.
Evidence: FALSE;
SQL: SELECT COUNT(T2.CustomerID) FROM customers AS T1 INNER JOIN rootbeerreview AS T2 ON T1.CustomerID = T2.CustomerID WHERE T1.First = 'James' AND T1.Last = 'House'

Database: software_company
Question: Find out the yearly income of geographic ID when the customer is female and occupation as sales.
Evidence: yearly income of geographic ID refers to GEOID where MULTIPLY(INHABITANTS_K, INCOME_K, 12); SEX = 'Female';
SQL: SELECT T2.INHABITANTS_K * T2.INCOME_K * 12 FROM Customers AS T1 INNER JOIN Demog AS T2 ON T1.GEOID = T2.GEOID WHERE T1.SEX = 'Female' AND T1.OCCUPATION = 'Sales'

Database: retails
Question: Among the customers in the furniture market segment, how many of them have a nation key of 1?
Evidence: furniture market segment refers to c_mktsegment = 'FURNITURE';
SQL: SELECT COUNT(c_custkey) FROM customer WHERE c_mktsegment = 'FURNITURE' AND c_nationkey = 1

Database: student_loan
Question: How many of the students joined two organization?
Evidence: joined two organization refers to COUNT(organ) > = 2
SQL: SELECT COUNT(name) FROM enlist WHERE organ >= 2

Database: chicago_crime
Question: How many crimes are commited on January 1, 2018?
Evidence: on January 1 2018 refers to date LIKE '1/1/2018%'
SQL: SELECT COUNT(*) FROM Crime WHERE date LIKE '1/1/2018%'

Database: chicago_crime
Question: Tell the number of cases with arrests in North Lawndale community.
Evidence: number of cases refers to count(case_number); arrest refers to arrest = 'TRUE'; North Lawndale community refers to community_area_name = 'North Lawndale'
SQL: SELECT SUM(CASE WHEN T1.community_area_name = 'North Lawndale' THEN 1 ELSE 0 END) FROM Community_Area AS T1 INNER JOIN Crime AS T2 ON T1.community_area_no = T2.community_area_no WHERE T2.arrest = 'TRUE'

Database: movie_3
Question: Give the full name of the actor who acted the most in drama movies?
Evidence: full name refers to first_name, last_name; drama is a category of a film; acted the most in a movies refers to MAX(COUNT(film_id))
SQL: SELECT T.first_name, T.last_name FROM ( SELECT T1.first_name, T1.last_name, COUNT(T2.film_id) AS num FROM actor AS T1 INNER JOIN film_actor AS T2 ON T1.actor_id = T2.actor_id INNER JOIN film_category AS T3 ON T2.film_id = T3.film_id WHERE T3.category_id = 7 GROUP BY T1.first_name, T1.last_name ) AS T ORDER BY T.num DESC LIMIT 1

Database: retail_complains
Question: How many reviews by people between 30 and 50 years include the word 'great'?
Evidence: between 30 and 50 years refers to age BETWEEN 30 AND 50; include the word great refers to Review like '%Great%';
SQL: SELECT COUNT(T1.Reviews) FROM reviews AS T1 INNER JOIN client AS T2 ON T1.district_id = T2.district_id WHERE T2.age BETWEEN 30 AND 50 AND T1.Reviews LIKE '%great%'

Database: world_development_indicators
Question: State the table name of country with description of "Covers mainland Tanzania only".
SQL: SELECT DISTINCT T1.TableName FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T2.Description = 'Covers mainland Tanzania only.'

Database: public_review_platform
Question: List down the closing day of businesses located at SC State.
Evidence: closing day refers to SUBTRACT(days.day_id, business_Hours.day_id)
SQL: SELECT T3.day_id - T2.day_id FROM Business AS T1 INNER JOIN Business_Hours AS T2 ON T1.business_id = T2.business_id INNER JOIN Days AS T3 ON T2.day_id = T3.day_id WHERE T1.state = 'SC'

Database: simpson_episodes
Question: How many awards did simpson 20 won in 2009?
Evidence: won refers to result = 'Winner'; in 2009 refers to year = 2009
SQL: SELECT COUNT(award_id) FROM Award WHERE SUBSTR(year, 1, 4) = '2009' AND result = 'Winner';