Database: student_loan
Question: Does disable students join organization. If yes, please indicate the organization joined by the students.
Evidence: organization refers to organ
SQL: SELECT DISTINCT T2.organ FROM disabled AS T1 INNER JOIN enlist AS T2 ON T1.`name` = T2.`name`

Database: books
Question: Who ordered the book with the cheapest price?
Evidence: book with cheapest price refers to Min(price); who order means name of customer which refers to first_name, last_name
SQL: SELECT T3.first_name, T3.last_name FROM order_line AS T1 INNER JOIN cust_order AS T2 ON T2.order_id = T1.order_id INNER JOIN customer AS T3 ON T3.customer_id = T2.customer_id ORDER BY T1.price ASC LIMIT 1

Database: retail_complains
Question: What is the address of the client who made a complaint via postal mail on March 14, 2012?
Evidence: address refers to address_1, address_2; via postal mail refers to Submitted via = 'Postal mail'; March 14 2012 refers to Date received = '2012-03-14'
SQL: SELECT T1.address_1, T1.address_2 FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.`Date received` = '2012-03-14' AND T2.`Submitted via` = 'Postal mail'

Database: food_inspection_2
Question: Write down the last name of employee who did inspection ID 52238?
SQL: SELECT T1.last_name FROM employee AS T1 INNER JOIN inspection AS T2 ON T1.employee_id = T2.employee_id WHERE T2.inspection_id = 52238

Database: authors
Question: What is the full name of the conference where paper number 5 was published?
Evidence: paper number 5 refers to Id = 5
SQL: SELECT T2.FullName FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T1.Id = 5

Database: legislator
Question: Write the full names of junior ranked Republicans.
Evidence: full name refers to official_full_name; junior refers to state_rank = 'junior'; Republicans refers to party = 'Republican'
SQL: SELECT T1.official_full_name FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.party = 'Republican' AND T2.state_rank = 'junior' GROUP BY T1.official_full_name

Database: world
Question: Which country has the shortest life expectancy?
Evidence: shortest life expectancy refers to MIN(LifeExpectancy);
SQL: SELECT Name FROM Country ORDER BY LifeExpectancy LIMIT 1

