Database: codebase_comments
Question: Please list all the paths of the solutions containing files within the repository whose url is "https://github.com/maxild/playground.git".
SQL: SELECT T2.Path FROM Repo AS T1 INNER JOIN Solution AS T2 ON T1.Id = T2.RepoId WHERE T1.Url = 'https://github.com/maxild/playground.git'

Database: movies_4
Question: What is the average number of horror movies among all movies genre?
Evidence: horror movies refers to genre_name = 'horror'; average number = divide(sum(movie_id) when genre_name = 'horror', count(movie_id))
SQL: SELECT CAST(COUNT(CASE WHEN T3.genre_name = 'Horror' THEN T1.movie_id ELSE NULL END) AS REAL) / COUNT(T1.movie_id) FROM movie AS T1 INNER JOIN movie_genres AS T2 ON T1.movie_id = T2.movie_id INNER JOIN genre AS T3 ON T2.genre_id = T3.genre_id

Database: public_review_platform
Question: Among the businesses with a category of Local Services, what is the percentage of the business with less than 3 stars?
Evidence: "Local Services" is the category_name; less than 3 stars refers to stars < 3; percentage = Divide(Count(business_id(stars < 3)), Count(business_id)) * 100
SQL: SELECT CAST(SUM(CASE WHEN T1.stars < 3 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.stars) AS "percentage" FROM Business AS T1 INNER JOIN Business_Categories ON T1.business_id = Business_Categories.business_id INNER JOIN Categories AS T3 ON Business_Categories.category_id = T3.category_id WHERE T3.category_name LIKE 'Local Services'

Database: regional_sales
Question: Name the most expensive ordered? Who, when was it ordered?
Evidence: the most expensive refers to MAX(Unit Cost); who refers to Customer Names; when refers to OrderDate;
SQL: SELECT T2.OrderNumber, T1.`Customer Names`, T2.OrderDate FROM Customers AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._CustomerID = T1.CustomerID INNER JOIN Products AS T3 ON T3.ProductID = T2._ProductID ORDER BY T2.`Unit Cost` DESC LIMIT 1

Database: airline
Question: List the flight date of flights with air carrier described as Profit Airlines Inc.: XBH which have an actual elapsed time below 100.
Evidence: flight date refers to FL_DATE; Profit Airlines Inc.: XBH refers to Description = 'Profit Airlines Inc.: XBH'; actual elapsed time below 100 refers to ACTUAL_ELAPSED_TIME < 100;
SQL: SELECT T2.FL_DATE FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID WHERE T2.ACTUAL_ELAPSED_TIME < 100 AND T1.Description = 'Profit Airlines Inc.: XBH'

Database: retails
Question: How many orders were shipped in 1994?
Evidence: orders shipped in 1994 refer to l_orderkey where year(l_shipdate) = 1994;
SQL: SELECT COUNT(l_orderkey) FROM lineitem WHERE STRFTIME('%Y', l_shipdate) = '1994'

Database: cs_semester
Question: Among students registered for the most difficult course, list the students' full names who got grade A.
Evidence: difficulty refers to diff; most difficult course refers to MAX(diff); student's full names = f_name, 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 T2.grade = 'A' ORDER BY T3.diff DESC LIMIT 1

Database: movies_4
Question: Which genre does the movie Dancer in the Dark belong to?
Evidence: genre refers to genre_name; movie Dancer in the Dark refers to title = 'Dancer in the Dark'
SQL: SELECT T3.genre_name FROM movie AS T1 INNER JOIN movie_genres AS T2 ON T1.movie_id = T2.movie_id INNER JOIN genre AS T3 ON T2.genre_id = T3.genre_id WHERE T1.title = 'Dancer in the Dark'

Database: music_platform_2
Question: What dates were the Don't Lie To Your Life Coach podcast reviews created?
Evidence: "Don't Lie To Your Life Coach" refers to title of podcast; date refers to created_at
SQL: SELECT created_at FROM reviews WHERE podcast_id = ( SELECT podcast_id FROM podcasts WHERE title = 'Don''t Lie To Your Life Coach' )

Database: video_games
Question: Which year has the most number of video game releases?
Evidence: year that has the most number of video game releases refers to MAX(COUNT(release_year));
SQL: SELECT T1.release_year FROM ( SELECT T.release_year, COUNT(id) FROM game_platform AS T GROUP BY T.release_year ORDER BY COUNT(T.id) DESC LIMIT 1 ) T1

Database: donor
Question: How many schools in Suffolk County have Ph.D. teachers?
Evidence: Suffolk County refers to School_county = 'Suffolk'; Ph.D. teachers refers to Teacher_prefix = 'Dr.'
SQL: SELECT COUNT(schoolid) FROM projects WHERE teacher_prefix = 'Dr.' AND school_county = 'Suffolk'

Database: sales_in_weather
Question: Show the sea level status recorded by the weather station of store no.19 on 2013/2/24.
Evidence: store no.19 refers to store_nbr = 19; on 2013/2/24 refers to date = '2013-02-24'; sea level status refers to sealevel
SQL: SELECT T1.sealevel FROM weather AS T1 INNER JOIN relation AS T2 ON T1.station_nbr = T2.station_nbr WHERE T1.`date` = '2013-02-24' AND T2.store_nbr = 19

Database: food_inspection
Question: What is the owner's name of the of the business that violates 103156 on June 12, 2014?
Evidence: business that violates 103156 on June 12, 2014 refers to business_id where violation_type_id = 103156 and date = '2014-06-12';
SQL: SELECT DISTINCT T2.owner_name FROM violations AS T1 INNER JOIN businesses AS T2 ON T1.business_id = T2.business_id WHERE T1.violation_type_id = 103156 AND T1.`date` = '2014-06-12'

Database: world
Question: List down all cities of China.
Evidence: China is a name of country;
SQL: SELECT T1.Name FROM City AS T1 INNER JOIN Country AS T2 ON T1.CountryCode = T2.Code WHERE T2.Name = 'China'

Database: sales
Question: Among the products, how many of them are freebies?
Evidence: freebies refers to Price = 0;
SQL: SELECT COUNT(ProductID) FROM Products WHERE Price = 0

Database: donor
Question: What is the teacher's account ID for the project that got the donation at 11:38:43 on 2008/7/29 ?
Evidence: donation at 11:38:43 on 2008/7/29 refers to donation_timestamp = '2008/7/29 11:38:43'; teacher's account ID refers to teacher_acctid;
SQL: SELECT T1.teacher_acctid FROM essays AS T1 INNER JOIN donations AS T2 ON T1.projectid = T2.projectid WHERE T2.donation_timestamp LIKE '2008-07-29 11:38:43.361'

Database: shakespeare
Question: Please list the IDs of the paragraphs in which the character "son to Tamora" appears.
Evidence: character "son to Tamora"  refers to characters.Description = 'son to Tamora'
SQL: SELECT T1.id FROM paragraphs AS T1 INNER JOIN characters AS T2 ON T1.character_id = T2.id WHERE T2.Description = 'son to Tamora'

Database: airline
Question: Among all the flights scheduled to depart from John F. Kennedy International on 2018/8/1, when was the earliest one scheduled to depart?
Evidence: depart from refers to ORIGIN; John F. Kennedy International refers to Description = 'New York, NY: John F. Kennedy International'; on 2018/8/1 refers to FL_DATE = '2018/8/1'; earliest one scheduled to depart refers to MIN(DEP_TIME);
SQL: SELECT T2.DEP_TIME FROM Airports AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.ORIGIN WHERE T2.FL_DATE = '2018/8/1' AND T1.Description = 'New York, NY: John F. Kennedy International' AND T2.DEP_TIME IS NOT NULL ORDER BY T2.DEP_TIME ASC LIMIT 1

Database: codebase_comments
Question: How many followers do the most followed repository on Github have? Give the github address of the repository.
Evidence: more forks refers to more people follow this repository; most followed repository refers to max(Forks);  the github address of the repository refers to Url;
SQL: SELECT Forks, Url FROM Repo WHERE Forks = ( SELECT MAX(Forks) FROM Repo )