Database: image_and_language
Question: What are the id of all the objects belonging to the transportation class?
Evidence: id of all the objects belonging to the transportation class refers to OBJ_CLASS_ID and OBJ_CLASS IN ('bus', 'train', 'aeroplane', 'car', 'etc.')
SQL: SELECT OBJ_CLASS_ID FROM OBJ_CLASSES WHERE OBJ_CLASS IN ('bus', 'train', 'aeroplane', 'car', 'etc')

Database: restaurant
Question: Please indicate which labels have the city located in Santa Cruz.
Evidence: Santa Cruz refers to county = 'Santa Cruz county'
SQL: SELECT T1.label FROM generalinfo AS T1 INNER JOIN geographic AS T2 ON T1.city = T2.city WHERE T2.county = 'Santa Cruz county'

Database: image_and_language
Question: In the Y coordinate of image ID 12, how many are 0?
Evidence: Y coordinate many are 0 refers to Y coordinates of the bounding box where Y = 0; image ID 12 refers to IMG_ID = 12;
SQL: SELECT COUNT(IMG_ID) FROM IMG_OBJ WHERE IMG_ID = 12 AND Y = 0

Database: donor
Question: Among all the donors from New York, how many of them are teachers?
Evidence: from New York refers to donor_city = 'New York'; donor is a teacher refers to is_teacher_acct = 't';
SQL: SELECT COUNT(donationid) FROM donations WHERE is_teacher_acct = 't' AND donor_city = 'New York'

Database: movie_platform
Question: Was user 39115684 a trialist when he or she rated the movie "A Way of Life"?
Evidence: A Way of Life' refers to movie_title; user 39115684 refers to userid = 39115684;  the user was a trialist when he rated the movie refers to user_trialist = 1;
SQL: SELECT T1.user_trialist FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'A Way of Life' AND T1.user_id = 39115684

Database: synthea
Question: List down the first name of patients who received "Influenza seasonal injectable preservative free" immunization.
Evidence: "Influenza seasonal injectable preservative free" immunization refers to immunizations where DESCRIPTION = 'Influenza seasonal injectable preservative free';
SQL: SELECT DISTINCT T1.first, T1.last FROM patients AS T1 INNER JOIN immunizations AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Influenza  seasonal  injectable  preservative free'

Database: genes
Question: What type of interactions occurs in genes whose function is cellular transport and transport medicine and are classified as non-essential?
SQL: SELECT T2.Type FROM Genes AS T1 INNER JOIN Interactions AS T2 ON T1.GeneID = T2.GeneID1 WHERE T1.Function = 'TRANSCRIPTION' AND T1.Essential = 'Non-Essential'

Database: books
Question: What is the cost of the slowest and least expensive shipping method?
Evidence: slowest and least expesive method refers to shipping_method = 'Standard'
SQL: SELECT method_name FROM shipping_method ORDER BY cost ASC LIMIT 1

Database: public_review_platform
Question: How many 5 star businesses have uber review votes for funny?
Evidence: businesses refer to business_id; review_stars = 5.0; review_votes_funny = 'uber';
SQL: SELECT COUNT(business_id) FROM Reviews WHERE review_stars = 5 AND review_votes_funny = 'Uber'

Database: video_games
Question: How many publishers published the Minecraft game?
Evidence: Minecraft refers to game_name = 'Minecraft';
SQL: SELECT COUNT(T2.publisher_id) FROM game AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.game_id WHERE T1.game_name = 'Minecraft'

Database: authors
Question: What is the title of the paper published in 1995 and whose author included Thomas Wiegand?
Evidence: published in 1995 refers to Year = 1995; 'Thomas Wiegand' is the name of author
SQL: SELECT T2.Title FROM PaperAuthor AS T1 INNER JOIN Paper AS T2 ON T1.PaperId = T2.Id WHERE T1.Name = 'Thomas Wiegand' AND T2.Year = 1995

Database: authors
Question: What are the affiliations of the author "Mark A. Musen" written on and off paper?
Evidence: Mark A. Musen refer to Author.Name;
SQL: SELECT T1.Affiliation FROM PaperAuthor AS T1 INNER JOIN Author AS T2 ON T1.AuthorId = T2.Id WHERE T2.Name = 'Mark A. Musen'

