Database: donor
Question: Which projects created by teachers with Doctor Degree where the project have more than 300 students involved. List down the title of the project.
Evidence: eachers with Doctor Degree refers to teacher_prefix = 'Dr.'; more than 300 students involved refers to students_reached > 300
SQL: SELECT T1.title FROM essays AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.teacher_prefix LIKE 'Dr.' AND T2.students_reached > 300

Database: public_review_platform
Question: Among businesses with "Wi-Fi" attribute, which businesses id are located at SC State?
Evidence: "Wi-Fi" attribute refers to attribute_name = 'Wi-Fi' AND attribute_value = 'true'
SQL: SELECT T3.business_id FROM Attributes AS T1 INNER JOIN Business_Attributes AS T2 ON T1.attribute_id = T2.attribute_id INNER JOIN Business AS T3 ON T2.business_id = T3.business_id WHERE T1.attribute_name = 'Wi-Fi' AND T2.attribute_value = 'true' AND T3.state = 'SC'

Database: retail_complains
Question: For the client who made the complaint call "CR0217298", what was his/her birthday？
Evidence: complaint call refers to Complaint ID; birthday = year, month, day;
SQL: SELECT T1.month, T1.day FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.`Complaint ID` = 'CR0217298'

Database: talkingdata
Question: How many users belong to "game-Art Style" category?
SQL: SELECT COUNT(T1.app_id) FROM app_labels AS T1 INNER JOIN label_categories AS T2 ON T1.label_id = T2.label_id WHERE T2.category = 'game-Art Style'

Database: retail_world
Question: What is the total production of the products from the supplier “Escargots Nouveaux”?
Evidence: total production of the products = add(units in stock , units on order); supplier “Escargots Nouveaux” refers to CompanyName = 'Escargots Nouveaux'
SQL: SELECT SUM(T1.UnitsInStock + T1.UnitsOnOrder) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Escargots Nouveaux'

Database: authors
Question: From year 1991 to 2000, calculate the difference betweeen the total number of papers published under the conference "International Conference on Supercomputing " and "Informatik & Schule"?
Evidence: From year 1991 to 2000 refers to Year BETWEEN 1991 AND 2000; papers refers to Paper.Id; 'International Conference on Supercomputing' AND 'Informatik & Schule' are the FullName of conference; calculate the difference between the total number of papers of these two conferences refers to SUBTRACT(SUM(Paper.Id where FullName = 'International Conference on Supercomputing'), SUM(Paper.Id where FullName = 'Informatik & Schule'))
SQL: SELECT SUM(CASE WHEN T2.FullName = 'Informatik & Schule' THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.FullName = 'International Conference on Supercomputing' THEN 1 ELSE 0 END) AS DIFF FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T1.Year > 1990 AND T1.Year < 2001

Database: video_games
Question: How many games are not of the genres 'Role-Playing', 'Shooter' and 'Simulation'?
Evidence: not of the genres 'Role-Playing', 'Shooter' and 'Simulation' refers to genre_name NOT IN ('Role-Playing', 'Shooter', 'Simulation');
SQL: SELECT COUNT(T2.id) FROM genre AS T1 INNER JOIN game AS T2 ON T1.id = T2.genre_id WHERE T1.genre_name NOT IN ('Role-Playing', 'Shooter', 'Simulation')

Database: music_tracker
Question: Please list all tags of kurtis blow from 2000 to 2010.
Evidence: kurtis blow is an artist; from 2000 to 2010 refers to groupYear between 2000 and 2010;
SQL: SELECT T2.tag FROM torrents AS T1 INNER JOIN tags AS T2 ON T1.id = T2.id WHERE T1.groupYear BETWEEN 2000 AND 2010 AND T1.artist LIKE 'kurtis blow'

Database: cookbook
Question: What are the names of the top 5 recipes that are best for wound healing?
Evidence: names of the recipes refers to title; best for wound healing refers to MAX(vitamin_c)
SQL: SELECT T1.title FROM Recipe AS T1 INNER JOIN Nutrition AS T2 ON T1.recipe_id = T2.recipe_id ORDER BY T2.vitamin_c DESC LIMIT 5

