Database: bike_share_1
Question: Name all the trip on the days when it rained. State the duration of the trip
Evidence: events = 'Rain';
SQL: SELECT T1.id, T1.duration FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code AND T2.date = SUBSTR(CAST(T1.start_date AS TEXT), 1, INSTR(T1.start_date, ' ') - 1) WHERE T2.events LIKE '%Rain%' OR T2.events LIKE '%rain%'

Database: mental_health_survey
Question: Please list all the common questions in 2014's survey and 2016's survey.
Evidence: question refers to questiontext; all the common questions in 2014's survey and 2016's survey refers to QuestionID(SurveyID(2014)) = QuestionID(SurveyID(2016))

SQL: SELECT T1.questiontext FROM Question AS T1 INNER JOIN Answer AS T2 ON T1.questionid = T2.QuestionID WHERE T2.SurveyID IN (2014, 2016) GROUP BY T1.questiontext

Database: world
Question: Among the cities with a population between 140000 and 150000, list the country that has life expectancy greater than 80% life expectancy of all countries.
Evidence: life expectancy greater than 80% life expectancy of all countries refers to LifeExpectancy < (MULTIPLY(AVG(LifeExpectancy), 0.8));
SQL: SELECT T2.Name FROM City AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.Code WHERE T1.Population BETWEEN 140000 AND 150000 GROUP BY T2.Name, LifeExpectancy HAVING LifeExpectancy < ( SELECT AVG(LifeExpectancy) FROM Country ) * 0.8

Database: synthea
Question: Calculate the percentage of male patients with viral sinusitis condition.
Evidence: percentage = MULTIPLY(DIVIDE(COUNT(patients.patient WHERE gender = 'M'), COUNT(patients.patient) WHERE conditions.DESCRIPTION = 'Viral sinusitis (disorder))), 100); male patients refers to gender = 'M'; viral sinusitis condition refers to conditions.DESCRIPTION = 'Viral sinusitis (disorder)';
SQL: SELECT CAST(SUM(CASE WHEN T1.gender = 'M' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.patient) FROM patients AS T1 INNER JOIN conditions AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Viral sinusitis (disorder)'

Database: shipping
Question: What is the brand of truck used in shipment id 1011?
Evidence: shipment id 1011 refers to ship_id = 1011; brand of truck refers to make
SQL: SELECT T1.make FROM truck AS T1 INNER JOIN shipment AS T2 ON T1.truck_id = T2.truck_id WHERE T2.ship_id = '1011'

Database: bike_share_1
Question: How many bike trips started on the days in September, 2013 with the hottest temperature over 70 degrees Fahrenheit in the area where the zip code is 94107?
Evidence: started on the days in September, 2013 refers to date LIKE'9%'AND date LIKE'%2013' hottest temperature over 70 degrees Fahrenheit refers to max_temperature_f>70;
SQL: SELECT COUNT(T1.id) FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE T2.date LIKE '9/%/2013' AND T2.zip_code = 94107 AND T2.max_temperature_f > 70

Database: retail_world
Question: From which country is the company "Drachenblut Delikatessen" from?
Evidence: Drachenblut Delikatessen is the company name;
SQL: SELECT Country FROM Customers WHERE CompanyName = 'Drachenblut Delikatessen'

Database: language_corpus
Question: Indicate the title of all the pages in which the word comunitat appears.
Evidence: This is not;
SQL: SELECT T3.title FROM words AS T1 INNER JOIN pages_words AS T2 ON T1.wid = T2.wid INNER JOIN pages AS T3 ON T2.pid = T3.pid WHERE T1.word = 'comunitat'

Database: beer_factory
Question: Calculate the total purchases made by customers using their Visa credit cards in the Sac State American River Courtyard between 6/3/2014 and 11/27/2015.
Evidence: total purchases = SUM(PurchasePrice); Visa credit card refers to CreditCardType = 'Visa'; Sac State American River Courtyard refers to LocationName = 'Sac State American River Courtyard'; between 6/3/2014 and 11/27/2015 refers to TransactionDate BETWEEN '2014-06-03' AND '2015-11-27';
SQL: SELECT SUM(T1.PurchasePrice) FROM `transaction` AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID WHERE T2.LocationName = 'Sac State American River Courtyard' AND T1.CreditCardType = 'Visa' AND T1.TransactionDate BETWEEN '2014-06-03' AND '2015-11-27'

Database: talkingdata
Question: Among all the users who use a vivo device, what is the age of the youngest user?
Evidence: vivo device refers to phone_brand = 'vivo'; youngest refers to MIN(age);
SQL: SELECT T1.age FROM gender_age AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T2.phone_brand = 'vivo' ORDER BY T1.age LIMIT 1

Database: books
Question: What is the average number of book pages written by Zilpha Keatley Snyder?
Evidence: "Zilpha Keatley Snyder" is the author_name; average number of book pages refers to AVG(num_pages)
SQL: SELECT AVG(T3.num_pages) FROM book_author AS T1 INNER JOIN author AS T2 ON T1.author_id = T2.author_id INNER JOIN book AS T3 ON T3.book_id = T1.book_id WHERE T2.author_name = 'Zilpha Keatley Snyder'

Database: authors
Question: Gives the home page of the conference where the paper "Increasing the Concurrency in Estelle" is presented.
Evidence: 'Increasing the Concurrency in Estelle' is the Title of the paper; home page of the conference refers to HomePage;
SQL: SELECT DISTINCT T2.HomePage FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T1.Title = 'Increasing the Concurrency in Estelle'

Database: retail_complains
Question: Please list the full name, date of birth, and email id of the elderly clients in descending order of age.
Evidence: full name = first, middle, last; date of birth = year, month, day; elderly clients refers to age > 65;
SQL: SELECT first, middle, last, year, month , day, email FROM client WHERE age > 65 ORDER BY age DESC

Database: sales_in_weather
Question: What is the lowest minimum temperature recorded in store 16 on January 2012?
Evidence: lowest minimum temperature refers to Min(tmin); store 16 refers to store_nbr = 16; on January 2012 refers to Substring (date, 1, 7) = '2012-01'
SQL: SELECT MIN(tmin) FROM weather AS T1 INNER JOIN relation AS T2 ON T1.station_nbr = T2.station_nbr WHERE T2.store_nbr = 16 AND T1.`date` LIKE '%2012-01%'

Database: regional_sales
Question: Which city has the largest population?
Evidence: city has the largest population refers to City Name where MAX(Population);
SQL: SELECT `City Name` FROM `Store Locations` ORDER BY Population DESC LIMIT 1

Database: computer_student
Question: For the professor who advised student no.6, please list the IDs of the courses he or she teaches.
Evidence: professor refers to p_id_dummy and professor = 1; student no.6 refers to advisedBy.p_id = 6; IDs of the courses refers to taughtBy.course_id
SQL: SELECT T2.course_id FROM taughtBy AS T1 INNER JOIN course AS T2 ON T1.course_id = T2.course_id INNER JOIN advisedBy AS T3 ON T3.p_id = T1.p_id WHERE T1.p_id = 9

Database: world
Question: What is the GNP growth rate by the country of Shanghai?
Evidence: GNP growth rate = DIVIDE(SUBTRACT(GNP, GNPOld), GNPOld); Shanghai is a name of city;
SQL: SELECT CAST((T1.GNP - T1.GNPOld) AS REAL) / T1.GNPOld FROM Country AS T1 INNER JOIN City AS T2 ON T1.Code = T2.CountryCode WHERE T2.Name = 'Shanghai'