Database: chicago_crime
Question: Name the neighborhood of the community area in crime with report number 23843?
Evidence: neighborhood refers to neighborhood_name; '23778' is the report_no
SQL: SELECT T3.neighborhood_name FROM Community_Area AS T1 INNER JOIN Crime AS T2 ON T1.community_area_no = T2.community_area_no INNER JOIN Neighborhood AS T3 ON T2.community_area_no = T3.community_area_no WHERE T2.report_no = 23778

Database: codebase_comments
Question: Please provide the number of forks that the repository of the solution 35 have.
Evidence: solution refers to Solution.Id; Solution.Id = 35;
SQL: SELECT T1.Forks FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T2.Id = 35

Database: public_review_platform
Question: Which city is the business that got a "medium" length tip with "3" likes located in?
Evidence: medium length tip refers to tip_length = 'Medium';
SQL: SELECT T1.city FROM Business AS T1 INNER JOIN Tips AS T2 ON T1.business_id = T2.business_id WHERE T2.tip_length = 'Medium' AND T2.likes = 3

Database: retails
Question: Among the customers from Morocco, how many customers were in debt?
Evidence: customers refer to c_custkey; Morocco is the name of the nation which refers to n_name = 'MOROCCO'; in debt refers to c_acctbal < 0;
SQL: SELECT COUNT(T1.c_custkey) FROM customer AS T1 INNER JOIN nation AS T2 ON T1.c_nationkey = T2.n_nationkey WHERE T1.c_acctbal < 0 AND T2.n_name = 'MOROCCO'

Database: public_review_platform
Question: For the user who joined Yelp in "2010", with an average of "4.5" stars review and has got uber number of fans, how many "funny" compliments has he/she received from other users?
Evidence: in "2010" refers to user_yelping_since_year = '2010'; average of "4.5" stars review refers to user_average_stars = '4.5'; uber number of fans refers to user_average_stars = '4.5'; "funny" compliments refers to compliment_type = 'funny'
SQL: SELECT COUNT(T2.user_id) FROM Users AS T1 INNER JOIN Users_Compliments AS T2 ON T1.user_id = T2.user_id INNER JOIN Compliments AS T3 ON T2.compliment_id = T3.compliment_id WHERE T1.user_yelping_since_year = 2010 AND T1.user_average_stars = 4.5 AND T1.user_fans = 'Uber' AND T3.compliment_type = 'funny'

Database: professional_basketball
Question: What is the full name of the team that has the most players from UCLA?
Evidence: "UCLA" is the college; team with most players refers to tmID where Max(Count(playerID))
SQL: SELECT T3.name FROM players AS T1 INNER JOIN players_teams AS T2 ON T1.playerID = T2.playerID INNER JOIN teams AS T3 ON T3.tmID = T2.tmID WHERE T1.college = 'UCLA' GROUP BY T3.name ORDER BY COUNT(DISTINCT T1.playerID) DESC LIMIT 1

Database: chicago_crime
Question: Describe the specific description and case locations under IUCR 142.
Evidence: specific description refers to secondary_description; location refers to latitude, longitude; IUCR 142 refers to iucr_no = 142
SQL: SELECT T1.secondary_description, T2.latitude, T2.longitude FROM IUCR AS T1 INNER JOIN Crime AS T2 ON T1.iucr_no = T2.iucr_no WHERE T2.iucr_no = 142

Database: chicago_crime
Question: What is the average number of less severe crimes reported a day in February of 2018?
Evidence: day in February of 2018 refers to date LIKE '2/%/2018'; less severe crime refers to index_code = 'N'; average = Divide (Count(case_number), 28)
SQL: SELECT CAST(COUNT(T2.case_number) AS REAL) / 28 FROM IUCR AS T1 INNER JOIN Crime AS T2 ON T2.iucr_no = T1.iucr_no WHERE T2.date LIKE '2/%/2018%' AND T1.index_code = 'N'

Database: retail_complains
Question: List the full names of all clients who live in the Pacific division.
Evidence: full name refers to first, last
SQL: SELECT T2.first, T2.middle, T2.last FROM district AS T1 INNER JOIN client AS T2 ON T1.district_id = T2.district_id WHERE T1.division = 'Pacific'