Database: menu
Question: What is the image ID of page 1 of the menu "Zentral Theater Terrace"?
Evidence: page 1 refers to page_number = 1; Zentral Theater Terrace is a name of menu;
SQL: SELECT T2.image_id FROM Menu AS T1 INNER JOIN MenuPage AS T2 ON T1.id = T2.menu_id WHERE T1.name = 'Zentral Theater Terrace' AND T2.page_number = 1

Database: professional_basketball
Question: Who is the longest serving coach from year 1970 to 1980. List the coach ID and the team(s) he served.
Evidence: 1970 to 1980 refers to year between 1970 and 1980; longest serving coach Max(Count(coachID)); team(s) he served refers to tmID
SQL: SELECT coachID, tmID FROM coaches WHERE year BETWEEN 1970 AND 1980 ORDER BY stint DESC LIMIT 1

Database: cs_semester
Question: Please list the full names of all the students who took the course Machine Learning Theory.
Evidence: full name refers to f_name and l_name;
SQL: SELECT T1.f_name, T1.l_name FROM student AS T1 INNER JOIN registration AS T2 ON T1.student_id = T2.student_id INNER JOIN course AS T3 ON T2.course_id = T3.course_id WHERE T3.name = 'Machine Learning Theory'

Database: retails
Question: What is the total price of all the orders made by customers in Germany?
Evidence: orders refer to o_orderkey; total price refers to o_totalprice; Germany is the name of the nation which refers to n_name = 'GERMANY';
SQL: SELECT SUM(T3.o_totalprice) FROM nation AS T1 INNER JOIN customer AS T2 ON T1.n_nationkey = T2.c_nationkey INNER JOIN orders AS T3 ON T2.c_custkey = T3.o_custkey WHERE T1.n_name = 'GERMANY'

Database: books
Question: List 10 addresses located in Poland.
Evidence: "Polan" is the country_name; address refers to street_number, street_name, city
SQL: SELECT T1.street_number, T1.street_name, T1.city FROM address AS T1 INNER JOIN country AS T2 ON T2.country_id = T1.country_id WHERE T2.country_name = 'Poland' LIMIT 10

Database: sales_in_weather
Question: For the weather station has store no.9, what was the increased percentage of the average temperature from 2012/2/2 to 2012/2/3?
Evidence: store no.9 refers to store_nbr = 9; 2012/2/2 refers to date = '2012-02-02'; 2012/2/3 refers to date = '2012-02-03'; average temperature refers to tavg; increase percentage = Divide (Subtract (tavg where date = '2012-02-03', tavg where date = '2012-02-02'), tavg where date = '2012-02-02') * 100
SQL: SELECT CAST((SUM(CASE WHEN T1.`date` = '2012-02-03' THEN T1.tavg * 1 ELSE 0 END) - SUM(CASE WHEN T1.`date` = '2012-02-02' THEN T1.tavg * 1 ELSE 0 END)) AS REAL) * 100 / SUM(CASE WHEN T1.`date` = '2012-02-02' THEN T1.tavg * 1 ELSE 0 END) FROM weather AS T1 INNER JOIN relation AS T2 ON T1.station_nbr = T2.station_nbr WHERE T2.store_nbr = 9

Database: student_loan
Question: How many unemployed students have payment due?
Evidence: have payment due refers to bool = 'pos';
SQL: SELECT COUNT(T1.name) FROM no_payment_due AS T1 INNER JOIN unemployed AS T2 ON T2.name = T1.name WHERE T1.bool = 'pos'

Database: public_review_platform
Question: What is the ratio of having the best to worse elite user in 2013?
Evidence: best elite refers to user_average_stars = 5; worse eliter refers to user_average_stars = 1: in 2013 refers to year_id = 2013; ratio = Divide(Count(user_id(user_average_stars = 5)),  Count(user_id(user_average_stars = 1)))
SQL: SELECT CAST(SUM(CASE WHEN T1.user_average_stars = 1 THEN 1 ELSE 0 END) AS REAL) / COUNT(T2.user_id) , SUM(CASE WHEN T1.user_average_stars = 5 THEN 1 ELSE 0 END) * 1.0 / COUNT(T2.user_id) FROM Users AS T1 INNER JOIN Elite AS T2 ON T1.user_id = T2.user_id WHERE T2.year_id = 2013