Database: bike_share_1
Question: Calculate the average duration travelled by subscribers that both started and ended their trip in Mountain View City Hall and indicate the date when the station was first installed.
Evidence: average duration = DIVIDE(SUM(duration), COUNT(id)); subscribers refers to subscription_type = 'subscriptions'; started and ended their trip at Mountain View City Hall refers to start_station_name = 'Mountain View City Hall' and end_station_name = 'Mountain View City Hall'; when the station was first installed refers to installation_date;
SQL: SELECT AVG(T1.duration), T2.installation_date FROM trip AS T1 INNER JOIN station AS T2 ON T2.name = T1.start_station_name WHERE T1.start_station_name = 'Mountain View City Hall' AND T1.subscription_type = 'Subscriber' AND T1.end_station_name = 'Mountain View City Hall'

Database: superstore
Question: How many orders has Aimee Bixby made?
Evidence: Aimee Bixby made refers to "Customer Name" = 'Aimee Bixby';
SQL: SELECT COUNT(DISTINCT T2.`Order ID`) FROM people AS T1 INNER JOIN central_superstore AS T2 ON T1.`Customer ID` = T2.`Customer ID` WHERE T1.`Customer Name` = 'Aimee Bixby'

Database: authors
Question: What is the journal's short and full names that feature papers on the "Materials" topic?
Evidence: papers on the "Materials" topic refers to Keyword = 'Materials'
SQL: SELECT T2.ShortName, T2.FullName FROM Paper AS T1 INNER JOIN Journal AS T2 ON T1.JournalId = T2.Id WHERE T1.Keyword LIKE '%Materials%'

Database: movie_platform
Question: Which of the films released in 2006 was the most popular among Mubi users?
Evidence: released in 2006 refers to movie_release_year = 2006; most popular refers to Max(movie_popularity); film refers to movie;
SQL: SELECT movie_title FROM movies WHERE movie_release_year = 2006 ORDER BY movie_popularity DESC LIMIT 1

Database: sales_in_weather
Question: What is the maximum average speed?
Evidence: maximum average speed refers to Max(avgspeed)
SQL: SELECT MAX(avgspeed) FROM weather

Database: human_resources
Question: What is the max salary for 'Tracy Coulter' if he/she stays on his/her position?
Evidence: Tracy Coulter is the full name of an employee; full name = firstname, lastname
SQL: SELECT T2.maxsalary FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.firstname = 'Tracy' AND T1.lastname = 'Coulter'

Database: university
Question: Which country has the University of SÃ£o Paulo?
Evidence: the University of SÃ£o Paulo refers to university_name = 'University of São Paulo'; which country refers to country_name;
SQL: SELECT T2.country_name FROM university AS T1 INNER JOIN country AS T2 ON T1.country_id = T2.id WHERE T1.university_name = 'University of São Paulo'

Database: sales
Question: List the first names of employees with trading quantity for more than 500.
Evidence: trading quantity for more than 500 refers to Quantity > 500;
SQL: SELECT DISTINCT T1.FirstName FROM Employees AS T1 INNER JOIN Sales AS T2 ON T1.EmployeeID = T2.SalesPersonID WHERE T2.Quantity > 500

Database: image_and_language
Question: List the object sample IDs of image ID 17 with coordinates (0,0).
Evidence: object sample ID refers to OBJ_SAMPLE_ID; image ID 17 refers to IMG_ID = 17; coordinates (0,0) refer to X and Y coordinates of the bounding box where X = 0 and Y = 0;
SQL: SELECT OBJ_SAMPLE_ID FROM IMG_OBJ WHERE IMG_ID = 17 AND X = 0 AND Y = 0

Database: legislator
Question: What is the current official Twitter handle of Roger F. Wicker?
Evidence: Twitter handle refers to twitter; Roger F. Wicker is an official_full_name
SQL: SELECT T2.twitter FROM current AS T1 INNER JOIN `social-media` AS T2 ON T2.bioguide = T1.bioguide_id WHERE T1.official_full_name = 'Roger F. Wicker'

Database: talkingdata
Question: Provide the number of events participated by the device users at coordinates of (80,37).
Evidence: coordinates of (80,37) refers to longitude = 80 and latitude = 37;
SQL: SELECT COUNT(event_id) FROM events WHERE longitude = 80 AND latitude = 37

