Database: human_resources
Question: How many employees work as an Account Representative?
Evidence: work as an Account Representative refers to positiontitle = 'Account Representative'
SQL: SELECT COUNT(*) FROM employee AS T1  INNER JOIN position AS T2  ON T1.positionID = T2.positionID WHERE T2.positiontitle = 'Account Representative'

Database: codebase_comments
Question: How many English language codes whose comments for the method are in the XML format?
Evidence: English language refers to Lang = 'en'; the comments for this method is XML format refers to CommentIsXml = 1;
SQL: SELECT COUNT(Lang) FROM Method WHERE Lang = 'en' AND CommentIsXml = 1

Database: cs_semester
Question: Which professor advised Faina Mallinar to become a research assistant? Please give his or her full name.
Evidence: research assistant refers to the student who serves for research where the abbreviation is RA; full name refers to f_name and l_name;
SQL: SELECT T1.first_name, T1.last_name FROM prof AS T1 INNER JOIN RA AS T2 ON T1.prof_id = T2.prof_id INNER JOIN student AS T3 ON T2.student_id = T3.student_id WHERE T3.f_name = 'Faina' AND T3.l_name = 'Mallinar'

Database: app_store
Question: Indicate the number of installs and include the percentage of positive sentiments of FREEDOME VPN Unlimited anonymous Wifi Security.
Evidence: FREEDOME VPN Unlimited anonymous Wifi Security is the App; percentage = MULTIPLY(DIVIDE((SUM(Sentiment = 'Positive')), (COUNT(*))), 100)
SQL: SELECT T1.Installs , CAST(SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) * 100 / SUM(CASE WHEN T2.Sentiment IS NOT NULL THEN 1.0 ELSE 0 END) AS REAL) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'FREEDOME VPN Unlimited anonymous Wifi Security'

Database: regional_sales
Question: List down the customer names and product names of the order made by "Anthony Torres" via distributor channel.
Evidence: "Anthony Torres" is the name of Sales Team; distributor channel refers to Sales Channel = 'Distributor'
SQL: SELECT DISTINCT T1.`Customer Names`, T4.`Product Name` FROM Customers AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._CustomerID = T1.CustomerID INNER JOIN `Sales Team` AS T3 ON T3.SalesTeamID = T2._SalesTeamID INNER JOIN Products AS T4 ON T4.ProductID = T2._ProductID WHERE T3.`Sales Team` = 'Anthony Torres' AND T2.`Sales Channel` = 'Distributor'

Database: software_company
Question: List down the geographic identifier with an number of inhabitants less than 30.
Evidence: geographic identifier with an number of inhabitants less than 30 refers to GEOID where INHABITANTS_K < 30;
SQL: SELECT GEOID FROM Demog WHERE INHABITANTS_K < 30

Database: simpson_episodes
Question: Write down all the keywords for winner of "WGA Award (TV)" award.
Evidence: winner of "WGA Award (TV)" award refers to award_category = 'WGA Award (TV)' and result = 'Winner'
SQL: SELECT T2.keyword FROM Award AS T1 INNER JOIN Keyword AS T2 ON T2.episode_id = T1.episode_id WHERE T1.award_category = 'WGA Award (TV)';

Database: soccer_2016
Question: List the match IDs which had players out by hit wickets.
Evidence: had players out by hit wickets refers to Out_Name = 'hit wicket'
SQL: SELECT T1.Match_Id FROM Wicket_Taken AS T1 INNER JOIN Out_Type AS T2 ON T2.Out_Id = T1.Kind_Out WHERE T2.Out_Name = 'hit wicket'

Database: synthea
Question: How many white patients have the reason code of 10509002?
Evidence: white refers to race = 'white'; reason code of 10509002 refers to careplans.REASONCODE = '10509002';
SQL: SELECT COUNT(DISTINCT T1.PATIENT) FROM careplans AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T2.race = 'white' AND T1.REASONCODE = '10509002'

Database: university
Question: List the criteria names under the ranking system called Center for World University Ranking.
Evidence: ranking system called Center for World University Ranking refers to system_name = 'Center for World University Rankings';
SQL: SELECT T2.criteria_name FROM ranking_system AS T1 INNER JOIN ranking_criteria AS T2 ON T1.id = T2.ranking_system_id WHERE T1.system_name = 'Center for World University Rankings'