Database: shakespeare
Question: How many paragraphs are there in Act 5 Scene 1 of "Comedy of Errors"?
Evidence: "Comedy of Errors" refers to Title = 'Comedy of Errors'
SQL: SELECT COUNT(T3.id) FROM works AS T1 INNER JOIN chapters AS T2 ON T1.id = T2.work_id INNER JOIN paragraphs AS T3 ON T2.id = T3.chapter_id WHERE T2.Act = 5 AND T2.Scene = 1 AND T1.Title = 'Comedy of Errors'

Database: law_episode
Question: What is the episode rating with the most award won?
Evidence: the most award won refers to max(episode_id where result = 'Winner')
SQL: SELECT T1.rating FROM Episode AS T1 INNER JOIN Award AS T2 ON T1.episode_id = T2.episode_id WHERE T2.result = 'Winner' GROUP BY T1.episode_id ORDER BY COUNT(T2.award_id) DESC LIMIT 1

Database: donor
Question: Which payment method is most comonly used by the schools in the state of Georgia for the payment of donations?
Evidence: Georgia refer to school_state = 'GA'

SQL: SELECT T1.payment_method FROM donations AS T1 INNER JOIN projects AS T2 ON T1.projectid = T2.projectid WHERE T2.school_state = 'GA' GROUP BY T2.school_state ORDER BY COUNT(T1.payment_method) DESC LIMIT 1

Database: books
Question: What is the current address of customer Kandy?
Evidence: current address refers to address_status = 1; address refers to street_number, street_name, city
SQL: SELECT T3.street_number, T3.street_name, T3.city FROM customer AS T1 INNER JOIN customer_address AS T2 ON T1.customer_id = T2.customer_id INNER JOIN address AS T3 ON T3.address_id = T2.address_id INNER JOIN address_status AS T4 ON T4.status_id = T2.status_id WHERE T1.first_name = 'Kandy'

Database: legislator
Question: State number of legislators who are not the senator among female legislators.
Evidence: not the senator refers to class IS NULL OR class = ''; female refers to gender_bio = 'F';
SQL: SELECT COUNT(*) FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T1.gender_bio = 'F' AND (T2.class IS NULL OR T2.class = '')

Database: retail_world
Question: Tell the name of the shipper company for the order No.10585.
Evidence: name of the shipper company refers to ShipName; order No. refers to OrderID;
SQL: SELECT T2.CompanyName FROM Orders AS T1 INNER JOIN Shippers AS T2 ON T1.ShipVia = T2.ShipperID WHERE T1.OrderID = 10585

Database: computer_student
Question: How many courses were taught by a professor who is currently the member of faculty?
Evidence: professor refers to professor = 1;  member of faculty refers to hasPosition <> 0
SQL: SELECT COUNT(*) FROM person AS T1 INNER JOIN taughtBy AS T2 ON T1.p_id = T2.p_id WHERE T1.professor = 1 AND T1.hasPosition <> 0

Database: shakespeare
Question: What is the description of the chapter with the longest number of paragraphs?
Evidence: chapter with the longest number of paragraphs refers to max(ParagraphNum)
SQL: SELECT T2.Description FROM paragraphs AS T1 INNER JOIN chapters AS T2 ON T1.chapter_id = T2.id ORDER BY T1.ParagraphNum DESC LIMIT 1

Database: world
Question: Describe the capital city and languages used in the country with the shortest life expectancy.
Evidence: capital city refers to Capital; shortest life expectancy refers to MIN(LifeExpectancy);
SQL: SELECT T1.Capital, T2.Language FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode INNER JOIN City AS T3 ON T1.Code = T3.CountryCode ORDER BY T1.LifeExpectancy LIMIT 1

Database: image_and_language
Question: What is the average width and height of the objects in image ID 47? List their object classes as well.
Evidence: The bounding box's W and H abbreviations stand for the object's width and height in which average width and height refer to AVG(W) and AVG(H) respectively; image ID 47 refers to IMG_ID = 47; object classes refer to OBJ_CLASS;
SQL: SELECT T2.OBJ_CLASS, AVG(T1.W), AVG(T1.H) FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T1.IMG_ID = 47 GROUP BY T2.OBJ_CLASS