Database: video_games
Question: What is the id of the game "Resident Evil Archives: Resident Evil"?
Evidence: id of game refers to game.id; "Resident Evil Archives: Resident Evil" refers to game_name = 'Resident Evil Archives: Resident Evil'
SQL: SELECT T.genre_id FROM game AS T WHERE T.game_name = 'Resident Evil Archives: Resident Evil'

Database: legislator
Question: What is the Instagram name of the legislator whose birthday was on 8/24/1952?
Evidence: Instagram name refers to instagram; birthday on 8/24/1952 refers to birthday_bio = '1952-08-24'
SQL: SELECT T1.instagram FROM `social-media` AS T1 INNER JOIN current AS T2 ON T1.bioguide = T2.bioguide_id WHERE T2.birthday_bio = '1952-08-24'

Database: chicago_crime
Question: How many crimes happened in longitude -8772658001?
SQL: SELECT COUNT(*) FROM Crime WHERE longitude = '-87.72658001'

Database: talkingdata
Question: Give the number of male users who use phone branded HTC.
Evidence: male refers to gender = 'M';
SQL: SELECT COUNT(T1.device_id) FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.gender = 'M' AND T2.phone_brand = 'HTC'

Database: sales
Question: What are the full names of the top 3 employees who handled the highest number of sales?
Evidence: full names of employees = FirstName, MiddleInitital, LastName; highest number of sales refers to MAX(COUNT(SalesID));
SQL: SELECT T1.FirstName, T1.MiddleInitial, T1.LastName FROM Employees AS T1 INNER JOIN Sales AS T2 ON T1.EmployeeID = T2.SalesPersonID GROUP BY T2.SalesPersonID, T1.FirstName, T1.MiddleInitial, T1.LastName ORDER BY COUNT(T2.SalesID) DESC LIMIT 3

Database: beer_factory
Question: What is the precise coordinate of Sac State Union?
Evidence: precise coordinate = Latitude, Longitude; Sac State Union refers to LocationName = 'Sac State Union';
SQL: SELECT T2.Latitude, T2.Longitude FROM location AS T1 INNER JOIN geolocation AS T2 ON T1.LocationID = T2.LocationID WHERE T1.LocationName = 'Sac State Union'

Database: professional_basketball
Question: Among the players who have passed away, who had the most award?
Evidence: pass away refers to deathDate ! = 'null'; most award refers to playerID where Max(Count(award))
SQL: SELECT T1.playerID FROM players AS T1 INNER JOIN awards_players AS T2 ON T1.playerID = T2.playerID WHERE deathDate IS NOT NULL GROUP BY T1.playerID ORDER BY COUNT(award) DESC LIMIT 1

Database: olympics
Question: How many 10-year old athletes participated in the Gymnastics Men's Parallel Bars, Teams event?
Evidence: 10-year old athletes refer to competitor_id where age = 10; Gymnastics Men's Parallel Bars, Teams refer to event_name = 'Gymnastics Men''s Parallel Bars, Teams';
SQL: SELECT COUNT(T2.person_id) FROM competitor_event AS T1 INNER JOIN games_competitor AS T2 ON T1.competitor_id = T2.id INNER JOIN event AS T3 ON T1.event_id = T3.id WHERE T3.event_name LIKE 'Gymnastics Men%s Parallel Bars, Teams' AND T2.age = 10

Database: shakespeare
Question: What are the titles and genres of the one-act works of Shakespeare?
Evidence: one-act works refers to count(Act) = 1; genre refers to GenreType

SQL: SELECT DISTINCT T1.Title, T1.GenreType FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id WHERE T2.Act = 1

Database: public_review_platform
Question: How many user's compliment in photo has medium in number?
Evidence: user's compliment in photo refers to compliment_type = 'photo'; photo has medium in number refers to number_of_compliments = 'Medium'
SQL: SELECT COUNT(T2.user_id) FROM Compliments AS T1 INNER JOIN Users_Compliments AS T2 ON T1.compliment_id = T2.compliment_id WHERE T1.compliment_type = 'photos' AND T2.number_of_compliments = 'Medium'

