Database: image_and_language
Question: State the coordinate of X and Y for the object with the attribute of 'sparse' in image 1.
Evidence: coordinates of X and Y for the object refer to X and Y coordinates of the bounding box; attribute of 'sparse' in image 1 refers to IMG_ID = 1 where ATT_CLASS = 'sparse';
SQL: SELECT T3.OBJ_SAMPLE_ID, T3.X, T3.Y FROM ATT_CLASSES AS T1 INNER JOIN IMG_OBJ_ATT AS T2 ON T1.ATT_CLASS_ID = T2.ATT_CLASS_ID INNER JOIN IMG_OBJ AS T3 ON T2.IMG_ID = T3.IMG_ID WHERE T3.IMG_ID = 1 AND T1.ATT_CLASS = 'sparse'

Database: retails
Question: Calculate the percentage of suppliers in Germany.
Evidence: DIVIDE(COUNT(s_suppkey where n_name = 'GERMANY'), COUNT(s_suppkey)) as percentage;
SQL: SELECT CAST(SUM(IIF(T2.n_name = 'GERMANY', 1, 0)) AS REAL) * 100 / COUNT(T1.s_suppkey) FROM supplier AS T1 INNER JOIN nation AS T2 ON T1.s_nationkey = T2.n_nationkey WHERE T1.s_acctbal < 0

Database: image_and_language
Question: What is the object whose attribute is blurry in image no.2377993? Give the explanation about the object.
Evidence: attribute is blurry refers to ATT_CLASS = 'blurry'; image no.2377993 refers to IMG_ID = 22377993; explanation about the object refers to OBJ_CLASS
SQL: SELECT T4.OBJ_CLASS_ID, T4.OBJ_CLASS FROM IMG_OBJ_att AS T1 INNER JOIN ATT_CLASSES AS T2 ON T1.ATT_CLASS_ID = T2.ATT_CLASS_ID INNER JOIN IMG_OBJ AS T3 ON T1.IMG_ID = T3.IMG_ID INNER JOIN OBJ_CLASSES AS T4 ON T3.OBJ_CLASS_ID = T4.OBJ_CLASS_ID WHERE T2.ATT_CLASS = 'blurry' AND T1.IMG_ID = 22377993

Database: world_development_indicators
Question: Which country have conducted population census from 2010 until 2012 and have completed vital registration?
Evidence: from 2010 until 2012 refers to LatestPopulationCensus between '2010' and '2012'; have completed vital registration refers to VitalRegistrationComplete = 'Yes'; CountryName = ShortName + LongName
SQL: SELECT ShortName, LongName FROM Country WHERE LatestPopulationCensus >= 2010 AND LatestPopulationCensus < 2013 AND VitalRegistrationComplete = 'Yes'

Database: movies_4
Question: Calculate the average income made by movies using the keyword "paris". List the title of the movies.
Evidence: income refers to revenue; keyword "paris" refers to keyword_name = 'paris'; average income = AVG(revenue)
SQL: SELECT AVG(T1.revenue), T1.title FROM movie AS T1 INNER JOIN movie_keywords AS T2 ON T1.movie_id = T2.movie_id INNER JOIN keyword AS T3 ON T2.keyword_id = T3.keyword_id WHERE T3.keyword_name = 'paris'

Database: simpson_episodes
Question: In episodes aired in 2009, how many of them are credited to Sam Im for additional timer?
Evidence: in 2009 refers to air_date LIKE '2009%'; credited refers to credited = 'true'; Sam Im refers to person = 'Sam Im'; for additional timer refers to role = 'additional timer'
SQL: SELECT COUNT(*) FROM Episode AS T1 INNER JOIN Credit AS T2 ON T1.episode_id = T2.episode_id WHERE T2.credited = 'true' AND T2.person = 'Sam Im' AND SUBSTR(T1.air_date, 1, 4) = '2009' AND T2.role = 'additional timer';

Database: donor
Question: What is the total number of projects that was created by the teachers that teach 3-5 grades in Boston Public School District?
Evidence: teach 3-5 grades refers to grade_level = 'Grades 3-5'; 'Boston Public School District' is school_district;
SQL: SELECT COUNT(projectid) FROM projects WHERE school_district = 'Boston Public School District' AND grade_level = 'Grades 3-5'

Database: world
Question: How many cities are in the Philippines?
Evidence: Philippines refers to CountryCode = 'PHL';
SQL: SELECT COUNT(ID) FROM City WHERE Name = 'PHL'