Database: codebase_comments
Question: What is the url of solution 1?
Evidence: solution refers to Solution.Id; Solution.Id = 1;
SQL: SELECT T1.Url FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T2.Id = 1

Database: world
Question: What is the local name of Ukraine that they are also known for?
Evidence: Ukraine is a name of country;
SQL: SELECT LocalName FROM Country WHERE Name = 'Ukraine'

Database: soccer_2016
Question: How many overs were there in the first innings of match ID "335996"?
Evidence: the first innings refers to Innings_No = 1; match ID "335996" refers to Match_Id = 335996
SQL: SELECT COUNT(Over_Id) FROM Ball_by_Ball WHERE Match_Id = 335996 AND Innings_No = 1

Database: beer_factory
Question: Which brand has the lowest star rating with a "Too spicy!" review?
Evidence: lowest star rating refers to MIN(StarRating); "Too spicy!" review refers to Review = 'Too Spicy!';
SQL: SELECT T1.BrandName FROM rootbeerbrand AS T1 INNER JOIN rootbeerreview AS T2 ON T2.BrandID = T1.BrandID WHERE T2.StarRating = 1 AND T2.Review = 'Too Spicy!'

Database: authors
Question: Indicate the number of authors affiliated with the organization named 'Arizona State University'.
Evidence: 'Arizona State University' is an affiliation
SQL: SELECT COUNT(Name) FROM Author WHERE Affiliation = 'Arizona State University'

Database: legislator
Question: What is the first name of the legislator whose address at 1005 Longworth HOB; Washington DC 20515-1408?
SQL: SELECT T1.first_name FROM current AS T1 INNER JOIN `current-terms` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.address = '1005 Longworth HOB Washington DC 20515-1408' GROUP BY T1.first_name

Database: chicago_crime
Question: How many crimes were committed at 018XX S KOMENSKY AVEin May 2018?
Evidence:  in May 2018 refers to date LIKE '5/%/2018%'
SQL: SELECT SUM(CASE WHEN date LIKE '5/%/2018%' THEN 1 ELSE 0 END) FROM Crime WHERE block = '018XX S KOMENSKY AVE'

Database: car_retails
Question: Who is the sales representitive of Muscle Machine Inc? Please give the employee's full name.
Evidence: Sales representative refers to jobTitle = 'Sales Rep'; Muscle Machine Inc is name of customer;
SQL: SELECT t2.firstName, t2.lastName FROM customers AS t1 INNER JOIN employees AS t2 ON t1.salesRepEmployeeNumber = t2.employeeNumber WHERE t1.customerName = 'Muscle Machine Inc'

Database: ice_hockey_draft
Question: What team did Niklas Eckerblom play in the 1997-1998 season?
Evidence: 1997-1998 season refers to SEASON = '1997-1998';
SQL: SELECT T2.TEAM FROM PlayerInfo AS T1 INNER JOIN SeasonStatus AS T2 ON T1.ELITEID = T2.ELITEID WHERE T2.SEASON = '1997-1998' AND T1.PlayerName = 'Niko Kapanen'

Database: image_and_language
Question: How many attribute classes are there for image id 5?
Evidence: attribute classes refer to ATT_CLASS_ID; image id 5 refers to IMG_ID = 5;
SQL: SELECT COUNT(ATT_CLASS_ID) FROM IMG_OBJ_ATT WHERE IMG_ID = 5

Database: video_games
Question: How many action games are there in total?
Evidence: action game refers to genre_name = 'Action'
SQL: SELECT COUNT(T1.id) FROM game AS T1 INNER JOIN genre AS T2 ON T1.genre_id = T2.id WHERE T2.genre_name = 'Action'

Database: video_games
Question: What is the least common game genre?
Evidence: the least common game genre refers to min(count(genre_id)); genre refers to genre_name
SQL: SELECT T.game_name FROM ( SELECT T2.game_name, COUNT(T2.id) FROM genre AS T1 INNER JOIN game AS T2 ON T1.id = T2.genre_id GROUP BY T2.game_name ORDER BY COUNT(T2.id) ASC LIMIT 1 ) t

Database: world_development_indicators
Question: What is the series code for Germany and what is its description?
Evidence: Germany refers to shortname = 'Germany'
SQL: SELECT T1.Seriescode, T1.Description FROM CountryNotes AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.CountryCode WHERE T2.ShortName = 'Germany'