Database: public_review_platform
Question: How many users have "uber" number of fans?
Evidence: uber number of fans refers to user_fans = 'uber';
SQL: SELECT COUNT(user_id) FROM Users WHERE user_fans LIKE 'Uber'

Database: chicago_crime
Question: Find the community area where the least number of domestic crimes happened.
Evidence: least number of domestic crime refers to Min(Count(domestic = "TRUE")); community area refers to community_area_no
SQL: SELECT T2.community_area_no FROM Crime AS T1 INNER JOIN Community_Area AS T2 ON T2.community_area_no = T1.community_area_no WHERE T1.domestic = 'TRUE' GROUP BY T2.community_area_no ORDER BY COUNT(T2.community_area_no) ASC LIMIT 1

Database: world
Question: List all the countries in Asia.
Evidence: Asia refers to Continent = 'Asia';
SQL: SELECT Name FROM Country WHERE Continent = 'Asia'

Database: music_tracker
Question: Please list the releases that have been downloaded for more than 20000 times.
Evidence: releases refer to groupName; downloaded for more than 20000 times refers to totalSnatched > 20000;
SQL: SELECT groupName FROM torrents WHERE totalSnatched > 20000

Database: university
Question: Provide the ranking criteria and scores in 2005 that were received by Harvard University.
Evidence: Harvard University refers to university_name = 'Harvard University'; in 2005 refers to year = 2005; ranking criteria refers to criteria_name;
SQL: SELECT T1.criteria_name, T2.score FROM ranking_criteria AS T1 INNER JOIN university_ranking_year AS T2 ON T1.id = T2.ranking_criteria_id INNER JOIN university AS T3 ON T3.id = T2.university_id WHERE T3.university_name = 'Harvard University' AND T2.year = 2005

Database: image_and_language
Question: What is the bounding box of the object with image id 4 and a prediction relationship class id of 144?
Evidence: bounding box of the object refers to (x, y, W, H); image id refers to IMG_ID; prediction relationship class id of 144 refers to PRED_CLASS_ID = 144
SQL: SELECT T2.X, T2.Y, T2.W, T2.H FROM IMG_REL AS T1 INNER JOIN IMG_OBJ AS T2 ON T1.IMG_ID = T2.IMG_ID WHERE T1.PRED_CLASS_ID = 144 AND T1.IMG_ID = 3

Database: retail_world
Question: What is the total production of the product that is ordered in the highest quantity in order no. 10248?
Evidence: total production of the product = SUM(units in stock, units on order); order no. refers to OrderID;
SQL: SELECT T1.UnitsInStock + T1.UnitsOnOrder FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T2.OrderID = 10248 ORDER BY T2.Quantity DESC LIMIT 1

Database: book_publishing_company
Question: Name all employees who were hired before year 1990.
Evidence: hired before year 1990 refers to YEAR(hire_date)<1990
SQL: SELECT fname, lname FROM employee WHERE STRFTIME('%Y', hire_date) < '1990'

Database: world
Question: List the district name of the city with the smallest population.
Evidence: smallest population refers to MIN(Population);
SQL: SELECT District FROM City ORDER BY Population LIMIT 1

Database: olympics
Question: How many Olympics games were held during the 90s?
Evidence: games refer to id; during the 90s refers to games_year BETWEEN 1990 AND 1999;
SQL: SELECT COUNT(games_year) FROM games WHERE games_year BETWEEN '1990' AND '1999'

Database: public_review_platform
Question: List down the category of businesses whose stars ratings are 5.
Evidence: category of businesses refers to category_name; stars ratings are 5 refers to stars = 5
SQL: SELECT DISTINCT T3.category_name 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 T1.stars = 5

Database: public_review_platform
Question: List by their id all businesses that are open on Sunday.
Evidence: day_of_week = 'Sunday'; open on Sunday refers to day_id = 1
SQL: SELECT T1.business_id FROM Business_Hours AS T1 INNER JOIN Days AS T2 ON T1.day_id = T2.day_id WHERE T1.day_id = 1

