target-benchmark/spider-queries huggingface dataset:
Database: dorm_1 (tables: student)
Question: How many students are there in each major?
SQL: SELECT count(*) ,  major FROM student GROUP BY major
Database: dorm_1 (tables: student)
Question: Find the number and average age of students living in each city.
SQL: SELECT count(*) ,  avg(age) ,  city_code FROM student GROUP BY city_code
Database: dorm_1 (tables: student)
Question: How many students live in each city and what are their average ages?
SQL: SELECT count(*) ,  avg(age) ,  city_code FROM student GROUP BY city_code
Database: dorm_1 (tables: student)
Question: Find the average age and number of male students (with sex M) from each city.
SQL: SELECT count(*) ,  avg(age) ,  city_code FROM student WHERE sex  =  'M' GROUP BY city_code
Database: dorm_1 (tables: student)
Question: What is the average age and how many male students are there in each city?
SQL: SELECT count(*) ,  avg(age) ,  city_code FROM student WHERE sex  =  'M' GROUP BY city_code
Database: dorm_1 (tables: student)
Question: Find the number of students for the cities where have more than one student.
SQL: SELECT count(*) ,  city_code FROM student GROUP BY city_code HAVING count(*)  >  1
Database: dorm_1 (tables: student)
Question: How many students are from each city, and which cities have more than one cities?
SQL: SELECT count(*) ,  city_code FROM student GROUP BY city_code HAVING count(*)  >  1
Database: dorm_1 (tables: student)
Question: Find the first and last name of students who are not in the largest major.
SQL: SELECT fname ,  lname FROM student WHERE major != (SELECT major FROM student GROUP BY major ORDER BY count(*) DESC LIMIT 1)
Database: dorm_1 (tables: student)
Question: What is the first and last name of the students who are not in the largest major?
SQL: SELECT fname ,  lname FROM student WHERE major != (SELECT major FROM student GROUP BY major ORDER BY count(*) DESC LIMIT 1)
Database: dorm_1 (tables: student)
Question: Find the number of students whose age is older than the average age for each gender.
SQL: SELECT count(*) ,  sex FROM student WHERE age  >  (SELECT avg(age) FROM student) GROUP BY sex
Database: dorm_1 (tables: student)
Question: How many students are older than average for each gender?
SQL: SELECT count(*) ,  sex FROM student WHERE age  >  (SELECT avg(age) FROM student) GROUP BY sex
Database: dorm_1 (tables: lives_in, student, dorm)
Question: Find the average age of students living in each dorm and the name of dorm.
SQL: SELECT avg(T1.age) ,  T3.dorm_name FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid GROUP BY T3.dorm_name
Database: dorm_1 (tables: lives_in, student, dorm)
Question: What is the average age for each dorm and what are the names of each dorm?
SQL: SELECT avg(T1.age) ,  T3.dorm_name FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid GROUP BY T3.dorm_name
Database: dorm_1 (tables: has_amenity, dorm)
Question: Find the number of amenities for each of the dorms that can accommodate more than 100 students.
SQL: SELECT count(*) ,  T1.dormid FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid WHERE T1.student_capacity  >  100 GROUP BY T1.dormid
Database: dorm_1 (tables: has_amenity, dorm)
Question: For each dorm, how many amenities does it have?
SQL: SELECT count(*) ,  T1.dormid FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid WHERE T1.student_capacity  >  100 GROUP BY T1.dormid
Database: dorm_1 (tables: lives_in, student, dorm)
Question: Find the number of students who is older than 20 in each dorm.
SQL: SELECT count(*) ,  T3.dorm_name FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid WHERE T1.age  >  20 GROUP BY T3.dorm_name
Database: dorm_1 (tables: lives_in, student, dorm)
Question: How many students are older than 20 in each dorm?
SQL: SELECT count(*) ,  T3.dorm_name FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid WHERE T1.age  >  20 GROUP BY T3.dorm_name
Database: dorm_1 (tables: lives_in, student, dorm)
Question: Find the first name of students who are living in the Smith Hall.
SQL: SELECT T1.fname FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid WHERE T3.dorm_name  =  'Smith Hall'
Database: dorm_1 (tables: lives_in, student, dorm)
Question: What are the first names of all students in Smith Hall?
SQL: SELECT T1.fname FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid WHERE T3.dorm_name  =  'Smith Hall'
Database: dorm_1 (tables: lives_in, student, dorm)
Question: Find the average age of students who are living in the dorm with the largest capacity.
SQL: SELECT avg(T1.age) FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid WHERE T3.student_capacity  =  (SELECT max(student_capacity) FROM dorm)
Database: dorm_1 (tables: lives_in, student, dorm)
Question: What is the average age of students who are living in the dorm with the largest capacity?
SQL: SELECT avg(T1.age) FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid WHERE T3.student_capacity  =  (SELECT max(student_capacity) FROM dorm)
Database: dorm_1 (tables: lives_in, student, dorm)
Question: Find the total number of students living in the male dorm (with gender M).
SQL: SELECT count(*) FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid WHERE T3.gender  =  'M'
Database: dorm_1 (tables: lives_in, student, dorm)
Question: What are the total number of students who are living in a male dorm?
SQL: SELECT count(*) FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid WHERE T3.gender  =  'M'
Database: dorm_1 (tables: lives_in, student, dorm)
Question: Find the number of female students (with F sex) living in Smith Hall
SQL: SELECT count(*) FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid WHERE T3.dorm_name  =  'Smith Hall' AND T1.sex  =  'F'
Database: dorm_1 (tables: lives_in, student, dorm)
Question: How many female students live in Smith Hall?
SQL: SELECT count(*) FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid JOIN dorm AS T3 ON T3.dormid  =  T2.dormid WHERE T3.dorm_name  =  'Smith Hall' AND T1.sex  =  'F'
Database: dorm_1 (tables: has_amenity, dorm, dorm_amenity)
Question: Find the name of amenities Smith Hall dorm have.
SQL: SELECT T3.amenity_name FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid JOIN dorm_amenity AS T3 ON T2.amenid  =  T3.amenid WHERE T1.dorm_name  =  'Smith Hall'
Database: dorm_1 (tables: has_amenity, dorm, dorm_amenity)
Question: What are the names of the amenities that Smith Hall has?
SQL: SELECT T3.amenity_name FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid JOIN dorm_amenity AS T3 ON T2.amenid  =  T3.amenid WHERE T1.dorm_name  =  'Smith Hall'
Database: dorm_1 (tables: has_amenity, dorm, dorm_amenity)
Question: Find the name of amenities Smith Hall dorm have. ordered the results by amenity names.
SQL: SELECT T3.amenity_name FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid JOIN dorm_amenity AS T3 ON T2.amenid  =  T3.amenid WHERE T1.dorm_name  =  'Smith Hall' ORDER BY T3.amenity_name
Database: dorm_1 (tables: has_amenity, dorm, dorm_amenity)
Question: What amenities does Smith Hall have in alphabetical order?
SQL: SELECT T3.amenity_name FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid JOIN dorm_amenity AS T3 ON T2.amenid  =  T3.amenid WHERE T1.dorm_name  =  'Smith Hall' ORDER BY T3.amenity_name
Database: dorm_1 (tables: has_amenity, dorm_amenity)
Question: Find the name of amenity that is most common in all dorms.
SQL: SELECT T1.amenity_name FROM dorm_amenity AS T1 JOIN has_amenity AS T2 ON T1.amenid  =  T2.amenid GROUP BY T2.amenid ORDER BY count(*) DESC LIMIT 1
Database: dorm_1 (tables: has_amenity, dorm_amenity)
Question: What is the most common amenity in the dorms?
SQL: SELECT T1.amenity_name FROM dorm_amenity AS T1 JOIN has_amenity AS T2 ON T1.amenid  =  T2.amenid GROUP BY T2.amenid ORDER BY count(*) DESC LIMIT 1
Database: dorm_1 (tables: student, lives_in, has_amenity, dorm, dorm_amenity)
Question: Find the first name of students who are living in the dorm that has most number of amenities.
SQL: SELECT T1.fname FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid WHERE T2.dormid IN (SELECT T2.dormid FROM dorm AS T3 JOIN has_amenity AS T4 ON T3.dormid  =  T4.dormid JOIN dorm_amenity AS T5 ON T4.amenid  =  T5.amenid GROUP BY T3.dormid ORDER BY count(*) DESC LIMIT 1)
Database: dorm_1 (tables: student, lives_in, has_amenity, dorm, dorm_amenity)
Question: What are the first names of all students who live in the dorm with the most amenities?
SQL: SELECT T1.fname FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid WHERE T2.dormid IN (SELECT T2.dormid FROM dorm AS T3 JOIN has_amenity AS T4 ON T3.dormid  =  T4.dormid JOIN dorm_amenity AS T5 ON T4.amenid  =  T5.amenid GROUP BY T3.dormid ORDER BY count(*) DESC LIMIT 1)
Database: dorm_1 (tables: has_amenity, dorm, dorm_amenity)
Question: Find the name and capacity of the dorm with least number of amenities.
SQL: SELECT T1.dorm_name ,  T1.student_capacity FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid JOIN dorm_amenity AS T3 ON T2.amenid  =  T3.amenid GROUP BY T2.dormid ORDER BY count(*) LIMIT 1
Database: dorm_1 (tables: has_amenity, dorm, dorm_amenity)
Question: What is the name and capacity of the dorm with the fewest amount of amenities?
SQL: SELECT T1.dorm_name ,  T1.student_capacity FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid JOIN dorm_amenity AS T3 ON T2.amenid  =  T3.amenid GROUP BY T2.dormid ORDER BY count(*) LIMIT 1
Database: dorm_1 (tables: has_amenity, dorm, dorm_amenity)
Question: Find the name of dorms that do not have amenity TV Lounge.
SQL: SELECT dorm_name FROM dorm EXCEPT SELECT T1.dorm_name FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid JOIN dorm_amenity AS T3 ON T2.amenid  =  T3.amenid WHERE T3.amenity_name  =  'TV Lounge'
Database: dorm_1 (tables: has_amenity, dorm, dorm_amenity)
Question: What are the names of the dorm that does not have a TV Lounge?
SQL: SELECT dorm_name FROM dorm EXCEPT SELECT T1.dorm_name FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid JOIN dorm_amenity AS T3 ON T2.amenid  =  T3.amenid WHERE T3.amenity_name  =  'TV Lounge'
Database: dorm_1 (tables: lives_in, student, has_amenity, dorm_amenity)
Question: Find the first and last name of students who are living in the dorms that have amenity TV Lounge.
SQL: SELECT T1.fname ,  T1.lname FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid WHERE T2.dormid IN (SELECT T3.dormid FROM has_amenity AS T3 JOIN dorm_amenity AS T4 ON T3.amenid  =  T4.amenid WHERE T4.amenity_name  =  'TV Lounge')
Database: dorm_1 (tables: lives_in, student, has_amenity, dorm_amenity)
Question: What are the first and last names of all students who are living in a dorm with a TV Lounge?
SQL: SELECT T1.fname ,  T1.lname FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid WHERE T2.dormid IN (SELECT T3.dormid FROM has_amenity AS T3 JOIN dorm_amenity AS T4 ON T3.amenid  =  T4.amenid WHERE T4.amenity_name  =  'TV Lounge')
Database: dorm_1 (tables: lives_in, student, has_amenity, dorm_amenity)
Question: Find the first name and age of students who are living in the dorms that do not have amenity TV Lounge.
SQL: SELECT T1.fname ,  T1.age FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid WHERE T2.dormid NOT IN (SELECT T3.dormid FROM has_amenity AS T3 JOIN dorm_amenity AS T4 ON T3.amenid  =  T4.amenid WHERE T4.amenity_name  =  'TV Lounge')
Database: dorm_1 (tables: lives_in, student, has_amenity, dorm_amenity)
Question: What is the first name and age of every student who lives in a dorm with a TV Lounge?
SQL: SELECT T1.fname ,  T1.age FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid  =  T2.stuid WHERE T2.dormid NOT IN (SELECT T3.dormid FROM has_amenity AS T3 JOIN dorm_amenity AS T4 ON T3.amenid  =  T4.amenid WHERE T4.amenity_name  =  'TV Lounge')
Database: dorm_1 (tables: student, lives_in, has_amenity, dorm, dorm_amenity)
Question: Find the name of amenities of the dorm where the student with last name Smith is living in.
SQL: SELECT T3.amenity_name FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid JOIN dorm_amenity AS T3 ON T2.amenid  =  T3.amenid JOIN lives_in AS T4 ON T4.dormid  =  T1.dormid JOIN student AS T5 ON T5.stuid  =  T4.stuid WHERE T5.lname  =  'Smith'
Database: dorm_1 (tables: student, lives_in, has_amenity, dorm, dorm_amenity)
Question: What are the amenities in the dorm that a student who has the last name of Smith lives in?
SQL: SELECT T3.amenity_name FROM dorm AS T1 JOIN has_amenity AS T2 ON T1.dormid  =  T2.dormid JOIN dorm_amenity AS T3 ON T2.amenid  =  T3.amenid JOIN lives_in AS T4 ON T4.dormid  =  T1.dormid JOIN student AS T5 ON T5.stuid  =  T4.stuid WHERE T5.lname  =  'Smith'
Database: customer_complaints (tables: customers)
Question: How many customers are there?
SQL: SELECT count(*) FROM customers
Database: customer_complaints (tables: customers)
Question: Count the number of customers.
SQL: SELECT count(*) FROM customers
Database: customer_complaints (tables: customers)
Question: Find the emails and phone numbers of all the customers, ordered by email address and phone number.
SQL: SELECT email_address ,  phone_number FROM customers ORDER BY email_address ,  phone_number
Database: customer_complaints (tables: customers)
Question: What are the emails and phone numbers of all customers, sorted by email address and phone number?
SQL: SELECT email_address ,  phone_number FROM customers ORDER BY email_address ,  phone_number
Database: customer_complaints (tables: customers)
Question: Which city has the least number of customers whose type code is "Good Credit Rating"?
SQL: SELECT town_city FROM customers WHERE customer_type_code  =  "Good Credit Rating" GROUP BY town_city ORDER BY count(*) LIMIT 1
Database: customer_complaints (tables: customers)
Question: Return the city with the customer type code "Good Credit Rating" that had the fewest customers.
SQL: SELECT town_city FROM customers WHERE customer_type_code  =  "Good Credit Rating" GROUP BY town_city ORDER BY count(*) LIMIT 1
Database: customer_complaints (tables: products, complaints)
Question: List the name of all products along with the number of complaints that they have received.
SQL: SELECT t1.product_name ,  count(*) FROM products AS t1 JOIN complaints AS t2 ON t1.product_id  =  t2.product_id GROUP BY t1.product_name
Database: customer_complaints (tables: products, complaints)
Question: What are all the different product names, and how many complains has each received?
SQL: SELECT t1.product_name ,  count(*) FROM products AS t1 JOIN complaints AS t2 ON t1.product_id  =  t2.product_id GROUP BY t1.product_name
Database: customer_complaints (tables: customers, complaints)
Question: Find the emails of customers who has filed a complaints of the product with the most complaints.
SQL: SELECT t1.email_address FROM customers AS t1 JOIN complaints AS t2 ON t1.customer_id  =  t2.customer_id GROUP BY t1.customer_id ORDER BY count(*) LIMIT 1
Database: customer_complaints (tables: customers, complaints)
Question: What are the emails of customers who have filed complaints on the product which has had the greatest number of complaints?
SQL: SELECT t1.email_address FROM customers AS t1 JOIN complaints AS t2 ON t1.customer_id  =  t2.customer_id GROUP BY t1.customer_id ORDER BY count(*) LIMIT 1
Database: customer_complaints (tables: products, customers, complaints)
Question: Which products has been complained by the customer who has filed least amount of complaints?
SQL: SELECT DISTINCT t1.product_name FROM products AS t1 JOIN complaints AS t2 ON t1.product_id  =  t2.product_id JOIN customers AS t3 GROUP BY t3.customer_id ORDER BY count(*) LIMIT 1
Database: customer_complaints (tables: products, customers, complaints)
Question: Return the names of products that have had complaints filed by the customer who has filed the fewest complaints.
SQL: SELECT DISTINCT t1.product_name FROM products AS t1 JOIN complaints AS t2 ON t1.product_id  =  t2.product_id JOIN customers AS t3 GROUP BY t3.customer_id ORDER BY count(*) LIMIT 1
Database: customer_complaints (tables: customers, complaints)
Question: What is the phone number of the customer who has filed the most recent complaint?
SQL: SELECT t1.phone_number FROM customers AS t1 JOIN complaints AS t2 ON t1.customer_id  =  t2.customer_id ORDER BY t2.date_complaint_raised DESC LIMIT 1
Database: customer_complaints (tables: customers, complaints)
Question: Return the phone number of the customer who filed the complaint that was raised most recently.
SQL: SELECT t1.phone_number FROM customers AS t1 JOIN complaints AS t2 ON t1.customer_id  =  t2.customer_id ORDER BY t2.date_complaint_raised DESC LIMIT 1
Database: customer_complaints (tables: customers, complaints)
Question: Find the email and phone number of the customers who have never filed a complaint before.
SQL: SELECT email_address ,  phone_number FROM customers WHERE customer_id NOT IN (SELECT customer_id FROM complaints)
Database: customer_complaints (tables: customers, complaints)
Question: What are the emails and phone numbers of custoemrs who have never filed a complaint?
SQL: SELECT email_address ,  phone_number FROM customers WHERE customer_id NOT IN (SELECT customer_id FROM complaints)
Database: customer_complaints (tables: customers, staff)
Question: Find the phone number of all the customers and staff.
SQL: SELECT phone_number FROM customers UNION SELECT phone_number FROM staff
Database: customer_complaints (tables: customers, staff)
Question: What are the phone numbers of all customers and all staff members?
SQL: SELECT phone_number FROM customers UNION SELECT phone_number FROM staff
Database: customer_complaints (tables: products)
Question: What is the description of the product named "Chocolate"?
SQL: SELECT product_description FROM products WHERE product_name  =  "Chocolate"
Database: customer_complaints (tables: products)
Question: Return the description of the product called "Chocolate".
SQL: SELECT product_description FROM products WHERE product_name  =  "Chocolate"
Database: customer_complaints (tables: products)
Question: Find the name and category of the most expensive product.
SQL: SELECT product_name ,  product_category_code FROM products ORDER BY product_price DESC LIMIT 1
Database: customer_complaints (tables: products)
Question: What is the name and category code of the product with the highest price?
SQL: SELECT product_name ,  product_category_code FROM products ORDER BY product_price DESC LIMIT 1
Database: customer_complaints (tables: products, complaints)
Question: Find the prices of products which has never received a single complaint.
SQL: SELECT product_price FROM products WHERE product_id NOT IN (SELECT product_id FROM complaints)
Database: customer_complaints (tables: products, complaints)
Question: What are the prices of products that have never gotten a complaint?
SQL: SELECT product_price FROM products WHERE product_id NOT IN (SELECT product_id FROM complaints)
Database: customer_complaints (tables: products)
Question: What is the average price of the products for each category?
SQL: SELECT avg(product_price) ,  product_category_code FROM products GROUP BY product_category_code
Database: customer_complaints (tables: products)
Question: Return the average price of products that have each category code.
SQL: SELECT avg(product_price) ,  product_category_code FROM products GROUP BY product_category_code
Database: customer_complaints (tables: products, complaints, staff)
Question: Find the last name of the staff member who processed the complaint of the cheapest product.
SQL: SELECT t1.last_name FROM staff AS t1 JOIN complaints AS t2 ON t1.staff_id  =  t2.staff_id JOIN products AS t3 ON t2.product_id  =  t3.product_id ORDER BY t3.product_price LIMIT 1
Database: customer_complaints (tables: products, complaints, staff)
Question: What is the last name of the staff member in charge of the complaint on the product with the lowest price?
SQL: SELECT t1.last_name FROM staff AS t1 JOIN complaints AS t2 ON t1.staff_id  =  t2.staff_id JOIN products AS t3 ON t2.product_id  =  t3.product_id ORDER BY t3.product_price LIMIT 1
Database: customer_complaints (tables: complaints)
Question: Which complaint status has more than 3 records on file?
SQL: SELECT complaint_status_code FROM complaints GROUP BY complaint_status_code HAVING count(*)  >  3
Database: customer_complaints (tables: complaints)
Question: Return complaint status codes have more than 3 corresponding complaints?
SQL: SELECT complaint_status_code FROM complaints GROUP BY complaint_status_code HAVING count(*)  >  3
Database: customer_complaints (tables: staff)
Question: Find the last name of the staff whose email address contains "wrau".
SQL: SELECT last_name FROM staff WHERE email_address LIKE "%wrau%"
Database: customer_complaints (tables: staff)
Question: What are the last names of staff with email addressed containing the substring "wrau"?
SQL: SELECT last_name FROM staff WHERE email_address LIKE "%wrau%"
Database: customer_complaints (tables: customers)
Question: How many customers are there in the customer type with the most customers?
SQL: SELECT count(*) FROM customers GROUP BY customer_type_code ORDER BY count(*) DESC LIMIT 1
Database: customer_complaints (tables: customers)
Question: Count the number of customers that have the customer type that is most common.
SQL: SELECT count(*) FROM customers GROUP BY customer_type_code ORDER BY count(*) DESC LIMIT 1
Database: customer_complaints (tables: complaints, staff)
Question: What is the last name of the staff who has handled the first ever complaint?
SQL: SELECT t1.last_name FROM staff AS t1 JOIN complaints AS t2 ON t1.staff_id  =  t2.staff_id ORDER BY t2.date_complaint_raised LIMIT 1
Database: customer_complaints (tables: complaints, staff)
Question: Return the last name of the staff member who handled the complaint with the earliest date raised.
SQL: SELECT t1.last_name FROM staff AS t1 JOIN complaints AS t2 ON t1.staff_id  =  t2.staff_id ORDER BY t2.date_complaint_raised LIMIT 1
Database: customer_complaints (tables: complaints)
Question: How many distinct complaint type codes are there in the database?
SQL: SELECT count(DISTINCT complaint_type_code) FROM complaints
Database: customer_complaints (tables: complaints)
Question: Count the number of different complaint type codes.
SQL: SELECT count(DISTINCT complaint_type_code) FROM complaints
Database: customer_complaints (tables: customers)
Question: Find the address line 1 and 2 of the customer with email "vbogisich@example.org".
SQL: SELECT address_line_1 ,  address_line_2 FROM customers WHERE email_address  =  "vbogisich@example.org"
Database: customer_complaints (tables: customers)
Question: What are lines 1 and 2 of the addressed of the customer with the email "vbogisich@example.org"?
SQL: SELECT address_line_1 ,  address_line_2 FROM customers WHERE email_address  =  "vbogisich@example.org"
Database: customer_complaints (tables: complaints)
Question: Find the number of complaints with Product Failure type for each complaint status.
SQL: SELECT complaint_status_code ,  count(*) FROM complaints WHERE complaint_type_code  =  "Product Failure" GROUP BY complaint_status_code
Database: customer_complaints (tables: complaints)
Question: Of complaints with the type code "Product Failure", how many had each different status code?
SQL: SELECT complaint_status_code ,  count(*) FROM complaints WHERE complaint_type_code  =  "Product Failure" GROUP BY complaint_status_code
Database: customer_complaints (tables: complaints, staff)
Question: What is first names of the top 5 staff who have handled the greatest number of complaints?
SQL: SELECT t1.first_name FROM staff AS t1 JOIN complaints AS t2 ON t1.staff_id  =  t2.staff_id GROUP BY t2.staff_id ORDER BY count(*) LIMIT 5