Database: language_corpus
Question: Please list the page IDs of all the Wikipedia pages that have the word "nombre" appeared on it.
Evidence: nombre refers to word = 'nombre'; page IDs refers to pid
SQL: SELECT T2.pid FROM words AS T1 INNER JOIN pages_words AS T2 ON T1.wid = T2.wid WHERE T1.word = 'nombre'

Database: retails
Question: Which country does supplier No.34 come from?
Evidence: supplier No.34 refers to s_suppkey = 34; country refers to n_name;
SQL: SELECT T2.n_name FROM supplier AS T1 INNER JOIN nation AS T2 ON T1.s_nationkey = T2.n_nationkey WHERE T1.s_suppkey = 34

Database: synthea
Question: How many Black patients were immunized with DTaP in 2013?
Evidence: Black patients refer to patient where race = 'black'; immunized with DTaP refers to DESCRIPTION = 'DTaP' from immunizations; in 2013 refers to DATE like '2013%';
SQL: SELECT COUNT(DISTINCT T1.patient) FROM patients AS T1 INNER JOIN immunizations AS T2 ON T1.patient = T2.PATIENT WHERE T1.race = 'black' AND T2.DESCRIPTION = 'DTaP' AND strftime('%Y', T2.DATE) = '2013'

Database: ice_hockey_draft
Question: List the names of all players in team Avangard Omsk in season 2000-2001.
Evidence: names of the players refers to PlayerName; team Avangard Omsk refers to TEAM = 'Avangard Omsk'; 2000-2001 season refers to SEASON = '2000-2001';
SQL: SELECT DISTINCT T2.PlayerName FROM SeasonStatus AS T1 INNER JOIN PlayerInfo AS T2 ON T1.ELITEID = T2.ELITEID WHERE T1.SEASON = '2000-2001' AND T1.TEAM = 'Avangard Omsk'

Database: retail_world
Question: Indicate the name of the companies that have freighted products for a value greater than 2,000,000.
Evidence: freighted products for a value greater than 2,000,000 refer to Freight > 2000000; name of companies refers to CompanyName;
SQL: SELECT T1.CompanyName FROM Customers AS T1 INNER JOIN Orders AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.Freight > 2000000

Database: talkingdata
Question: What is the category of the label that represented the behavior category of app id 5902120154267990000?
Evidence: label that represented the behavior category refers to label_id;
SQL: SELECT T1.category FROM label_categories AS T1 INNER JOIN app_labels AS T2 ON T1.label_id = T2.label_id WHERE T2.app_id = 5902120154267990000

Database: image_and_language
Question: How many images have objects with the attributes of polka dot?
Evidence: attributes of polka dot refer to ATT_CLASS = 'polka dot'; images refer to IMG_ID;
SQL: SELECT COUNT(T2.OBJ_SAMPLE_ID) FROM ATT_CLASSES AS T1 INNER JOIN IMG_OBJ_ATT AS T2 ON T1.ATT_CLASS_ID = T2.ATT_CLASS_ID WHERE T1.ATT_CLASS = 'polka dot'

Database: video_games
Question: How many more sports games than simulation games?
Evidence: sports game refers to genre_name = 'Sports'; simulation game refers to genre_name = 'Simulation'; how many more = subtract(sum(game_id where genre_name = 'Sports'), sum(game_id where genre_name = 'Simulation'))
SQL: SELECT COUNT(CASE WHEN T1.genre_name = 'Sports' THEN T2.id ELSE NULL END) - COUNT(CASE WHEN T1.genre_name = 'Simulation' THEN T2.id ELSE NULL END) FROM genre AS T1 INNER JOIN game AS T2 ON T1.id = T2.genre_id

Database: talkingdata
Question: Please list the models of all the devices with an event under the location coordinates (121, 31).
Evidence: models of the devices refers to device_model; location coordinates (121, 31) refers to longitude = 121 AND latitude = 31;
SQL: SELECT T2.device_model FROM events AS T1 INNER JOIN phone_brand_device_model2 AS T2 ON T1.device_id = T2.device_id WHERE T1.longitude = 121 AND T1.latitude = 31

Database: disney
Question: Describe the hero, director, and the release date of Mulan.
Evidence: Mulan refers to movie_title = 'Mulan';
SQL: SELECT T1.hero, T2.director, T1.release_date FROM characters AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name WHERE T1.movie_title = 'Mulan'