Database: video_games
Question: Provide the genre name of the genre ID 3.
Evidence: genre ID 3 refers to genre.id = 3
SQL: SELECT T.genre_name FROM genre AS T WHERE T.id = 3

Database: student_loan
Question: How many unemployed disabled students have been absent for 8 months from school?
Evidence: absent for 8 months refers to month = 8;
SQL: SELECT COUNT(T1.name) FROM longest_absense_from_school AS T1 INNER JOIN unemployed AS T2 ON T1.name = T2.name INNER JOIN disabled AS T3 ON T2.name = T3.name WHERE T1.month = 8

Database: world
Question: How many unofficial languages are used in Italy?
Evidence: unofficial languages refers to IsOfficial = 'F'; Italy is a name of country;
SQL: SELECT SUM(CASE WHEN T2.IsOfficial = 'F' THEN 1 ELSE 0 END) FROM Country AS T1 INNER JOIN CountryLanguage AS T2 ON T1.Code = T2.CountryCode WHERE T1.Name = 'Italy'

Database: law_episode
Question: What are the names of the person that were not credited at the end of episode tt0629391?
Evidence: not credited refers to credited = ''; episode tt0629391 refers to episode_id = 'tt0629391'
SQL: SELECT T2.name FROM Credit AS T1 INNER JOIN Person AS T2 ON T2.person_id = T1.person_id WHERE T1.credited = 'false' AND T1.episode_id = 'tt0629391'

Database: authors
Question: List all of the papers written by the author "Karin Rengefors."
Evidence: all the papers refers to Title; Karin Rengefors is the Name of the author
SQL: SELECT T2.Title FROM PaperAuthor AS T1 INNER JOIN Paper AS T2 ON T1.PaperId = T2.Id WHERE T1.Name = 'Karin Rengefors'

Database: retail_complains
Question: How many cases of billing dispute issues occurred in the Mountain division?
Evidence: billing dispute refers to issue = 'Billing disputes';
SQL: SELECT COUNT(T1.Issue) FROM events AS T1 INNER JOIN client AS T2 ON T1.Client_ID = T2.client_id INNER JOIN district AS T3 ON T2.district_id = T3.district_id WHERE T1.Issue = 'Billing disputes' AND T3.division = 'Mountain'

Database: authors
Question: Write down homepage URL of journal for paper "364: Induction of Mixed Chimerism and Transplantation Tolerance in a Non-Human Primate Lung Allograft Model: Early Results".
Evidence: paper "364: Induction of Mixed Chimerism and Transplantation Tolerance in a Non-Human Primate Lung Allograft Model: Early Results" refers to Title = '364: Induction of Mixed Chimerism and Transplantation Tolerance in a Non-Human Primate Lung Allograft Model: Early Results'
SQL: SELECT T2.HomePage FROM Paper AS T1 INNER JOIN Journal AS T2 ON T1.JournalId = T2.Id WHERE T1.Title = '364: Induction of Mixed Chimerism and Transplantation Tolerance in a Non-Human Primate Lung Allograft Model: Early Results'

Database: talkingdata
Question: How many male users have the log of events at the same longitude of 114?
Evidence: male refers to gender = 'M';
SQL: SELECT COUNT(T1.device_id) FROM gender_age AS T1 INNER JOIN events_relevant AS T2 ON T1.device_id = T2.device_id WHERE T2.longitude = 114 AND T1.gender = 'M'

Database: european_football_1
Question: From the Spanish LaLiga division in the 2017 season, which team won the most times as a local team and by what percentage?
Evidence: local team refers to HomeTeam; Spanish means belong to the country = 'Spain'; LaLiga is a name of division; won as a local team refers to FTR = 'H', where H stands for home victory; DIVIDE(COUNT(Div where name = 'LaLiga', country = 'Spain', season = 2017, FRT = 'H'), COUNT(Div where name = 'LaLiga', country = 'Spain', season = 2017)) as percentage;
SQL: SELECT T1.HomeTeam HWHT , CAST(COUNT(CASE WHEN T1.FTR = 'H' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(HomeTeam) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'LaLiga' AND T2.country = 'Spain' AND T1.season = 2017