Database: soccer_2016
Question: Who is the player that has the highest number of roles as a captain for Deccan Chargers?
Evidence: name of the player refers to Player_Name; the highest number of roles refers to max(count(Role_Id)); as a captain refers to Role_Desc = 'Captain'; Deccan Chargers refers to Team_Name = 'Deccan Chargers'
SQL: SELECT T4.Player_Name FROM Team AS T1 INNER JOIN Player_Match AS T2 ON T1.Team_id = T2.Team_id INNER JOIN Rolee AS T3 ON T2.Role_Id = T3.Role_Id INNER JOIN Player AS T4 ON T2.Player_Id = T4.Player_Id WHERE T1.Team_Name = 'Deccan Chargers' AND T1.Team_Id = 8 AND T3.Role_Desc = 'Captain' AND T3.Role_Id = 1 GROUP BY T4.Player_Id ORDER BY COUNT(T3.Role_Id) DESC LIMIT 1

Database: bike_share_1
Question: What is the total trip duration made within Palo Alto city? Convert the duration to hour.
Evidence: total trip duration to hour = DIVIDE(SUM(duration), 3600);
SQL: SELECT CAST(SUM(T1.duration) AS REAL) / 3600 FROM trip AS T1 LEFT JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T2.city = 'Palo Alto'

Database: talkingdata
Question: Give the time stamp for event No.887711.
Evidence: event no. refers to event_id; event_id = '887711';
SQL: SELECT timestamp FROM events WHERE event_id = '887711'

Database: retails
Question: Please state the segment, the name, the address, and the phone number of customer number 3.
Evidence: segment refers to c_mktsegment; name refers to c_name; address refers to c_address; phone number refers to c_phone; customer number 3 refers to c_custkey = 3
SQL: SELECT c_mktsegment, c_name, c_address, c_phone FROM customer WHERE c_custkey = 3

Database: soccer_2016
Question: What is the outcome type of match ID 392195?
SQL: SELECT T2.Outcome_Type FROM Match AS T1 INNER JOIN Outcome AS T2 ON T1.Outcome_type = T2.Outcome_Id WHERE T1.Match_Id = '392195'

Database: shipping
Question: Provide the ship date of the first shipment to customers in South Carolina.
Evidence: "South Carolina" refers to state = 'SC'; first shipment refers to Min(ship_date)
SQL: SELECT MIN(T1.ship_date) FROM shipment AS T1 INNER JOIN customer AS T2 ON T1.cust_id = T2.cust_id WHERE T2.state = 'SC'

Database: human_resources
Question: Describe the employees' full name, positions, located city and office phone number within Colorado state.
Evidence: full name = firstname, lastname; Colorado state refers to state = 'CO'; positions refers to positiontitle; located city refers to locationcity; office phone number refers to officephone;
SQL: SELECT T1.firstname, T1.lastname, T3.positiontitle, T2.locationcity, T2.officephone FROM employee AS T1  INNER JOIN location AS T2  ON T1.locationID = T2.locationID INNER JOIN position AS T3  ON T3.positionID = T1.positionID WHERE T2.state = 'CO'

Database: cars
Question: How many cars with horsepower greater than 200 were produced in 1975?
Evidence: horsepower greater than 200 refers to horsepower > 200; in 1975 refers to model_year = 1975
SQL: SELECT COUNT(T2.model_year) FROM data AS T1 INNER JOIN production AS T2 ON T1.ID = T2.ID WHERE T1.horsepower > 200 AND T2.model_year = 1975

Database: movies_4
Question: Write down the release date of the movies produced by Twentieth Century Fox Film Corporation.
Evidence: produced by Twentieth Century Fox Film Corporation refers to company_name = 'Twentieth Century Fox Film Corporation'
SQL: SELECT T3.release_date FROM production_company AS T1 INNER JOIN movie_company AS T2 ON T1.company_id = T2.company_id INNER JOIN movie AS T3 ON T2.movie_id = T3.movie_id WHERE T1.company_name = 'Twentieth Century Fox Film Corporation'

Database: talkingdata
Question: Among the app users who were not active when event no.2 happened, how many of them belong to the category Property Industry 1.0?
Evidence: not active refers to is_active = 0; event no. refers to event_id; event_id = 2;
SQL: SELECT COUNT(T2.app_id) FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T1.label_id = T2.label_id INNER JOIN app_events AS T3 ON T2.app_id = T3.app_id WHERE T3.is_active = 0 AND T1.category = 'Property Industry 1.0' AND T3.event_id = 2