Database: college_completion
Question: Which 4-year private for-profit school in "KY" has the highest graudation 150 value? Give the ID for the school.
Evidence: 4-year refers to level = '4-year'; private for profit refers to control = 'Private for-profit'; KY refers to state_abbr = 'KY'; highest graduation 150 value refers to MAX(grad_150_value); ID of the school refers to unitid;
SQL: SELECT T1.chronname, T1.unitid FROM institution_details AS T1 INNER JOIN state_sector_grads AS T2 ON T2.state = T1.state WHERE T2.state_abbr = 'KY' AND T1.level = '4-year' AND T1.control = 'Private for-profit' GROUP BY T1.chronname ORDER BY SUM(T1.grad_150_value) DESC LIMIT 1

Database: soccer_2016
Question: What is the ratio of players with batting hands of left and right?
Evidence: batting hands of left refers to Batting_hand = 'Left-hand bat'; right refers to Batting_hand = 2; ratio refers to DIVIDE(COUNT(Batting_hand = 'Right-hand bat'), COUNT(Batting_hand = 2))
SQL: SELECT CAST(SUM(CASE WHEN T2.Batting_hand = 'Left-hand bat' THEN 1 ELSE 0 END) AS REAL) / SUM(CASE WHEN T2.Batting_hand = 'Right-hand bat' THEN 1 ELSE 0 END) FROM Player AS T1 INNER JOIN Batting_Style AS T2 ON T1.Batting_hand = T2.Batting_Id

Database: disney
Question: List the movies and genres released in 2016.
Evidence: released in 2016 refers to substr(release_date, length(release_date) - 3, length(release_date)) = '2016'; movies refer to the movie_title;
SQL: SELECT movie_title, genre FROM movies_total_gross WHERE SUBSTR(release_date, LENGTH(release_date) - 3, LENGTH(release_date)) = '2016'

Database: books
Question: Which customer addresses are no longer active?
Evidence: no longer active refers to address_status = 'Inactive'; customer address refers to street_number, street_name, city
SQL: SELECT DISTINCT T1.street_name FROM address AS T1 INNER JOIN customer_address AS T2 ON T1.address_id = T2.address_id INNER JOIN address_status AS T3 ON T3.status_id = T2.status_id WHERE T3.address_status = 'Inactive'

Database: authors
Question: What is the homepage URL for the journal that published the most papers?
Evidence: published the most papers refer to MAX(JournalId); homepage URL refers to HomePage
SQL: SELECT T2.HomePage FROM Paper AS T1 INNER JOIN Journal AS T2 ON T1.JournalId = T2.Id GROUP BY T1.JournalId ORDER BY COUNT(T1.JournalId) DESC LIMIT 1

Database: simpson_episodes
Question: State the birth name of crews who are director and have birth country in South Korea.
Evidence: director refers to role = 'director'
SQL: SELECT T1.birth_name FROM Person AS T1 INNER JOIN Award AS T2 ON T1.name = T2.person WHERE T2.role = 'director' AND T1.birth_country = 'South Korea';

Database: movie_platform
Question: For the 1998 movie which got the highest popularity, how many "4" rating did the movie get?
Evidence: 1998 movie refers to movie_release_year = '1998'; the highest popularity refers to MAX(movie_popularity) ; "4" rating refers to rating_score = 4
SQL: SELECT COUNT(T2.movie_title) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 4 AND T2.movie_release_year = 1998 ORDER BY T2.movie_popularity DESC LIMIT 1

Database: retails
Question: Which region does "Supplier#000000129" belong to?
Evidence: "Supplier#000000129" is the name of the supplier which refers to s_name; Which region refers to r_name;
SQL: SELECT T3.r_name FROM nation AS T1 INNER JOIN supplier AS T2 ON T1.n_nationkey = T2.s_nationkey INNER JOIN region AS T3 ON T1.n_regionkey = T3.r_regionkey WHERE T2.s_name = 'Supplier#000000129'

Database: video_games
Question: What is the genre of 3D Lemmings?
Evidence: genre refers to genre_name; 3D Lemmings refers to game_name = '3D Lemmings'
SQL: SELECT T2.genre_name FROM game AS T1 INNER JOIN genre AS T2 ON T1.genre_id = T2.id WHERE T1.game_name = '3D Lemmings'