target-benchmark/spider-queries huggingface dataset:
Database: election (tables: election, county)
Question: What are the names of the county that the delegates on "Appropriations" committee belong to?
SQL: SELECT T1.County_name FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District WHERE T2.Committee  =  "Appropriations"
Database: election (tables: election, county)
Question: Which county do the delegates on "Appropriations" committee belong to? Give me the county names.
SQL: SELECT T1.County_name FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District WHERE T2.Committee  =  "Appropriations"
Database: election (tables: election, party)
Question: Show the delegates and the names of the party they belong to.
SQL: SELECT T1.Delegate ,  T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID
Database: election (tables: election, party)
Question: For each delegate, find the names of the party they are part of.
SQL: SELECT T1.Delegate ,  T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID
Database: election (tables: election, party)
Question: Who were the governors of the parties associated with delegates from district 1?
SQL: SELECT T2.Governor FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T1.District  =  1
Database: election (tables: election, party)
Question: Find the parties associated with the delegates from district 1. Who served as governors of the parties?
SQL: SELECT T2.Governor FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T1.District  =  1
Database: election (tables: election, party)
Question: Who were the comptrollers of the parties associated with the delegates from district 1 or district 2?
SQL: SELECT T2.Comptroller FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T1.District  =  1 OR T1.District  =  2
Database: election (tables: election, party)
Question: Find the parties associated with the delegates from district 1 or 2. Who served as comptrollers of the parties?
SQL: SELECT T2.Comptroller FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T1.District  =  1 OR T1.District  =  2
Database: election (tables: election, party)
Question: Return all the committees that have delegates from Democratic party.
SQL: SELECT T1.Committee FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T2.Party  =  "Democratic"
Database: election (tables: election, party)
Question: Which committees have delegates from the Democratic party?
SQL: SELECT T1.Committee FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T2.Party  =  "Democratic"
Database: election (tables: election, county)
Question: Show the name of each county along with the corresponding number of delegates from that county.
SQL: SELECT T1.County_name ,  COUNT(*) FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District GROUP BY T1.County_id
Database: election (tables: election, county)
Question: For each county, find the name of the county and the number of delegates from that county.
SQL: SELECT T1.County_name ,  COUNT(*) FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District GROUP BY T1.County_id
Database: election (tables: election, party)
Question: Show the name of each party and the corresponding number of delegates from that party.
SQL: SELECT T2.Party ,  COUNT(*) FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID GROUP BY T1.Party
Database: election (tables: election, party)
Question: For each party, return the name of the party and the number of delegates from that party.
SQL: SELECT T2.Party ,  COUNT(*) FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID GROUP BY T1.Party
Database: election (tables: county)
Question: Return the names of all counties sorted by population in ascending order.
SQL: SELECT County_name FROM county ORDER BY Population ASC
Database: election (tables: county)
Question: Sort the names of all counties in ascending order of population.
SQL: SELECT County_name FROM county ORDER BY Population ASC
Database: election (tables: county)
Question: Return the names of all counties sorted by county name in descending alphabetical order.
SQL: SELECT County_name FROM county ORDER BY County_name DESC
Database: election (tables: county)
Question: Sort the names of all counties in descending alphabetical order.
SQL: SELECT County_name FROM county ORDER BY County_name DESC
Database: election (tables: county)
Question: Show the name of the county with the biggest population.
SQL: SELECT County_name FROM county ORDER BY Population DESC LIMIT 1
Database: election (tables: county)
Question: Which county has the largest population? Give me the name of the county.
SQL: SELECT County_name FROM county ORDER BY Population DESC LIMIT 1
Database: election (tables: county)
Question: Show the 3 counties with the smallest population.
SQL: SELECT County_name FROM county ORDER BY Population ASC LIMIT 3
Database: election (tables: county)
Question: What are the 3 counties that have the smallest population? Give me the county names.
SQL: SELECT County_name FROM county ORDER BY Population ASC LIMIT 3
Database: election (tables: election, county)
Question: Show the names of counties that have at least two delegates.
SQL: SELECT T1.County_name FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District GROUP BY T1.County_id HAVING COUNT(*)  >=  2
Database: election (tables: election, county)
Question: Which counties have two or more delegates? Give me the county names.
SQL: SELECT T1.County_name FROM county AS T1 JOIN election AS T2 ON T1.County_id  =  T2.District GROUP BY T1.County_id HAVING COUNT(*)  >=  2
Database: election (tables: party)
Question: Show the name of the party that has at least two records.
SQL: SELECT Party FROM party GROUP BY Party HAVING COUNT(*)  >=  2
Database: election (tables: party)
Question: Which party has two or more records?
SQL: SELECT Party FROM party GROUP BY Party HAVING COUNT(*)  >=  2
Database: election (tables: election, party)
Question: Show the name of the party that has the most delegates.
SQL: SELECT T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID GROUP BY T1.Party ORDER BY COUNT(*) DESC LIMIT 1
Database: election (tables: election, party)
Question: Which party has the largest number of delegates?
SQL: SELECT T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID GROUP BY T1.Party ORDER BY COUNT(*) DESC LIMIT 1
Database: election (tables: party)
Question: Show the people that have been governor the most times.
SQL: SELECT Governor FROM party GROUP BY Governor ORDER BY COUNT(*) DESC LIMIT 1
Database: election (tables: party)
Question: Which people severed as governor most frequently?
SQL: SELECT Governor FROM party GROUP BY Governor ORDER BY COUNT(*) DESC LIMIT 1
Database: election (tables: party)
Question: Show the people that have been comptroller the most times and the corresponding number of times.
SQL: SELECT Comptroller ,  COUNT(*) FROM party GROUP BY Comptroller ORDER BY COUNT(*) DESC LIMIT 1
Database: election (tables: party)
Question: Which people severed as comptroller most frequently? Give me the name of the person and the frequency count.
SQL: SELECT Comptroller ,  COUNT(*) FROM party GROUP BY Comptroller ORDER BY COUNT(*) DESC LIMIT 1
Database: election (tables: election, party)
Question: What are the names of parties that do not have delegates in election?
SQL: SELECT Party FROM party WHERE Party_ID NOT IN (SELECT Party FROM election)
Database: election (tables: election, party)
Question: Which parties did not have any delegates in elections?
SQL: SELECT Party FROM party WHERE Party_ID NOT IN (SELECT Party FROM election)
Database: election (tables: election, party)
Question: What are the names of parties that have both delegates on "Appropriations" committee and
SQL: SELECT T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T1.Committee  =  "Appropriations" INTERSECT SELECT T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T1.Committee  =  "Economic Matters"
Database: election (tables: election, party)
Question: Which parties have delegates in both the "Appropriations" committee and the "Economic Matters" committee?
SQL: SELECT T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T1.Committee  =  "Appropriations" INTERSECT SELECT T2.Party FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T1.Committee  =  "Economic Matters"
Database: election (tables: election, party)
Question: Which committees have delegates from both democratic party and liberal party?
SQL: SELECT T1.Committee FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T2.Party  =  "Democratic" INTERSECT SELECT T1.Committee FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T2.Party  =  "Liberal"
Database: election (tables: election, party)
Question: Find the committees that have delegates both from from the democratic party and the liberal party.
SQL: SELECT T1.Committee FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T2.Party  =  "Democratic" INTERSECT SELECT T1.Committee FROM election AS T1 JOIN party AS T2 ON T1.Party  =  T2.Party_ID WHERE T2.Party  =  "Liberal"
Database: news_report (tables: journalist)
Question: How many journalists are there?
SQL: SELECT count(*) FROM journalist
Database: news_report (tables: journalist)
Question: List the names of journalists in ascending order of years working.
SQL: SELECT Name FROM journalist ORDER BY Years_working ASC
Database: news_report (tables: journalist)
Question: What are the nationalities and ages of journalists?
SQL: SELECT Nationality ,  Age FROM journalist
Database: news_report (tables: journalist)
Question: Show the names of journalists from "England" or "Wales".
SQL: SELECT Name FROM journalist WHERE Nationality  =  "England" OR Nationality  =  "Wales"
Database: news_report (tables: journalist)
Question: What is the average number of years spent working as a journalist?
SQL: SELECT avg(Years_working) FROM journalist
Database: news_report (tables: journalist)
Question: What is the nationality of the journalist with the largest number of years working?
SQL: SELECT Nationality FROM journalist ORDER BY Years_working DESC LIMIT 1
Database: news_report (tables: journalist)
Question: Show the different nationalities and the number of journalists of each nationality.
SQL: SELECT Nationality ,  COUNT(*) FROM journalist GROUP BY Nationality
Database: news_report (tables: journalist)
Question: Show the most common nationality for journalists.
SQL: SELECT Nationality FROM journalist GROUP BY Nationality ORDER BY COUNT(*) DESC LIMIT 1
Database: news_report (tables: journalist)
Question: Show the nations that have both journalists with more than 10 years of working and journalists with less than 3 years of working.
SQL: SELECT Nationality FROM journalist WHERE Years_working  >  10 INTERSECT SELECT Nationality FROM journalist WHERE Years_working  <  3
Database: news_report (tables: event)
Question: Show the dates, places, and names of events in descending order of the attendance.
SQL: SELECT Date ,  Name ,  venue FROM event ORDER BY Event_Attendance DESC
Database: news_report (tables: news_report, journalist, event)
Question: Show the names of journalists and the dates of the events they reported.
SQL: SELECT T3.Name ,  T2.Date FROM news_report AS T1 JOIN event AS T2 ON T1.Event_ID  =  T2.Event_ID JOIN journalist AS T3 ON T1.journalist_ID  =  T3.journalist_ID
Database: news_report (tables: news_report, journalist, event)
Question: Show the names of journalists and the names of the events they reported in ascending order
SQL: SELECT T3.Name ,  T2.Name FROM news_report AS T1 JOIN event AS T2 ON T1.Event_ID  =  T2.Event_ID JOIN journalist AS T3 ON T1.journalist_ID  =  T3.journalist_ID ORDER BY T2.Event_Attendance ASC
Database: news_report (tables: news_report, journalist, event)
Question: Show the names of journalists and the number of events they reported.
SQL: SELECT T3.Name ,  COUNT(*) FROM news_report AS T1 JOIN event AS T2 ON T1.Event_ID  =  T2.Event_ID JOIN journalist AS T3 ON T1.journalist_ID  =  T3.journalist_ID GROUP BY T3.Name
Database: news_report (tables: news_report, journalist, event)
Question: Show the names of journalists that have reported more than one event.
SQL: SELECT T3.Name FROM news_report AS T1 JOIN event AS T2 ON T1.Event_ID  =  T2.Event_ID JOIN journalist AS T3 ON T1.journalist_ID  =  T3.journalist_ID GROUP BY T3.Name HAVING COUNT(*)  >  1
Database: news_report (tables: news_report, journalist)
Question: List the names of journalists who have not reported any event.
SQL: SELECT Name FROM journalist WHERE journalist_ID NOT IN (SELECT journalist_ID FROM news_report)
Database: news_report (tables: event)
Question: what are the average and maximum attendances of all events?
SQL: SELECT avg(Event_Attendance) ,  max(Event_Attendance) FROM event
Database: news_report (tables: news_report, journalist)
Question: Find the average age and experience working length of journalists working on different role type.
SQL: SELECT avg(t1.age) ,  avg(Years_working) ,  t2.work_type FROM journalist AS t1 JOIN news_report AS t2 ON t1.journalist_id  =  t2.journalist_id GROUP BY t2.work_type
Database: news_report (tables: event)
Question: List the event venues and names that have the top 2 most number of people attended.
SQL: SELECT venue ,  name FROM event ORDER BY Event_Attendance DESC LIMIT 2
Database: restaurant_1 (tables: restaurant)
Question: Show me all the restaurants.
SQL: SELECT ResName FROM Restaurant;
Database: restaurant_1 (tables: restaurant)
Question: What is the address of the restaurant Subway?
SQL: SELECT Address FROM Restaurant WHERE ResName = "Subway";
Database: restaurant_1 (tables: restaurant)
Question: What is the rating of the restaurant Subway?
SQL: SELECT Rating FROM Restaurant WHERE ResName = "Subway";
Database: restaurant_1 (tables: restaurant_type)
Question: List all restaurant types.
SQL: SELECT ResTypeName FROM Restaurant_Type;
Database: restaurant_1 (tables: restaurant_type)
Question: What is the description of the restaurant type Sandwich?
SQL: SELECT ResTypeDescription FROM Restaurant_Type WHERE ResTypeName = "Sandwich";
Database: restaurant_1 (tables: restaurant)
Question: Which restaurants have highest rating? List the restaurant name and its rating.
SQL: SELECT ResName , Rating FROM Restaurant ORDER BY Rating DESC LIMIT 1;
Database: restaurant_1 (tables: student)
Question: What is the age of student Linda Smith?
SQL: SELECT Age FROM Student WHERE Fname = "Linda" AND Lname = "Smith";
Database: restaurant_1 (tables: student)
Question: What is the gender of the student Linda Smith?
SQL: SELECT Sex FROM Student WHERE Fname = "Linda" AND Lname = "Smith";
Database: restaurant_1 (tables: student)
Question: List all students' first names and last names who majored in 600.
SQL: SELECT Fname , Lname FROM Student WHERE Major  =  600;
Database: restaurant_1 (tables: student)
Question: Which city does student Linda Smith live in?
SQL: SELECT city_code FROM Student WHERE Fname = "Linda" AND Lname = "Smith";
Database: restaurant_1 (tables: student)
Question: Advisor 1121 has how many students?
SQL: SELECT count(*) FROM Student WHERE Advisor =  1121;
Database: restaurant_1 (tables: student)
Question: Which Advisor has most of students? List advisor and the number of students.
SQL: SELECT Advisor ,  count(*) FROM Student GROUP BY Advisor ORDER BY count(Advisor) DESC LIMIT 1;
Database: restaurant_1 (tables: student)
Question: Which major has least number of students? List the major and the number of students.
SQL: SELECT Major ,  count(*) FROM Student GROUP BY Major ORDER BY count(Major) ASC LIMIT 1;
Database: restaurant_1 (tables: student)
Question: Which major has between 2 and 30 number of students? List major and the number of students.
SQL: SELECT Major ,  count(*) FROM Student GROUP BY Major HAVING count(Major) BETWEEN 2 AND 30;
Database: restaurant_1 (tables: student)
Question: Which student's age is older than 18 and is majoring in 600? List each student's first and last name.
SQL: SELECT Fname , Lname FROM Student WHERE Age  >  18 AND Major = 600;
Database: restaurant_1 (tables: student)
Question: List all female students age is older than 18 who is not majoring in 600. List students' first name and last name.
SQL: SELECT Fname , Lname FROM Student WHERE Age  >  18 AND Major != 600 AND Sex = 'F';
Database: restaurant_1 (tables: restaurant, restaurant_type, type_of_restaurant)
Question: How many restaurant is the Sandwich type restaurant?
SQL: SELECT count(*) FROM Restaurant JOIN Type_Of_Restaurant ON Restaurant.ResID =  Type_Of_Restaurant.ResID JOIN Restaurant_Type ON Type_Of_Restaurant.ResTypeID = Restaurant_Type.ResTypeID GROUP BY Type_Of_Restaurant.ResTypeID HAVING Restaurant_Type.ResTypeName = 'Sandwich'
Database: restaurant_1 (tables: visits_restaurant, student)
Question: How long does student Linda Smith spend on the restaurant in total?
SQL: SELECT sum(Spent) FROM Student JOIN Visits_Restaurant ON Student.StuID = Visits_Restaurant.StuID WHERE Student.Fname = "Linda" AND Student.Lname = "Smith";
Database: restaurant_1 (tables: visits_restaurant, student, restaurant)
Question: How many times has the student Linda Smith visited Subway?
SQL: SELECT count(*) FROM Student JOIN Visits_Restaurant ON Student.StuID = Visits_Restaurant.StuID JOIN Restaurant ON Visits_Restaurant.ResID = Restaurant.ResID WHERE Student.Fname = "Linda" AND Student.Lname = "Smith" AND Restaurant.ResName = "Subway";
Database: restaurant_1 (tables: visits_restaurant, student, restaurant)
Question: When did Linda Smith visit Subway?
SQL: SELECT TIME FROM Student JOIN Visits_Restaurant ON Student.StuID = Visits_Restaurant.StuID JOIN Restaurant ON Visits_Restaurant.ResID = Restaurant.ResID WHERE Student.Fname = "Linda" AND Student.Lname = "Smith" AND Restaurant.ResName = "Subway";
Database: restaurant_1 (tables: visits_restaurant, restaurant)
Question: At which restaurant did the students spend the least amount of time? List restaurant and the time students spent on in total.
SQL: SELECT Restaurant.ResName ,  sum(Visits_Restaurant.Spent) FROM Visits_Restaurant JOIN Restaurant ON Visits_Restaurant.ResID = Restaurant.ResID GROUP BY Restaurant.ResID ORDER BY sum(Visits_Restaurant.Spent) ASC LIMIT 1;
Database: restaurant_1 (tables: visits_restaurant, student)
Question: Which student visited restaurant most often? List student's first name and last name.
SQL: SELECT Student.Fname , Student.Lname FROM Student JOIN Visits_Restaurant ON Student.StuID = Visits_Restaurant.StuID GROUP BY Student.StuID ORDER BY count(*) DESC LIMIT 1;
Database: customer_deliveries (tables: actual_orders)
Question: Find the ids of orders whose status is 'Success'.
SQL: SELECT actual_order_id FROM actual_orders WHERE order_status_code  =  'Success'
Database: customer_deliveries (tables: products, regular_order_products)
Question: Find the name and price of the product that has been ordered the greatest number of times.
SQL: SELECT t1.product_name ,   t1.product_price FROM products AS t1 JOIN regular_order_products AS t2 ON t1.product_id  =  t2.product_id GROUP BY t2.product_id ORDER BY count(*) DESC LIMIT 1
Database: customer_deliveries (tables: customers)
Question: Find the number of customers in total.
SQL: SELECT count(*) FROM customers
Database: customer_deliveries (tables: customers)
Question: How many different payment methods are there?
SQL: SELECT count(DISTINCT payment_method) FROM customers
Database: customer_deliveries (tables: trucks)
Question: Show the details of all trucks in the order of their license number.
SQL: SELECT truck_details FROM trucks ORDER BY truck_licence_number
Database: customer_deliveries (tables: products)
Question: Find the name of the most expensive product.
SQL: SELECT product_name FROM products ORDER BY product_price DESC LIMIT 1
Database: customer_deliveries (tables: addresses, customers, customer_addresses)
Question: Find the names of customers who are not living in the state of California.
SQL: SELECT customer_name FROM customers EXCEPT SELECT t1.customer_name FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id WHERE t3.state_province_county  =  'California'
Database: customer_deliveries (tables: customers)
Question: List the names and emails of customers who payed by Visa card.
SQL: SELECT customer_email ,  customer_name FROM customers WHERE payment_method  =  'Visa'
Database: customer_deliveries (tables: addresses, customers, customer_addresses)
Question: Find the names and phone numbers of customers living in California state.
SQL: SELECT t1.customer_name ,  t1.customer_phone FROM customers AS t1 JOIN customer_addresses AS t2 ON t1.customer_id  =  t2.customer_id JOIN addresses AS t3 ON t2.address_id  =  t3.address_id WHERE t3.state_province_county  =  'California'
Database: customer_deliveries (tables: addresses, employees)
Question: Find the states which do not have any employee in their record.
SQL: SELECT state_province_county FROM addresses WHERE address_id NOT IN (SELECT employee_address_id FROM Employees)
Database: customer_deliveries (tables: customers)
Question: List the names, phone numbers, and emails of all customers sorted by their dates of becoming customers.
SQL: SELECT customer_name ,  customer_phone ,  customer_email FROM Customers ORDER BY date_became_customer
Database: customer_deliveries (tables: customers)
Question: Find the name of the first 5 customers.
SQL: SELECT customer_name FROM Customers ORDER BY date_became_customer LIMIT 5
Database: customer_deliveries (tables: customers)
Question: Find the payment method that is used most frequently.
SQL: SELECT payment_method FROM Customers GROUP BY payment_method ORDER BY count(*) DESC LIMIT 1
Database: customer_deliveries (tables: delivery_routes)
Question: List the names of all routes in alphabetic order.
SQL: SELECT route_name FROM Delivery_Routes ORDER BY route_name
Database: customer_deliveries (tables: delivery_routes, delivery_route_locations)
Question: Find the name of route that has the highest number of deliveries.
SQL: SELECT t1.route_name FROM Delivery_Routes AS t1 JOIN Delivery_Route_Locations AS t2 ON t1.route_id  =  t2.route_id GROUP BY t1.route_id ORDER BY count(*) DESC LIMIT 1
Database: customer_deliveries (tables: addresses, customer_addresses)
Question: List the state names and the number of customers living in each state.
SQL: SELECT t2.state_province_county ,  count(*) FROM customer_addresses AS t1 JOIN addresses AS t2 ON t1.address_id  =  t2.address_id GROUP BY t2.state_province_county
Database: icfp_1 (tables: authors)
Question: How many authors are there?
SQL: SELECT count(*) FROM authors
Database: icfp_1 (tables: authors)
Question: Count the number of authors.
SQL: SELECT count(*) FROM authors
Database: icfp_1 (tables: inst)
Question: How many institutions are there?
SQL: SELECT count(*) FROM inst
Database: icfp_1 (tables: inst)
Question: Count the number of institutions.
SQL: SELECT count(*) FROM inst
Database: icfp_1 (tables: papers)
Question: How many papers are published in total?
SQL: SELECT count(*) FROM papers
Database: icfp_1 (tables: papers)
Question: Count the number of total papers.
SQL: SELECT count(*) FROM papers
Database: icfp_1 (tables: authorship, authors, papers)
Question: What are the titles of papers published by "Jeremy Gibbons"?
SQL: SELECT t3.title FROM authors AS t1 JOIN authorship AS t2 ON t1.authid  =  t2.authid JOIN papers AS t3 ON t2.paperid  =  t3.paperid WHERE  t1.fname  =  "Jeremy" AND t1.lname  =  "Gibbons"
Database: icfp_1 (tables: authorship, authors, papers)
Question: Find the titles of all the papers written by "Jeremy Gibbons"
SQL: SELECT t3.title FROM authors AS t1 JOIN authorship AS t2 ON t1.authid  =  t2.authid JOIN papers AS t3 ON t2.paperid  =  t3.paperid WHERE  t1.fname  =  "Jeremy" AND t1.lname  =  "Gibbons"
Database: icfp_1 (tables: authorship, authors, papers)
Question: Find all the papers published by "Aaron Turon".
SQL: SELECT t3.title FROM authors AS t1 JOIN authorship AS t2 ON t1.authid  =  t2.authid JOIN papers AS t3 ON t2.paperid  =  t3.paperid WHERE  t1.fname  =  "Aaron" AND t1.lname  =  "Turon"