Database: synthea
Question: How many interactions did Lorri Simons have with medical professionals between 2010 and 2017? What percentage of encounters are attributed to prenatal visits?
Evidence: between 2010 and 2017 refers to substr(encounters.DATE, 1, 4) between '2010' and '2017'; percentage = MULTIPLY(DIVIDE(COUNT(encounters.ID WHERE DESCRIPTION = 'Prenatal visit'), count(encounters.ID)), 1.0); prenatal visits refers to encounters.DESCRIPTION = 'Prenatal visit';
SQL: SELECT COUNT(T1.patient) , CAST(SUM(CASE WHEN T2.DESCRIPTION = 'Prenatal visit' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.patient) FROM patients AS T1 INNER JOIN encounters AS T2 ON T1.patient = T2.PATIENT WHERE T1.first = 'Lorri' AND T1.last = 'Simonis' AND strftime('%Y', T2.DATE) BETWEEN '2010' AND '2017'

Database: cars
Question: Calculate the percentage of cars that belong to the USA.
Evidence: belong to the USA refers to country = 'USA'; percentage = divide(count(ID where country = 'USA'), count(ID)) * 100%
SQL: SELECT CAST(SUM(CASE WHEN T2.country = 'USA' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM production AS T1 INNER JOIN country AS T2 ON T1.country = T2.origin

Database: disney
Question: Which movies of director Wolfgang Reitherman do not have villain?
Evidence: which movies do not have villain refer to movie_title where villian is null;
SQL: SELECT T1.movie_title FROM characters AS T1 INNER JOIN director AS T2 ON T1.movie_title = T2.name WHERE T2.director = 'Wolfgang Reitherman' AND T1.villian IS NULL

Database: beer_factory
Question: How many transactions were paid through MasterCard in 2014?
Evidence: MasterCard refers to CreditCardType = 'MasterCard'; in 2014 refers to TransactionDate > = '2014-01-01' AND TransactionDate < = '2014-12-31';
SQL: SELECT COUNT(TransactionID) FROM `transaction` WHERE CreditCardType = 'MasterCard' AND TransactionDate LIKE '2014%'

Database: movielens
Question: How many separate 35 year-old uesers have rated the movie from UK?
Evidence: UK is a country
SQL: SELECT COUNT(DISTINCT T2.userid) FROM movies AS T1 INNER JOIN u2base AS T2 ON T1.movieid = T2.movieid INNER JOIN users AS T3 ON T2.userid = T3.userid WHERE T1.country = 'UK' AND T3.age = 35

Database: image_and_language
Question: How many images have "vegetable" and "fruits" as their object classes?
Evidence: images refer to IMG_ID; "vegetables" and "fruits" as object classes refer to OBJ_CLASS = 'vegetables' and OBJ_CLASS = 'fruits';
SQL: SELECT COUNT(T1.IMG_ID) FROM IMG_OBJ AS T1 INNER JOIN OBJ_CLASSES AS T2 ON T1.OBJ_CLASS_ID = T2.OBJ_CLASS_ID WHERE T2.OBJ_CLASS = 'vegetables' OR T2.OBJ_CLASS = 'fruits'

Database: retail_complains
Question: Please list any two clients with their full names who have been tagged as "Older American" by the company without seeking their permission.
Evidence: full names = first, middle, last; without seeking their permission refers to "Consumer consent provided?" in (null, 'N/A' or 'empty');
SQL: SELECT T1.first, T1.middle, T1.last FROM client AS T1 INNER JOIN events AS T2 ON T1.client_id = T2.Client_ID WHERE T2.Tags = 'Older American' AND T2.`Consumer consent provided?` IN (NULL, 'N/A', '') LIMIT 2

Database: language_corpus
Question: How many word that has number of different words equal to 3?
Evidence: This is not;
SQL: SELECT COUNT(T2.wid) FROM pages AS T1 INNER JOIN pages_words AS T2 ON T1.pid = T2.pid WHERE T1.words = 3

Database: authors
Question: Who are the co-authors for Jei Keon Chae and what is the title of paper written by them?
Evidence: 'Jei Keon Chee' is the name of author;
SQL: SELECT T2.AuthorId, T1.Title FROM Paper AS T1 INNER JOIN PaperAuthor AS T2 ON T1.Id = T2.PaperId WHERE T2.Name = 'Jei Keon Chae'

Database: world_development_indicators
Question: Mention the series code of countries using Australian dollar as their currency unit. Which country belongs to middle income group among them.
Evidence: middle income group refers to IncomeGroup = 'Low middle income';
SQL: SELECT T1.CountryCode, T2.SeriesCode FROM Country AS T1 INNER JOIN CountryNotes AS T2 ON T1.CountryCode = T2.Countrycode WHERE T1.CurrencyUnit = 'Australian dollar' AND T1.IncomeGroup = 'Lower middle income'

Database: retail_world
Question: How many kinds of products are supplied by "Karkki Oy" company?
Evidence: supplied by refers to CompanyName
SQL: SELECT COUNT(T1.ProductID) FROM Products AS T1 INNER JOIN Suppliers AS T2 ON T1.SupplierID = T2.SupplierID WHERE T2.CompanyName = 'Karkki Oy'

Database: retail_complains
Question: List down the issues for complaint with server time of below 10 minutes.
Evidence: server time of below 10 minutes refers to ser_time < '00:10:00'
SQL: SELECT T2.Issue FROM callcenterlogs AS T1 INNER JOIN events AS T2 ON T1.`Complaint ID` = T2.`Complaint ID` WHERE strftime('%M', T1.ser_time) < '10'

Database: superstore
Question: Provide the product's name of the product with the highest sales in the South region.
Evidence: highest sales refers to max(Sales)
SQL: SELECT T2.`Product Name` FROM south_superstore AS T1 INNER JOIN product AS T2 ON T1.`Product ID` = T2.`Product ID` WHERE T2.Region = 'South' ORDER BY T1.Sales DESC LIMIT 1

Database: bike_share_1
Question: On the day with the hottest temperature ever in 2014, how many bike trips started from the station 2nd at Folsom?
Evidence: hottest temperature refers to max_temperatutre_f; in 2014 refers to date LIKE '%2014'; started from station refers to start_station_name; start_station_name = '2nd at Folsom';
SQL: SELECT COUNT(T1.start_station_name) FROM trip AS T1 INNER JOIN weather AS T2 ON T2.zip_code = T1.zip_code WHERE T2.date LIKE '%2014%' AND T2.zip_code = 94107 AND T1.start_station_name = '2nd at Folsom' ORDER BY T2.max_temperature_f DESC LIMIT 1

Database: movie_platform
Question: Which of the films directed by Álex de la Iclesia is the most popular among Mubi users?
Evidence: Alex de la Iclesia is the director name; the most popular refers to Max(movie_popularity); films refers to movies;
SQL: SELECT movie_title FROM movies WHERE director_name = 'Åke Sandgren' ORDER BY movie_popularity DESC LIMIT 1

Database: movie_platform
Question: Please list the names of the movies that have been rated the most times in 2020.
Evidence: in 2020 refers to rating_timestamp_utc = '2020%'; rated the most times refers to Max(Count(movie_title));
SQL: SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_timestamp_utc LIKE '2020%' GROUP BY T2.movie_title ORDER BY COUNT(T2.movie_title) DESC LIMIT 1

Database: restaurant
Question: Give the review of the restaurant located in Ocean St., Santa Cruz.
Evidence: Ocean St. refers to street_name = 'ocean st'; Santa Cruz refers to city = 'santa cruz'
SQL: SELECT T2.review FROM location AS T1 INNER JOIN generalinfo AS T2 ON T1.id_restaurant = T2.id_restaurant WHERE T2.city = 'santa cruz' AND T1.street_name = 'ocean st'

Database: codebase_comments
Question: What is the language of the method ''PixieTests.SqlConnectionLayerTests.TestSqlCreateGuidColumn"?
Evidence: language refers to Lang；
SQL: SELECT Lang FROM Method WHERE Name = 'PixieTests.SqlConnectionLayerTests.TestSqlCreateGuidColumn'

Database: movie_3
Question: Where can you rent the movie 'Wyoming Storm'? Identify the address of the rental store and the rental rate.
Evidence: 'Wyoming Storm' refers to title = 'WYOMING STORM'
SQL: SELECT T2.store_id, T1.address, T4.rental_rate FROM address AS T1 INNER JOIN store AS T2 ON T1.address_id = T2.address_id INNER JOIN inventory AS T3 ON T2.store_id = T3.store_id INNER JOIN film AS T4 ON T3.film_id = T4.film_id WHERE T4.title = 'WYOMING STORM'