Database: video_games
Question: List the games from the publisher "Activision".
Evidence: games refers to game_name; "Activision" refers to publisher_name = 'Activision';
SQL: SELECT T3.game_name FROM publisher AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.publisher_id INNER JOIN game AS T3 ON T2.game_id = T3.id WHERE T1.publisher_name = 'Activision'

Database: airline
Question: Among the flights of the air carrier described as American Airlines, what is the percentage of the flights with earlier departure?
Evidence: American Airlines can be found in Description which contains 'American Airlines'; percentage = MULTIPLY(DIVIDE(SUM(DEP_DELAY < 0), COUNT(DEP_DELAY)), 1.0); earlier departure refers to DEP_DELAY < 0;
SQL: SELECT CAST(SUM(CASE WHEN T2.DEP_DELAY < 0 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM `Air Carriers` AS T1 INNER JOIN Airlines AS T2 ON T1.Code = T2.OP_CARRIER_AIRLINE_ID WHERE T1.Description LIKE '%American Airlines%'

Database: retail_complains
Question: Please list the emails of the clients whose complaint date received is 7/3/2014.
Evidence: 7/3/2014 refers to Date received = '2014-07-03'
SQL: SELECT T1.email FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.`Date received` = '2014-07-03'

Database: retail_complains
Question: Calculate the percentage of complaints made by Google account client in server ZOHARI.
Evidence: Google account refers to email like '%@gmail.com'; percentage = divide(count(Complaint ID where email like '%@gmail.com') , count(Complaint ID)) * 100%
SQL: SELECT CAST(SUM(CASE WHEN T1.email LIKE '%@gmail.com' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.email) FROM client AS T1 INNER JOIN callcenterlogs AS T2 ON T1.client_id = T2.`rand client` WHERE T2.server = 'ZOHARI'

Database: legislator
Question: List the official full names of all the legislators who have facebook, instagram, twitter and youtube accounts.
Evidence: have facebook, instagram, twitter and youtube accounts refers to 'facebook' is not null AND 'instagram' is not null AND 'twitter' is not null AND 'youtube' is not null;
SQL: SELECT T1.official_full_name FROM current AS T1 INNER JOIN `social-media` AS T2 ON T1.bioguide_id = T2.bioguide WHERE T2.facebook IS NOT NULL AND T2.instagram IS NOT NULL AND T2.twitter IS NOT NULL AND T2.youtube IS NOT NULL

Database: address
Question: What is the bad alias of the residential area with the highest average house value?
Evidence: highest average house value refers to Max(avg_house_value)
SQL: SELECT T2.bad_alias FROM zip_data AS T1 INNER JOIN avoid AS T2 ON T1.zip_code = T2.zip_code WHERE T1.avg_house_value = ( SELECT MAX(avg_house_value) FROM zip_data ) LIMIT 1

Database: disney
Question: Calculate the percentage of voice actors whose main character in the movie is in the Drama genre.
Evidence: DIVIDE(COUNT(voice-actor where genre = 'Drama'), COUNT(voice-actor)) as percentage;
SQL: SELECT CAST(COUNT(CASE WHEN T1.genre = 'Drama' THEN T3.`voice-actor` ELSE NULL END) AS REAL) * 100 / COUNT(T3.`voice-actor`) FROM movies_total_gross AS T1 INNER JOIN characters AS T2 ON T1.movie_title = T2.movie_title INNER JOIN `voice-actors` AS T3 ON T3.movie = T1.movie_title

Database: superstore
Question: List down the customers that purchased the product named Xerox 23 in the South region.
Evidence: product named Xerox 23 refers to "Product Name" = 'Xerox 23'; customers refers to "Customer Name"
SQL: SELECT DISTINCT T2.`Customer Name` FROM south_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 T1.Region = 'South' AND T3.`Product Name` = 'Xerox 23'

Database: citeseer
Question: List all words cited in the AI class label.
SQL: SELECT DISTINCT T2.word_cited_id FROM paper AS T1 INNER JOIN content AS T2 ON T1.paper_id = T2.paper_id WHERE T1.class_label = 'AI'

Database: language_corpus
Question: How many Wikipedia pages on Catalan are there with the word "nombre" appearing for more than 5 times?
Evidence: nombre refers to word = 'nombre'; appear for more than 5 times refers to  pages_words.occurrences > 5
SQL: SELECT COUNT(T2.pid) FROM words AS T1 INNER JOIN pages_words AS T2 ON T1.wid = T2.wid WHERE T1.word = 'nombre' AND T2.occurrences > 5

Database: disney
Question: Which song is associated with the most popular Disney movie in 1970s?
Evidence: the most popular movie refers to movie_title where MAX(total_gross); in 1970s refers to (cast(SUBSTR(release_date, instr(release_date, ', ') + 1) as int) between 1970 and 1979);
SQL: SELECT T2.song FROM movies_total_gross AS T1 INNER JOIN characters AS T2 ON T1.movie_title = T2.movie_title WHERE CAST(SUBSTR(T1.release_date, INSTR(T1.release_date, ', ') + 1) AS int) BETWEEN 1970 AND 1979 ORDER BY CAST(REPLACE(SUBSTR(T1.total_gross, 2), ',', '') AS float) DESC LIMIT 1

Database: chicago_crime
Question: Which commander has had to deal with more cases of criminal sexual abuse?
Evidence: more cases of criminal sexual abuse refers to Max(Count(secondary_description = 'CRIMINAL SEXUAL ABUSE'))
SQL: SELECT T3.commander FROM IUCR AS T1 INNER JOIN Crime AS T2 ON T2.iucr_no = T1.iucr_no INNER JOIN District AS T3 ON T3.district_no = T2.district_no WHERE T1.secondary_description = 'CRIMINAL SEXUAL ABUSE' GROUP BY T3.commander ORDER BY COUNT(T1.secondary_description) DESC LIMIT 1

Database: public_review_platform
Question: Among the working days from Monday to Saturday, which businesses with the category names work the most days?
Evidence: days from Monday to Saturday refer to day_id between 2 and 7; work the most days can be computed as MAX(COUNT(category_name where day_id between 2 and 7));
SQL: SELECT T2.category_name FROM Business_Categories AS T1 INNER JOIN Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Business_Hours AS T3 ON T1.business_id = T3.business_id INNER JOIN Days AS T4 ON T3.day_id = T4.day_id GROUP BY T2.category_name ORDER BY COUNT(T3.day_id) DESC LIMIT 1

Database: video_games
Question: What are the names of the publishers who published the oldest games?
Evidence: name of publisher refers to publisher_name; the oldest game refers to min(release_year)
SQL: SELECT DISTINCT T3.publisher_name FROM game_platform AS T1 INNER JOIN game_publisher AS T2 ON T1.game_publisher_id = T2.id INNER JOIN publisher AS T3 ON T2.publisher_id = T3.id ORDER BY T1.release_year LIMIT 1

Database: video_games
Question: What is the genre of the game '2 Games in 1: Sonic Advance & ChuChu Rocket!'?
Evidence: genre refers to genre_name; '2 Games in 1: Sonic Advance & ChuChu Rocket!' is a game name;
SQL: SELECT T2.genre_name FROM game AS T1 INNER JOIN genre AS T2 ON T1.genre_id = T2.id WHERE T1.game_name = '2 Games in 1: Sonic Advance & ChuChu Rocket!'

Database: movie_platform
Question: When was the movie Cops released?
Evidence: Cops' is movie_title; released refers to movie_release_year;
SQL: SELECT movie_release_year FROM movies WHERE movie_title = 'Cops'

Database: video_games
Question: Calculate the total number of IDs for the game published by Capcom and Sony Computer Entertainment.
Evidence: Capcom refers to publisher_name = 'Capcom';  Sony Computer Entertainment refers to publisher_name = 'Sony Computer Entertainment';
SQL: SELECT COUNT(DISTINCT T1.game_id) FROM game_publisher AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.id WHERE T2.publisher_name IN ('Capcom', 'Sony Computer Entertainment')

Database: retail_world
Question: Provide the supplier company name in Sydney and its homepage address if available.
Evidence: in Sydney refers to City = 'Sydney';
SQL: SELECT CompanyName, HomePage FROM Suppliers WHERE City = 'Sydney'