Database: shipping
Question: What is the total number of pounds being transported for S K L Enterprises Inc?
Evidence: "S K L Enterprises Inc" is the cust_name; total number of pounds refers to Sum(weight)
SQL: SELECT SUM(T2.weight) FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id WHERE T1.cust_name = 'S K L Enterprises Inc'

Database: address
Question: How many postal points are there under the congress representative in Puerto Rico?
Evidence: postal points refer to zip_code; Puerto Rico refers to state = 'Puerto Rico';
SQL: SELECT COUNT(T2.zip_code) FROM congress AS T1 INNER JOIN zip_congress AS T2 ON T1.cognress_rep_id = T2.district WHERE T1.state = 'Puerto Rico'

Database: movies_4
Question: Write down five rumoured movie titles within the genre of Drama.
Evidence: rumoured movie refers to movie_status = 'rumoured'; genre of Drama refers to genre_name = 'Drama'
SQL: SELECT T1.title 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.movie_status = 'Rumored' AND T3.genre_name = 'Drama' LIMIT 5

Database: movie_3
Question: Give the address location of Heather Morris.
Evidence: address location refers to address
SQL: SELECT T1.address FROM address AS T1 INNER JOIN customer AS T2 ON T1.address_id = T2.address_id WHERE T2.first_name = 'HEATHER' AND T2.last_name = 'MORRIS'

Database: authors
Question: Identify by papers title those in which conferences have been published that do not have a website..
Evidence: do not have a website refers to HomePage IS NULL OR HomePage = ''
SQL: SELECT T2.Title FROM Conference AS T1 INNER JOIN Paper AS T2 ON T1.Id = T2.ConferenceId WHERE T1.HomePage = '' AND T2.Title <> ''

Database: law_episode
Question: What are the keywords of the episode "Shield"?
Evidence: the episode "Shield" refers to title = 'Shield'
SQL: SELECT T2.keyword FROM Episode AS T1 INNER JOIN Keyword AS T2 ON T1.episode_id = T2.episode_id WHERE T1.title = 'Shield'

Database: college_completion
Question: Which institute has the highest percentage of male White students graduating in 2011 within 150 percent of normal/expected time?
Evidence: male refers to gender = 'M'; white refers to race = 'w'; in 2011 refers to year = 2011; graduating within 150 percent of normal/expected time refers to grad_150;
SQL: SELECT T1.chronname FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T2.year = 2011 AND T2.gender = 'M' AND T2.race = 'W' AND T2.grad_150 = ( SELECT MAX(T2.grad_150) FROM institution_details AS T1 INNER JOIN institution_grads AS T2 ON T2.unitid = T1.unitid WHERE T2.year = 2011 AND T2.gender = 'M' AND T2.race = 'W' )

Database: food_inspection_2
Question: Did license number 1222441 pass the inspection and what is the zip code number of it?
Evidence: license number 1222441 refers to license_no = 1222441; result of the inspection refers to results; zip code number refers to zip
SQL: SELECT DISTINCT T2.results, T1.zip FROM establishment AS T1 INNER JOIN inspection AS T2 ON T1.license_no = T2.license_no WHERE T1.license_no = 1222441

Database: movies_4
Question: Name the horror movies with positive ratings greater than 7.
Evidence: Name the horror movies refers to title where genre_name = 'horror'; positive ratings greater than 7 refers to vote_average > 7
SQL: SELECT T1.title 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 T3.genre_name = 'Horror' AND T1.vote_average > 7

Database: disney
Question: List all the songs associated with drama movies.
Evidence: drama refers to genre = 'Drama';
SQL: SELECT song FROM movies_total_gross AS T1 INNER JOIN characters AS T2 ON T1.movie_title = T2.movie_title WHERE T1.genre = 'Drama' GROUP BY song

Database: sales
Question: List down product ids that were purchased by customers called Abby.
SQL: SELECT DISTINCT T1.ProductID FROM Sales AS T1 INNER JOIN Customers AS T2 ON T1.CustomerID = T2.CustomerID WHERE T2.FirstName = 'Abby'