Database: shakespeare
Question: How many comedies did Shakespeare create?
Evidence: comedies refers to GenreType = 'Comedy'
SQL: SELECT COUNT(id) FROM works WHERE GenreType = 'Comedy'

Database: shipping
Question: What is the average number of shipments done by the Kenworth trucks?
Evidence: "Kenworth" is the make of truck; average = Divide (Count(ship_id where make = 'Kenworth'), Count(truck_id where make = 'Kenworth))
SQL: SELECT CAST(COUNT(T2.ship_id) AS REAL) / COUNT(DISTINCT T1.truck_id) FROM truck AS T1 INNER JOIN shipment AS T2 ON T1.truck_id = T2.truck_id WHERE T1.make = 'Kenworth'

Database: car_retails
Question: Please list the name and phone number of the customer whose order was cancelled.
Evidence: cancelled order refers to status = 'Cancelled';
SQL: SELECT T2.customerName, T2.phone FROM orders AS T1 INNER JOIN customers AS T2 ON T1.customerNumber = T2.customerNumber WHERE T1.status = 'Cancelled'

Database: retail_complains
Question: What was the review context from Jacksonville on 2017/7/22?
Evidence: Jacksonville refers to city = 'Jacksonville'; on 2017/7/22 refers to Date = '2017-07-22';
SQL: SELECT T1.Reviews FROM reviews AS T1 INNER JOIN district AS T2 ON T1.district_id = T2.district_id WHERE T2.city = 'Jacksonville' AND T1.Date = '2017-07-22'

Database: books
Question: How many books were published by Brava in 2006?
Evidence: "Brava" is the publisher_name; in 2006 refers to SUBSTR(publication_date, 1, 4) = '2006'
SQL: SELECT COUNT(*) FROM book AS T1 INNER JOIN publisher AS T2 ON T1.publisher_id = T2.publisher_id WHERE T2.publisher_name = 'Brava' AND STRFTIME('%Y', T1.publication_date) = '2006'

Database: authors
Question: What is the short name for the journal that published the paper "A Case of Unilateral Ashy Dermatosis"?
Evidence: A Case of Unilateral Ashy Dermatosis refer to Title
SQL: SELECT T2.ShortName FROM Paper AS T1 INNER JOIN Journal AS T2 ON T1.JournalId = T2.Id WHERE T1.Title = 'A Case of Unilateral Ashy Dermatosis'

Database: books
Question: List the title of the books purchased by the customer named Zia Roizin.
SQL: SELECT T1.title FROM book AS T1 INNER JOIN order_line AS T2 ON T1.book_id = T2.book_id INNER JOIN cust_order AS T3 ON T3.order_id = T2.order_id INNER JOIN customer AS T4 ON T4.customer_id = T3.customer_id WHERE T4.first_name = 'Zia' AND T4.last_name = 'Roizin'

Database: music_platform_2
Question: List all reviews created in May 2019. State the title of podcast and review rating.
Evidence: created in May 2019 refers to created_at like '2019-05%'
SQL: SELECT DISTINCT T1.title, T2.rating FROM podcasts AS T1 INNER JOIN reviews AS T2 ON T2.podcast_id = T1.podcast_id WHERE T2.created_at LIKE '2019-05-%'

Database: public_review_platform
Question: Does the length of the tip influence the number of likes for hotel and travel business category?
Evidence: the longer the tip_length, the lesser the likes OR the longer the tip length the higher the likes; hotel and travel business category refers to category_name = 'Hotels & Travel';
SQL: SELECT T3.tip_length, SUM(T3.likes) AS likes FROM Categories AS T1 INNER JOIN Business_Categories AS T2 ON T1.category_id = T2.category_id INNER JOIN Tips AS T3 ON T2.business_id = T3.business_id WHERE T1.category_name = 'Hotels & Travel' GROUP BY T3.tip_length

Database: beer_factory
Question: How many transactions have been made to purchase a root beer brand from California?
Evidence: California refers to State = 'CA';
SQL: SELECT COUNT(T3.RootBeerID) FROM rootbeerbrand AS T1 INNER JOIN rootbeer AS T2 ON T1.BrandID = T2.BrandID INNER JOIN `transaction` AS T3 ON T2.RootBeerID = T3.RootBeerID WHERE T1.State = 'CA'