Database: food_inspection_2
Question: What are the inspection description and inspector's comments in the inspection ID 164795?
Evidence: inspection description refers to Description; inspector's comment refers to inspector_comment
SQL: SELECT T1.Description, T2.inspector_comment FROM inspection_point AS T1 INNER JOIN violation AS T2 ON T1.point_id = T2.point_id WHERE T2.inspection_id = 44247

Database: car_retails
Question: State 10 emails of UK Sales Rep who have the lowest credit limit.
Evidence: UK is a country; Sales Rep is a job title;
SQL: SELECT DISTINCT T2.email FROM customers AS T1 INNER JOIN employees AS T2 ON T1.salesRepEmployeeNumber = T2.employeeNumber WHERE T2.jobTitle = 'Sales Rep' AND T1.country = 'UK' ORDER BY T1.creditLimit LIMIT 10

Database: movie
Question: How tall is the actor who played "Lurch"?
Evidence: tall refers to Height (Inches); "Lurch" refers to Character Name = 'Lurch'
SQL: SELECT T2.`Height (Inches)` FROM characters AS T1 INNER JOIN actor AS T2 ON T1.ActorID = T2.ActorID WHERE T1.`Character Name` = 'Lurch'

Database: chicago_crime
Question: How many crime against property are there?
SQL: SELECT COUNT(*) AS cnt FROM FBI_Code WHERE crime_against = 'Property'

Database: language_corpus
Question: Please list the Catalan words with an occurrence of over 200000.
Evidence: occurrence of over 200000 refers to occurrences > 200000;
SQL: SELECT word FROM words WHERE occurrences > 200000

Database: university
Question: How many state universities are there?
Evidence: state universities refers to university_name LIKE '%State%';
SQL: SELECT COUNT(*) FROM university WHERE university_name LIKE '%State%'

Database: image_and_language
Question: Provide the x-coordinate and y-coordinate of the image with an attribute class of ''horse" and an object class of "fur".
Evidence: attribute class of "horse" refers to ATT_CLASS = 'horse'; object class of "fur" refers to OBJ_CLASS = 'fur';
SQL: SELECT 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 INNER JOIN OBJ_CLASSES AS T4 ON T3.OBJ_CLASS_ID = T4.OBJ_CLASS_ID WHERE T1.ATT_CLASS = 'horse' AND T4.OBJ_CLASS = 'fur'

Database: car_retails
Question: What is the full address of the customer who commented that DHL be used for the order that was shipped on April 4, 2005?
Evidence: full address = addressLine1+addressLine2; shippedDate = '2005-04-04';
SQL: SELECT T1.addressLine1, T1.addressLine2 FROM customers AS T1 INNER JOIN orders AS T2 ON T1.customerNumber = T2.customerNumber WHERE T2.shippedDate = '2005-04-04' AND T2.status = 'Shipped'

Database: video_games
Question: In which regions has the game 'Pengo' been sold?
Evidence: which regions refers to region_name; 'Pengo' refers to game_name = 'Pengo';
SQL: SELECT T5.region_name FROM game AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.game_id INNER JOIN game_platform AS T3 ON T2.id = T3.game_publisher_id INNER JOIN region_sales AS T4 ON T3.id = T4.game_platform_id INNER JOIN region AS T5 ON T4.region_id = T5.id WHERE T1.game_name = 'Pengo'

Database: social_media
Question: What gender of users retweet more than 30 times?
Evidence: retweet more than 30 times refers to RetweetCount > 30
SQL: SELECT DISTINCT T2.Gender FROM twitter AS T1 INNER JOIN user AS T2 ON T1.UserID = T2.UserID WHERE T1.RetweetCount > 30

Database: donor
Question: What is the average total donations received by Fresno County colleges?
Evidence: Fresno County colleges refers to school_county = 'Fresno'; average refers to DIVIDE(sum(donation_optional_support,donation_to_project),sum(donation_total))
SQL: SELECT SUM(T2.donation_optional_support + T2.donation_to_project) / COUNT(donationid) FROM projects AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T1.school_county = 'Fresno'