Database: retail_world
Question: Provide the list of products ordered by ID 10979 and calculate its total payment.
Evidence: ordered by ID 10979 refers to OrderID = '10979'; total payment refers to SUM(MULTIPLY(UnitPrice, Quantity, SUBTRACT(1, Discount)))
SQL: SELECT T1.ProductName , SUM(T2.UnitPrice * T2.Quantity * (1 - T2.Discount)) FROM Products AS T1 INNER JOIN `Order Details` AS T2 ON T1.ProductID = T2.ProductID WHERE T2.OrderID = 10979 GROUP BY T1.ProductName

Database: social_media
Question: Please list the top 3 cities with the most number of tweets posted in Canada.
Evidence: "Canada" is the Country; city with most number of tweets refers to City where Max(Count(TweetID))
SQL: SELECT T.City FROM ( SELECT T2.City, COUNT(T1.TweetID) AS num FROM twitter AS T1 INNER JOIN location AS T2 ON T1.LocationID = T2.LocationID WHERE T2.Country = 'Canada' GROUP BY T2.City ) T ORDER BY T.num DESC LIMIT 3

Database: synthea
Question: List out the start date of the care plan of alive patients.
Evidence: start of the care plan refers to careplans.START; alive patients refers to deathdate is null;
SQL: SELECT DISTINCT T1.START FROM careplans AS T1 INNER JOIN patients AS T2 ON T1.PATIENT = T2.patient WHERE T2.deathdate IS NULL

Database: regional_sales
Question: How many states are in the Midwest region?
SQL: SELECT COUNT(DISTINCT T) FROM ( SELECT CASE  WHEN Region = 'Midwest' THEN State ELSE NULL END AS T FROM Regions ) WHERE T IS NOT NULL

Database: synthea
Question: Please provide the dates on which Elly Koss was immunized with the influenza seasonal injectable preservative-free vaccine.
Evidence: date of immunization refers to immunizations.DATE; immunized with the influenza seasonal injectable preservative-free vaccine refers to immunizations.DESCRIPTION = 'Influenza seasonal injectable preservative free';
SQL: SELECT T2.DATE FROM patients AS T1 INNER JOIN immunizations AS T2 ON T1.patient = T2.PATIENT WHERE T2.DESCRIPTION = 'Influenza  seasonal  injectable  preservative free' AND T1.first = 'Elly' AND T1.last = 'Koss'

Database: talkingdata
Question: How many active users are there in the event?
Evidence: active refers to is_active = 1;
SQL: SELECT COUNT(app_id) FROM app_events WHERE is_active = 1

Database: trains
Question: Among the trains that run in the east direction, how many of them have more than 2 long cars?
Evidence: more than 2 long cars refers to longCarsNum > 2
SQL: SELECT SUM(CASE WHEN T2.longCarsNum > 2 THEN 1 ELSE 0 END)as count FROM trains AS T1 INNER JOIN ( SELECT train_id, COUNT(id) AS longCarsNum FROM cars WHERE len = 'long' GROUP BY train_id ) AS T2 ON T1.id = T2.train_id WHERE T1.direction = 'west'

Database: public_review_platform
Question: Among the user ID with number in compliment of uber on profile, list any 5 user ID and the year when they join Yelp.
Evidence: when join Yelp refers to user_yelping_since_year; compliment_type = 'profile'; number_of_compliments = 'Uber';
SQL: SELECT T3.user_id, T3.user_yelping_since_year FROM Compliments AS T1 INNER JOIN Users_Compliments AS T2 ON T1.compliment_id = T2.compliment_id INNER JOIN Users AS T3 ON T2.user_id = T3.user_id WHERE T1.compliment_type = 'profile' AND T2.number_of_compliments = 'Uber' LIMIT 5

Database: olympics
Question: How many Olympic competitors are from Finland?
Evidence: competitors refer to person_id; from Finland refers to region_name = 'Finland';
SQL: SELECT COUNT(T1.person_id) FROM person_region AS T1 INNER JOIN noc_region AS T2 ON T1.region_id = T2.id WHERE T2.region_name = 'Finland'

Database: software_company
Question: What is the age of female customers within the number of inhabitants below 30?
Evidence: female customers within the number of inhabitants below 30 refer to SEX = 'Female' where INHABITANTS_K < 30;
SQL: SELECT age FROM Customers WHERE GEOID IN ( SELECT GEOID FROM Demog WHERE INHABITANTS_K < 30 ) AND SEX = 'Female'