Database: public_review_platform
Question: Among the businesses with a category of Food, what is the percentage of the business with greater than 3 stars?
Evidence: category of food refers to category_name = 'Food'; calculation = DIVIDE(COUNT(stars > 3), SUM(stars))
SQL: SELECT CAST(SUM(CASE WHEN T1.stars > 3 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.stars) FROM Business AS T1 INNER JOIN Business_Categories AS T2 ON T1.business_id = T2.business_id INNER JOIN Categories AS T3 ON T2.category_id = T3.category_id WHERE T3.category_name = 'Food'

Database: authors
Question: Write the titles of papers published by Adam Jones and the journal name in which it was published from 2005 to 2010.
Evidence: published from 2005 to 2010 refers to Year BETWEEN 2005 AND 2010; published by Adam Jones refers to Name = 'Adam Jones'
SQL: SELECT T1.Title FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId INNER JOIN Journal AS T3 ON T1.JournalId = T3.Id WHERE T2.Name = 'Adam Jones' AND T1.Year BETWEEN 2005 AND 2010

Database: student_loan
Question: Among the students that have been absent from school for more than 5 months, how many of them are male?
Evidence: absent from school for more than 5 months refers to `month`  > = 5;
SQL: SELECT COUNT(T1.name) FROM longest_absense_from_school AS T1 INNER JOIN male AS T2 ON T1.`name` = T2.`name` WHERE T1.`month` >= 5

Database: codebase_comments
Question: Provide the tokenized name of the method "Sky.Excel.ExcelBook.TypeConvert".
Evidence: tokenized name refers to NameTokenized; NameTokenized = 'Sky.Excel.ExcelBook.TypeConvert';
SQL: SELECT NameTokenized FROM Method WHERE Name = 'Sky.Excel.ExcelBook.TypeConvert'

Database: books
Question: What is the name of the first book written by J.K Rowling?
Evidence: "J.K Rowling" is the author_name; first published book refers to book_id where Min(publication_date); name of the book refers to title
SQL: SELECT T1.title FROM book AS T1 INNER JOIN book_author AS T2 ON T1.book_id = T2.book_id INNER JOIN author AS T3 ON T3.author_id = T2.author_id WHERE T3.author_name = 'J.K. Rowling' ORDER BY T1.publication_date ASC LIMIT 1

Database: video_games
Question: How many games were released in 1981?
Evidence: released in 1981 refers to release_year = 1981
SQL: SELECT COUNT(T.id) FROM game_platform AS T WHERE T.release_year = 1981

Database: talkingdata
Question: What is the ID of the device used by the youngest user?
Evidence: ID of the device refers to device_id; youngest user refers to MIN(age);
SQL: SELECT device_id FROM gender_age WHERE age = ( SELECT MIN(age) FROM gender_age )

Database: human_resources
Question: How much higher is James Johnson's salary from the minimum salary of his title?
Evidence: James Johnson is the fullname of an employee; full name = firstname, lastname; minimum salary refers to minsalary; calculation = SUBTRACT(salary, minsalary)
SQL: SELECT CAST(REPLACE(SUBSTR(T1.salary, 4), ',', '') AS REAL) - CAST(REPLACE(SUBSTR(T2.minsalary, 4), ',', '') AS REAL) AS diff FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T1.lastname = 'Johnson' AND T1.firstname = 'James'

Database: olympics
Question: What is the id of Rio de Janeiro?
Evidence: Rio de Janeiro refers to city_name = 'Rio de Janeiro';
SQL: SELECT id FROM city WHERE city_name = 'Rio de Janeiro'

Database: movies_4
Question: What is the title of the movie that was made with the most money and resources?
Evidence: made with the most money and resources refers to max(budget)
SQL: SELECT title FROM movie ORDER BY budget DESC LIMIT 1

Database: movies_4
Question: List down the movie titles within the genre of thriller.
Evidence: genre of thriller refers to genre_name = 'Thriller'
SQL: SELECT T1.title FROM movie AS T1 INNER JOIN movie_genres AS T2 ON T1.movie_id = T2.movie_id INNER JOIN genre AS T3 ON T2.genre_id = T3.genre_id WHERE T3.genre_name = 'Thriller'

Database: world_development_indicators
Question: List all the country in East Asia & Pacific region that have more than 2000000 urban population in 1970.
Evidence: country refers to LongName; have more than 2000000 urban population refers to value where indicatorname = 'Urban population'>2000000; in 1970 refers to year = '1970'
SQL: SELECT DISTINCT T1.CountryCode FROM Country AS T1 INNER JOIN Indicators AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.Year = 1970 AND T1.Region = 'East Asia & Pacific' AND T2.Value > 2000000 AND t2.indicatorname = 'Urban population'

Database: legislator
Question: Compare the number of legislators who started the term in 1875 and 2005.
Evidence: started the term in 1875 refers to start LIKE '1875%'; started the term in 2005 refers to start LIKE '2005%'
SQL: SELECT SUM(CASE WHEN `current-terms`.start LIKE '2005%' THEN 1 ELSE 0 END) - ( SELECT SUM(CASE WHEN start LIKE '1875%' THEN 1 ELSE 0 END) FROM `historical-terms` ) FROM `current-terms`

Database: shipping
Question: What is the address of the driver that delivers the shipment for the customer lives at 7052 Carroll Road, San Diego, California?
Evidence: "7052 Carroll Road" is the address of customer; 'San Diego' is the city; 'California' is the state
SQL: SELECT T3.address FROM shipment AS T1 INNER JOIN customer AS T2 ON T1.cust_id = T2.cust_id INNER JOIN driver AS T3 ON T3.driver_id = T1.driver_id WHERE T2.address = '7052 Carroll Road' AND T2.city = 'San Diego' AND T2.state = 'CA'