Database: movie_platform
Question: What is the percentage of list created by user who was a subscriber when he created the list?
Evidence: was a subscriber refers to user_subscriber = 1; percentage refers to DIVIDE(COUNT(user_subscriber = 1),COUNT(list_id))
SQL: SELECT CAST(SUM(CASE WHEN user_subscriber = 1 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(list_id) FROM lists_users

Database: superstore
Question: Which customer ordered 'Global High-Back Leather Tilter, Burgundy' on 10/13/2013 in the East region?
Evidence: 'Global High-Back Leather Tilter, Burgundy' is the "Product Name"; on 10/13/2013 refers to "Order Date" = Date('2013-10-13'); Region = 'East'
SQL: SELECT DISTINCT T2.`Customer Name` FROM east_superstore AS T1 INNER JOIN people AS T2 ON T1.`Customer ID` = T2.`Customer ID` INNER JOIN product AS T3 ON T3.`Product ID` = T1.`Product ID` WHERE T3.`Product Name` = 'Global High-Back Leather Tilter, Burgundy' AND T1.`Order Date` = '2013-10-13' AND T1.Region = 'East'

Database: disney
Question: Who are the voice actors for all the heroes?
Evidence: FALSE;
SQL: SELECT T2.`voice-actor` FROM characters AS T1 INNER JOIN `voice-actors` AS T2 ON T2.character = T1.hero WHERE T2.movie = T1.movie_title

Database: legislator
Question: Among the current legislators who do not have accounts on OpenSecrets.org., how many of them do not have instagram accounts either?
Evidence: do not have accounts on OpenSecrets.org refers to opensecrets_ID is NULL OR opensecrets_id = ''; do not have instagram accounts refers to instagram is null
SQL: SELECT SUM(CASE WHEN T1.instagram IS NULL THEN 1 ELSE 0 END) AS count FROM `social-media` AS T1 INNER JOIN current AS T2 ON T1.bioguide = T2.bioguide_id WHERE T2.opensecrets_id IS NULL OR T2.opensecrets_id = ''

Database: chicago_crime
Question: Among the incidents with the generic description of "BATTERY" in the IUCR classification, how many of them do not have arrests made?
Evidence: general description refers to primary_description; 'BATTERY' is the primary_description; do not have arrest made refers to arrest = 'FALSE'
SQL: SELECT SUM(CASE WHEN T2.arrest = 'FALSE' THEN 1 ELSE 0 END) FROM IUCR AS T1 INNER JOIN Crime AS T2 ON T1.iucr_no = T2.iucr_no WHERE T1.primary_description = 'BATTERY'

Database: codebase_comments
Question: Give the repository ID for the solution of method "Kalibrasi.Data.EntityClasses.THistoryJadwalEntity.GetSingleTjadwal".
Evidence: repository ID refers to RepoID; method refers to Name; Name = 'Kalibrasi.Data.EntityClasses.THistoryJadwalEntity.GetSingleTjadwal';
SQL: SELECT DISTINCT T1.RepoId FROM Solution AS T1 INNER JOIN Method AS T2 ON T1.Id = T2.SolutionId WHERE T2.Name = 'Kalibrasi.Data.EntityClasses.THistoryJadwalEntity.GetSingleTjadwal'

Database: movie_platform
Question: How many users in Mubi give the movie "White Night Wedding for 5"?
Evidence: White Night Wedding' is movie_title; for 5 refers to rating_score = 5;
SQL: SELECT COUNT(T1.user_id) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5 AND T2.movie_title = 'White Night Wedding'

Database: cs_semester
Question: Among the students with high salary, what is total number of students with a GPA higher than 3?
Evidence: high salary refers to salary = 'high'; GPA higher than 3 refers to gpa > 3;
SQL: SELECT COUNT(T1.student_id) FROM RA AS T1 INNER JOIN student AS T2 ON T1.student_id = T2.student_id WHERE T1.salary = 'high' AND T2.gpa > 3

Database: student_loan
Question: How many disabled students are female?
Evidence: female refers to disabled.name who are NOT in male.name;
SQL: SELECT COUNT(name) FROM disabled WHERE name NOT IN ( SELECT name FROM male )

Database: mental_health_survey
Question: How many users answered the question No.20?
Evidence: question No.20 refers to QuestionID = 20
SQL: SELECT MAX(UserID) - MIN(UserID) + 1 FROM Answer WHERE QuestionID = 20

Database: retail_world
Question: Which employee has the highest salary? Please give his or her full name.
Evidence: highest salary refers to MAX(Salary); full name = FirstName, LastName;
SQL: SELECT FirstName, LastName FROM Employees WHERE Salary = ( SELECT MAX(Salary) FROM Employees )