Database: world
Question: What country in Asia has the largest gross national product(GNP)?
Evidence: Asia refers to Continent = 'Asia'; largest gross national product refers to MAX(GNP);
SQL: SELECT Name FROM Country WHERE Continent = 'Asia' ORDER BY GNP DESC LIMIT 1

Database: genes
Question: Please list the location of the genes that have the most chromosomes.
SQL: SELECT T2.Localization FROM Genes AS T1 INNER JOIN Classification AS T2 ON T1.GeneID = T2.GeneID ORDER BY T1.Chromosome DESC LIMIT 1

Database: cs_semester
Question: Among the easiest courses, what is the name of the course where most students got an A?
Evidence: diff refers to difficulty; the easiest courses refers to diff = 1; A refers to an excellent grade in which grade = 'A' for the course;
SQL: SELECT T2.name FROM registration AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T1.grade = 'A' AND T2.diff = 1 GROUP BY T2.name ORDER BY COUNT(T1.student_id) DESC LIMIT 1

Database: shipping
Question: Among the customers having at least one shipment in 2017, how many of them have an annual revenue of over 30000000?
Evidence: shipment in 2017 refers to Cast(ship_date AS DATE) = 2017; annual revenue of over 30000000 refers to annual_revenue > 30000000
SQL: SELECT COUNT(COUNTCUSID) FROM ( SELECT COUNT(T1.cust_id) AS COUNTCUSID FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id WHERE STRFTIME('%Y', T2.ship_date) = '2017' AND T1.annual_revenue > 30000000 GROUP BY T1.cust_id HAVING COUNT(T2.ship_id) >= 1 ) T3

Database: social_media
Question: List down all the tweet text posted from Australia.
Evidence: "Australia" is the Country
SQL: SELECT T1.text FROM twitter AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID WHERE T2.Country = 'Australia'

Database: legislator
Question: What is the birthday of Amy Klobuchar?
Evidence: birthday refers to birthday_bio; Amy Klobuchar refers to full name; full name refers to first_name, last_name
SQL: SELECT birthday_bio FROM current WHERE first_name = 'Amy' AND last_name = 'Klobuchar'

Database: ice_hockey_draft
Question: What is the weight in kilograms of the player with the highest number of goal differential of all time?
Evidence: weight in kilograms refers to weight_in_kg; highest number of goal differential of all time refers to MAX(PLUSMINUS);
SQL: SELECT T3.weight_in_kg FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID INNER JOIN weight_info AS T3 ON T2.weight = T3.weight_id ORDER BY T1.PLUSMINUS DESC LIMIT 1

Database: ice_hockey_draft
Question: Who is the most valuable player in QMJHL league during the 2004-2005 season?
Evidence: most valuable player refers to MAX(P); QMJHL league refers to LEAGUE = 'QMJHL'; 2004-2005 season refers to SEASON = '2004-2005';
SQL: SELECT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.SEASON BETWEEN '2004' AND '2005' AND T1.LEAGUE = 'QMJHL' ORDER BY T1.P DESC LIMIT 1

Database: public_review_platform
Question: What is the average business time for Yelp_Business no.1 on weekends?
Evidence: Yelp_Business no.1 refers to business_id = 1; on weekends refers to day_of_week = 'Saturday' or day_of_week = 'Sunday'; average business time refers to DIVIDE(SUBTRACT(closing_time, opening_time), 2)
SQL: SELECT T1.closing_time + 12 - T1.opening_time AS "avg opening hours" FROM Business_Hours AS T1 INNER JOIN Days AS T2 ON T1.day_id = T2.day_id WHERE T1.business_id = 1 AND (T2.day_of_week = 'Sunday' OR T2.day_of_week = 'Sunday')

Database: ice_hockey_draft
Question: Who has the heaviest weight?
Evidence: who refers to PlayerName; heaviest weight refers to MAX(weight_in_kg);
SQL: SELECT T1.PlayerName FROM PlayerInfo AS T1 INNER JOIN weight_info AS T2 ON T1.weight = T2.weight_id ORDER BY T2.weight_in_kg DESC LIMIT 1