Database: student_loan
Question: Which students that filed for bankruptcy are also in the foreign legion?
Evidence: in the foreign legion refers to organ = 'foreign_legion';
SQL: SELECT T2.name FROM enlist AS T1 INNER JOIN filed_for_bankrupcy AS T2 ON T1.`name` = T2.`name` WHERE T1.organ = 'foreign_legion'

Database: simpson_episodes
Question: Provide the number of credits, category, role and birthplace of the crew member who was born in North Korea.
Evidence: number of credits refers to credited; born in North Korea refers to birth_country = 'North Korea'
SQL: SELECT DISTINCT T2.credited, T2.category, T2.role, T1.birth_place FROM Person AS T1 INNER JOIN Credit AS T2 ON T1.name = T2.person WHERE T1.birth_country = 'North Korea';

Database: public_review_platform
Question: Please list the opening time on Mondays of all the Yelp_Businesses in Anthem that are still running.
Evidence: Mondays refers to day_of_week = 'Monday'; in Anthem refers to city = 'Anthem'; are still running refers to active = 'true'
SQL: SELECT T1.opening_time FROM Business_Hours AS T1 INNER JOIN Days AS T2 ON T1.day_id = T2.day_id INNER JOIN Business AS T3 ON T1.business_id = T3.business_id WHERE T2.day_of_week LIKE 'Monday' AND T3.city LIKE 'Anthem' AND T3.active LIKE 'True' GROUP BY T1.opening_time

Database: donor
Question: How many schools in urban area requested for books resources?
Evidence: urban area refers to school_metro = 'urban'; books resources refers to project_resource_type = 'Books'
SQL: SELECT COUNT(T2.schoolid) FROM resources AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.resource_type = 'Books' AND T2.school_metro = 'urban'

Database: talkingdata
Question: Please list any five app categories that are related to games, along with their label ID.
Evidence: app categories refers to category; related to games refers to category like '%game%';
SQL: SELECT category, label_id FROM label_categories WHERE category LIKE '%game%' LIMIT 5

Database: chicago_crime
Question: How severe was case JB296775? Give the index code for severity.
Evidence: index code refers to iucr_no; case JB296775 refers to case_number = 'JB296775'
SQL: SELECT T2.iucr_no FROM Crime AS T1 INNER JOIN IUCR AS T2 ON T1.iucr_no = T2.iucr_no WHERE T1.case_number = 'JB296775'

Database: menu
Question: Among the menus that did not support taking out or booking in advance, how many of them were created before 1950?
Evidence: did not support taking out or booking in advance refers to call_number is null; created before 1950 refers to strftime('%Y', date) < '1950';
SQL: SELECT COUNT(*) FROM Menu WHERE call_number IS NULL AND strftime('%Y', date) < '1950'

Database: human_resources
Question: When was Emily Wood hired? Mention her position and salary.
Evidence: Emily Wood is the full name of an employee; full name = firstname, lastname; when was she hired refers to hiredate
SQL: SELECT T1.hiredate, T2.positiontitle, T1.salary FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.firstname = 'Emily' AND T1.lastname = 'Wood'

Database: retails
Question: List by their id all customers who have a debit balance in their accounts.
Evidence: customers who have a debt balance refer to c_custkey where c_acctbal < 0;
SQL: SELECT c_custkey FROM customer WHERE c_acctbal < 0

Database: student_loan
Question: How many students from SMC are unemployed?
Evidence: from SMC refers to school = 'smc';
SQL: SELECT T2.name FROM enrolled AS T1 INNER JOIN unemployed AS T2 ON T1.`name` = T2.`name` WHERE T1.school = 'smc'

Database: restaurant
Question: What is the full address of the restaurant named "Sanuki Restaurant"?
Evidence: full address refers to city, street_num, street_name; restaurant named "Sanuki Restaurant" refers to label = 'sanuki restaurant'
SQL: SELECT T2.city, T1.street_num, T1.street_name FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T2.label = 'sanuki restaurant'