target-benchmark/spider-queries huggingface dataset:
Database: e_commerce (tables: customer_payment_methods, customers)
Question: How many customers do not have any payment method?
SQL: SELECT count(*) FROM Customers WHERE customer_id NOT IN ( SELECT customer_id FROM Customer_Payment_Methods )
Database: e_commerce (tables: customer_payment_methods, customers)
Question: How many customers do not have a listed payment method?
SQL: SELECT count(*) FROM Customers WHERE customer_id NOT IN ( SELECT customer_id FROM Customer_Payment_Methods )
Database: e_commerce (tables: orders)
Question: What are all the order status and all the dates of orders?
SQL: SELECT order_status_code ,  date_order_placed FROM Orders
Database: e_commerce (tables: orders)
Question: What are the status codes and dates placed for all of the orders?
SQL: SELECT order_status_code ,  date_order_placed FROM Orders
Database: e_commerce (tables: customers)
Question: List the address, town and county information of the customers who live in the USA.
SQL: SELECT address_line_1 ,  town_city ,  county FROM Customers WHERE Country  =  'USA'
Database: e_commerce (tables: customers)
Question: What are the addresses, towns, and county information for all customers who live in the United States?
SQL: SELECT address_line_1 ,  town_city ,  county FROM Customers WHERE Country  =  'USA'
Database: e_commerce (tables: order_items, orders, products, customers)
Question: List all the pairs of buyer first names and product names.
SQL: SELECT T1.customer_first_name ,  T4.product_name FROM Customers AS T1 JOIN Orders AS T2 ON T1.customer_id  =  T2.customer_id JOIN Order_items AS T3 ON T2.order_id  =  T3.order_id JOIN Products AS T4 ON T3.product_id  =  T4.product_id
Database: e_commerce (tables: order_items, orders, products, customers)
Question: What are the first names of all buyers and what products did they buy? List them in pairs.
SQL: SELECT T1.customer_first_name ,  T4.product_name FROM Customers AS T1 JOIN Orders AS T2 ON T1.customer_id  =  T2.customer_id JOIN Order_items AS T3 ON T2.order_id  =  T3.order_id JOIN Products AS T4 ON T3.product_id  =  T4.product_id
Database: e_commerce (tables: shipment_items)
Question: How many items are shipped?
SQL: SELECT count(*) FROM Shipment_Items
Database: e_commerce (tables: shipment_items)
Question: How many products have been shipped?
SQL: SELECT count(*) FROM Shipment_Items
Database: e_commerce (tables: products)
Question: What is the product average price?
SQL: SELECT avg(product_price) FROM Products
Database: e_commerce (tables: products)
Question: How much do the products cost on average?
SQL: SELECT avg(product_price) FROM Products
Database: e_commerce (tables: order_items, products)
Question: What is the average price of the products being ordered?
SQL: SELECT avg(T1.product_price) FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id
Database: e_commerce (tables: order_items, products)
Question: What is the price of all products being ordered on average?
SQL: SELECT avg(T1.product_price) FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id
Database: e_commerce (tables: customers)
Question: What are the email address, town and county of the customers who are of the least common gender?
SQL: SELECT email_address ,  town_city ,  county FROM Customers WHERE gender_code  =  ( SELECT gender_code FROM Customers GROUP BY gender_code ORDER BY count(*) ASC LIMIT 1 )
Database: e_commerce (tables: customers)
Question: What are the email addresses, cities, and counties listed for all cusomters who are from the gender that orders less often?
SQL: SELECT email_address ,  town_city ,  county FROM Customers WHERE gender_code  =  ( SELECT gender_code FROM Customers GROUP BY gender_code ORDER BY count(*) ASC LIMIT 1 )
Database: e_commerce (tables: orders, customer_payment_methods, customers)
Question: List the order date of the orders who are placed by customers with at least 2 payment methods.
SQL: SELECT date_order_placed FROM Orders WHERE customer_id IN ( SELECT T1.customer_id FROM Customers AS T1 JOIN Customer_Payment_Methods AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id HAVING count(*)  >=  2 )
Database: e_commerce (tables: orders, customer_payment_methods, customers)
Question: What is the date of all orders that have been placed by customers with at least 2 payment methods?
SQL: SELECT date_order_placed FROM Orders WHERE customer_id IN ( SELECT T1.customer_id FROM Customers AS T1 JOIN Customer_Payment_Methods AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id HAVING count(*)  >=  2 )
Database: e_commerce (tables: orders)
Question: What is the most uncommon order status?
SQL: SELECT order_status_code FROM Orders GROUP BY order_status_code ORDER BY count(*) LIMIT 1
Database: e_commerce (tables: orders)
Question: What is the least common order status?
SQL: SELECT order_status_code FROM Orders GROUP BY order_status_code ORDER BY count(*) LIMIT 1
Database: e_commerce (tables: order_items, products)
Question: For all the products sold for more than 3 times, list their id and description.
SQL: SELECT T1.product_id ,  T1.product_description FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id GROUP BY T1.product_id HAVING count(*)  >  3
Database: e_commerce (tables: order_items, products)
Question: For all products sold more than 3 times, what are their ids and descriptions?
SQL: SELECT T1.product_id ,  T1.product_description FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id GROUP BY T1.product_id HAVING count(*)  >  3
Database: e_commerce (tables: shipments, invoices)
Question: List the invoice dates and ids of the invoices causing at least 2 shipments.
SQL: SELECT T1.invoice_date ,  T1.invoice_number FROM Invoices AS T1 JOIN Shipments AS T2 ON T1.invoice_number  =  T2.invoice_number GROUP BY T1.invoice_number HAVING count(*)  >=  2
Database: e_commerce (tables: shipments, invoices)
Question: What are the dates and ids of the invoices that are related to at least 2 shipments?
SQL: SELECT T1.invoice_date ,  T1.invoice_number FROM Invoices AS T1 JOIN Shipments AS T2 ON T1.invoice_number  =  T2.invoice_number GROUP BY T1.invoice_number HAVING count(*)  >=  2
Database: e_commerce (tables: shipments)
Question: what are all shipment tracking numbers and shipment dates?
SQL: SELECT shipment_tracking_number ,  shipment_date FROM Shipments
Database: e_commerce (tables: shipments)
Question: What are the tracking numbers and dates for all shipments listed?
SQL: SELECT shipment_tracking_number ,  shipment_date FROM Shipments
Database: e_commerce (tables: products, products)
Question: What are the color, description and size of the products priced below the maximum price.
SQL: SELECT product_color ,  product_description ,  product_size FROM Products WHERE product_price  <  ( SELECT max(product_price) FROM products )
Database: e_commerce (tables: products)
Question: What are the colors , descriptions , and sizes for all products that are not at the maximum price ?
SQL: select product_color ,  product_description ,  product_size from products where product_price  !=  ( select max(product_price) from products )
Database: bbc_channels (tables: director)
Question: Return the names of directors who are older than the average age.
SQL: SELECT name FROM director WHERE age  >  (SELECT avg(age) FROM director)
Database: bbc_channels (tables: director)
Question: Find the the name of the oldest director.
SQL: SELECT name FROM director ORDER BY age DESC LIMIT 1
Database: bbc_channels (tables: channel)
Question: How many channels have the word 'bbc' in their internet link?
SQL: SELECT count(*) FROM channel WHERE internet LIKE "%bbc%"
Database: bbc_channels (tables: channel)
Question: How many different digital terrestrial channels are there?
SQL: SELECT count(DISTINCT Digital_terrestrial_channel) FROM channel
Database: bbc_channels (tables: program)
Question: List all program titles in the order of starting year. List the most recent one first.
SQL: SELECT title FROM program ORDER BY start_year DESC
Database: bbc_channels (tables: program, director)
Question: Which director is in charge of the most programs?
SQL: SELECT t2.name FROM program AS t1 JOIN director AS t2 ON t1.director_id  =  t2.director_id GROUP BY t1.director_id ORDER BY count(*) DESC LIMIT 1
Database: bbc_channels (tables: program, director)
Question: Find the name and age of the director who is in charge of the most programs?
SQL: SELECT t2.name ,  t2.age FROM program AS t1 JOIN director AS t2 ON t1.director_id  =  t2.director_id GROUP BY t1.director_id ORDER BY count(*) DESC LIMIT 1
Database: bbc_channels (tables: program)
Question: Return the title of the program that began most recently.
SQL: SELECT title FROM program ORDER BY start_year DESC LIMIT 1
Database: bbc_channels (tables: channel, program)
Question: Find the name and website link of the channels that have more than one program.
SQL: SELECT t1.name ,  t1.internet FROM channel AS t1 JOIN program AS t2 ON t1.channel_id  =  t2.channel_id GROUP BY t1.channel_id HAVING count(*)  >  1
Database: bbc_channels (tables: channel, program)
Question: Find the number of programs for each channel. Return the name of each channel as well.
SQL: SELECT t1.name ,  count(*) FROM channel AS t1 JOIN program AS t2 ON t1.channel_id  =  t2.channel_id GROUP BY t1.channel_id
Database: bbc_channels (tables: channel, program)
Question: Find the number of channels that do not run any program.
SQL: SELECT count(*) FROM channel WHERE channel_id NOT IN (SELECT channel_id FROM program)
Database: bbc_channels (tables: program, director)
Question: What is the name of the director who is in the "Dracula" program?
SQL: SELECT t2.name FROM program AS t1 JOIN director AS t2 ON t1.director_id  =  t2.director_id WHERE t1.title  =  'Dracula'
Database: bbc_channels (tables: channel, director_admin)
Question: Find the name and internet web of the channel that is directed by the most directors.
SQL: SELECT t1.name ,  t1.internet FROM channel AS t1 JOIN director_admin AS t2 ON t1.channel_id  =  t2.channel_id GROUP BY t1.channel_id ORDER BY count(*) DESC LIMIT 1
Database: bbc_channels (tables: director)
Question: Find the name of the directors whose age is between 30 and 60.
SQL: SELECT name FROM director WHERE age BETWEEN 30 AND 60
Database: bbc_channels (tables: channel, director_admin, director)
Question: give me the name of channels that have both a director younger than 40 and a director older than 60.
SQL: SELECT t1.name FROM channel AS t1 JOIN director_admin AS t2 ON t1.channel_id  =  t2.channel_id JOIN director AS t3 ON t2.director_id  =  t3.director_id WHERE t3.age  <  40 INTERSECT SELECT t1.name FROM channel AS t1 JOIN director_admin AS t2 ON t1.channel_id  =  t2.channel_id JOIN director AS t3 ON t2.director_id  =  t3.director_id WHERE t3.age  >  60
Database: bbc_channels (tables: channel, director_admin, director)
Question: Find the id and name of the channel that is not directed by Hank Baskett.
SQL: SELECT t1.name ,  t1.channel_id FROM channel AS t1 JOIN director_admin AS t2 ON t1.channel_id  =  t2.channel_id JOIN director AS t3 ON t2.director_id  =  t3.director_id WHERE t3.name != "Hank Baskett"
Database: tv_shows (tables: radio)
Question: How many radios are there?
SQL: SELECT count(*) FROM radio
Database: tv_shows (tables: radio)
Question: List the transmitters of radios in ascending order of erp kw .
SQL: select transmitter from radio order by erp_kw asc
Database: tv_shows (tables: tv_show)
Question: What are the names and original air dates of tv shows?
SQL: SELECT tv_show_name ,  Original_Airdate FROM tv_show
Database: tv_shows (tables: city_channel)
Question: List the station names of city channels whose affiliation is not "ABC".
SQL: SELECT Station_name FROM city_channel WHERE Affiliation != "ABC"
Database: tv_shows (tables: radio)
Question: Show the transmitters of radios whose ERP is bigger than 150 or smaller than 30.
SQL: SELECT Transmitter FROM radio WHERE ERP_kW  >  150 OR ERP_kW  <  30
Database: tv_shows (tables: radio)
Question: What is the transmitter of the radio with the largest ERP_kW?
SQL: SELECT Transmitter FROM radio ORDER BY ERP_kW DESC LIMIT 1
Database: tv_shows (tables: radio)
Question: What is the average ERP across all radios?
SQL: SELECT avg(ERP_kW) FROM radio
Database: tv_shows (tables: city_channel)
Question: Show the different affiliations of city channels and the number of city channels with each affiliation.
SQL: SELECT Affiliation ,  COUNT(*) FROM city_channel GROUP BY Affiliation
Database: tv_shows (tables: city_channel)
Question: Please show the most common affiliation for city channels.
SQL: SELECT Affiliation FROM city_channel GROUP BY Affiliation ORDER BY COUNT(*) DESC LIMIT 1
Database: tv_shows (tables: city_channel)
Question: List the affiliations shared by more than three city channels.
SQL: SELECT Affiliation FROM city_channel GROUP BY Affiliation HAVING COUNT(*)  >  3
Database: tv_shows (tables: city_channel)
Question: Show the cities and station names of city channels in ascending alphabetical order of station name.
SQL: SELECT City ,  Station_name FROM city_channel ORDER BY Station_name ASC
Database: tv_shows (tables: city_channel, radio, city_channel_radio)
Question: Show the transmitters of radios and the cities of the channels they are associated with.
SQL: SELECT T3.Transmitter ,  T2.City FROM city_channel_radio AS T1 JOIN city_channel AS T2 ON T1.City_channel_ID  =  T2.ID JOIN radio AS T3 ON T1.Radio_ID  =  T3.Radio_ID
Database: tv_shows (tables: city_channel, radio, city_channel_radio)
Question: Show the transmitters of radios and the station names of the channels they are associated with in descending order of the ERP of the radios.
SQL: SELECT T3.Transmitter ,  T2.Station_name FROM city_channel_radio AS T1 JOIN city_channel AS T2 ON T1.City_channel_ID  =  T2.ID JOIN radio AS T3 ON T1.Radio_ID  =  T3.Radio_ID ORDER BY T3.ERP_kW DESC
Database: tv_shows (tables: radio, city_channel_radio)
Question: Show the transmitters of the radios and the number of city channels they are associated with.
SQL: SELECT T2.Transmitter ,  COUNT(*) FROM city_channel_radio AS T1 JOIN radio AS T2 ON T1.Radio_ID  =  T2.Radio_ID GROUP BY T2.Transmitter
Database: tv_shows (tables: radio, city_channel_radio)
Question: Show the distinct transmitters of radios that are not associated with any city channel.
SQL: SELECT Transmitter FROM radio WHERE Radio_ID NOT IN (SELECT Radio_ID FROM city_channel_radio)
Database: vehicle_driver (tables: vehicle)
Question: What is the model of the vehicle with maximum top speed whose power is higher than 6000?
SQL: SELECT model FROM vehicle WHERE power  >  6000 ORDER BY top_speed DESC LIMIT 1
Database: vehicle_driver (tables: vehicle)
Question: Of vehicles with power over 6000, return the model of the vehicle with the greatest top speed.
SQL: SELECT model FROM vehicle WHERE power  >  6000 ORDER BY top_speed DESC LIMIT 1
Database: vehicle_driver (tables: driver)
Question: What are the names of the drivers who are citizens of the 'United States'?
SQL: SELECT name FROM driver WHERE citizenship  =  'United States'
Database: vehicle_driver (tables: driver)
Question: Return the names of drivers with citizenship from the United States.
SQL: SELECT name FROM driver WHERE citizenship  =  'United States'
Database: vehicle_driver (tables: vehicle_driver)
Question: How many vehicles has a driver driven at most, and what is the driver id of the driver who has driven this many vehicles?
SQL: SELECT count(*) ,  driver_id FROM vehicle_driver GROUP BY driver_id ORDER BY count(*) DESC LIMIT 1
Database: vehicle_driver (tables: vehicle_driver)
Question: What is the id of the driver who has driven the most vehicles, and how many vehicles is this?
SQL: SELECT count(*) ,  driver_id FROM vehicle_driver GROUP BY driver_id ORDER BY count(*) DESC LIMIT 1
Database: vehicle_driver (tables: vehicle)
Question: What is the maximum and average power for the vehicles manufactured by 'Zhuzhou'?
SQL: SELECT max(power) ,  avg(power) FROM vehicle WHERE builder  =  'Zhuzhou'
Database: vehicle_driver (tables: vehicle)
Question: Return the maximum and average power for the vehicles built by Zhuzhou.
SQL: SELECT max(power) ,  avg(power) FROM vehicle WHERE builder  =  'Zhuzhou'
Database: vehicle_driver (tables: vehicle_driver)
Question: What is the id of the vehicle driven for the least times for the vehicles ever used?
SQL: SELECT vehicle_id FROM vehicle_driver GROUP BY vehicle_id ORDER BY count(*) ASC LIMIT 1
Database: vehicle_driver (tables: vehicle_driver)
Question: Return the id of the vehicle that has been driven the fewest times.
SQL: SELECT vehicle_id FROM vehicle_driver GROUP BY vehicle_id ORDER BY count(*) ASC LIMIT 1
Database: vehicle_driver (tables: vehicle)
Question: What is the top speed and power of the vehicle manufactured in the year of 1996?
SQL: SELECT top_speed ,  power FROM vehicle WHERE build_year  =  1996
Database: vehicle_driver (tables: vehicle)
Question: Return the top speed and power of the vehicle that was built in the year 1996.
SQL: SELECT top_speed ,  power FROM vehicle WHERE build_year  =  1996
Database: vehicle_driver (tables: vehicle)
Question: What are the build year, model name and builder of the vehicles?
SQL: SELECT build_year ,  model ,  builder FROM vehicle
Database: vehicle_driver (tables: vehicle)
Question: Give the build year, model, and builder of each vehicle.
SQL: SELECT build_year ,  model ,  builder FROM vehicle
Database: vehicle_driver (tables: vehicle, vehicle_driver)
Question: How many drivers have driven vehicles built in 2012?
SQL: SELECT count(DISTINCT T1.driver_id) FROM vehicle_driver AS T1 JOIN vehicle AS T2 ON T1.vehicle_id  =  T2.vehicle_id WHERE T2.build_year  =  2012
Database: vehicle_driver (tables: vehicle, vehicle_driver)
Question: Count the number of different drivers who have driven vehicles built in 2012.
SQL: SELECT count(DISTINCT T1.driver_id) FROM vehicle_driver AS T1 JOIN vehicle AS T2 ON T1.vehicle_id  =  T2.vehicle_id WHERE T2.build_year  =  2012
Database: vehicle_driver (tables: driver)
Question: How many drivers have raced in 'NASCAR'?
SQL: SELECT count(*) FROM driver WHERE Racing_Series  =  'NASCAR'
Database: vehicle_driver (tables: driver)
Question: Count the number of drivers who have raced in NASCAR.
SQL: SELECT count(*) FROM driver WHERE Racing_Series  =  'NASCAR'
Database: vehicle_driver (tables: vehicle)
Question: What is the average top speed of vehicles?
SQL: SELECT avg(top_speed) FROM vehicle
Database: vehicle_driver (tables: vehicle)
Question: Return the average top speed across all vehicles.
SQL: SELECT avg(top_speed) FROM vehicle
Database: vehicle_driver (tables: vehicle, driver, vehicle_driver)
Question: What are the distinct driver names who have driven vehicles with power more than 5000 ?
SQL: select distinct t1.name from driver as t1 join vehicle_driver as t2 on t1.driver_id  =  t2.driver_id join vehicle as t3 on t2.vehicle_id  =  t3.vehicle_id where t3.power  >  5000
Database: vehicle_driver (tables: vehicle, driver, vehicle_driver)
Question: Return the names of drivers who have driven vehicles with power over 5000.
SQL: SELECT DISTINCT T1.Name FROM driver AS T1 JOIN vehicle_driver AS T2 ON T1.driver_id  =  T2.driver_id JOIN vehicle AS T3 ON T2.vehicle_id  =  T3.vehicle_id WHERE T3.power  >  5000
Database: vehicle_driver (tables: vehicle)
Question: Which car models have total production larger than 100 or top speed higher than 150?
SQL: SELECT model FROM vehicle WHERE total_production  >  100 OR top_speed  >  150
Database: vehicle_driver (tables: vehicle)
Question: Give the models of cars that have a total production of over 100 or a top speed over 150.
SQL: SELECT model FROM vehicle WHERE total_production  >  100 OR top_speed  >  150
Database: vehicle_driver (tables: vehicle)
Question: What are the model names and build year of the cars with 'DJ' in its model name?
SQL: SELECT model ,  build_year FROM vehicle WHERE model LIKE '%DJ%'
Database: vehicle_driver (tables: vehicle)
Question: Return the model and build year of cars that include "DJ" in their model names.
SQL: SELECT model ,  build_year FROM vehicle WHERE model LIKE '%DJ%'
Database: vehicle_driver (tables: vehicle, vehicle_driver)
Question: What are the models which have not been driven by any drivers?
SQL: SELECT model FROM vehicle EXCEPT SELECT T1.model FROM vehicle AS T1 JOIN vehicle_driver AS T2 ON T1.vehicle_id  =  T2.vehicle_id
Database: vehicle_driver (tables: vehicle, vehicle_driver)
Question: Return the models of vehicles that have never been driven.
SQL: SELECT model FROM vehicle EXCEPT SELECT T1.model FROM vehicle AS T1 JOIN vehicle_driver AS T2 ON T1.vehicle_id  =  T2.vehicle_id
Database: vehicle_driver (tables: vehicle, vehicle_driver)
Question: What are the vehicle ids and models of the vehicle which have been driven by two drivers or been manufactured by 'Ziyang'.
SQL: SELECT T1.vehicle_id ,  T1.model FROM vehicle AS T1 JOIN vehicle_driver AS T2 ON T1.vehicle_id  =  T2.vehicle_id GROUP BY T2.vehicle_id HAVING count(*)  =  2 OR T1.builder  =  'Ziyang'
Database: vehicle_driver (tables: vehicle, vehicle_driver)
Question: Return the ids and models of vehicles that have been driven by exactly two drivers or built by Ziyang.
SQL: SELECT T1.vehicle_id ,  T1.model FROM vehicle AS T1 JOIN vehicle_driver AS T2 ON T1.vehicle_id  =  T2.vehicle_id GROUP BY T2.vehicle_id HAVING count(*)  =  2 OR T1.builder  =  'Ziyang'
Database: vehicle_driver (tables: vehicle, driver, vehicle_driver)
Question: What are the vehicle ids and models which have been driven by more than 2 drivers or been driven by the driver named 'Jeff Gordon'?
SQL: SELECT T1.vehicle_id ,  T1.model FROM vehicle AS T1 JOIN vehicle_driver AS T2 ON T1.vehicle_id  =  T2.vehicle_id JOIN driver AS T3 ON T2.driver_id  =  T3.driver_id WHERE T3.name  =  'Jeff Gordon' UNION SELECT T1.vehicle_id ,  T1.model FROM vehicle AS T1 JOIN vehicle_driver AS T2 ON T1.vehicle_id  =  T2.vehicle_id GROUP BY T2.vehicle_id HAVING count(*)  >  2
Database: vehicle_driver (tables: vehicle, driver, vehicle_driver)
Question: Return the ids and models of vehicles that have been driven by more than 2 drivers or been driven by the Jeff Gordon.
SQL: SELECT T1.vehicle_id ,  T1.model FROM vehicle AS T1 JOIN vehicle_driver AS T2 ON T1.vehicle_id  =  T2.vehicle_id JOIN driver AS T3 ON T2.driver_id  =  T3.driver_id WHERE T3.name  =  'Jeff Gordon' UNION SELECT T1.vehicle_id ,  T1.model FROM vehicle AS T1 JOIN vehicle_driver AS T2 ON T1.vehicle_id  =  T2.vehicle_id GROUP BY T2.vehicle_id HAVING count(*)  >  2
Database: vehicle_driver (tables: vehicle)
Question: How many vehicles have maximum top speed?
SQL: SELECT count(*) FROM vehicle WHERE top_speed  =  (SELECT max(top_speed) FROM vehicle)
Database: vehicle_driver (tables: vehicle)
Question: Count the number of vehicles that have a top speed equal to the maximum across all vehicles.
SQL: SELECT count(*) FROM vehicle WHERE top_speed  =  (SELECT max(top_speed) FROM vehicle)
Database: vehicle_driver (tables: driver)
Question: Show all driver names in the alphabetical order.
SQL: SELECT name FROM driver ORDER BY name
Database: vehicle_driver (tables: driver)
Question: What are the names of drivers, returned in alphbetical order?
SQL: SELECT name FROM driver ORDER BY name
Database: vehicle_driver (tables: driver)
Question: How many drivers have been racing in each racing series?
SQL: SELECT count(*) ,  racing_series FROM driver GROUP BY racing_series
Database: vehicle_driver (tables: driver)
Question: Count the number of drivers that have raced in each series.
SQL: SELECT count(*) ,  racing_series FROM driver GROUP BY racing_series
Database: vehicle_driver (tables: vehicle, driver, vehicle_driver)
Question: What are the name and citizenship of the drivers who have driven the vehicle model 'DJ1'?
SQL: SELECT T1.name ,  T1.citizenship FROM driver AS T1 JOIN vehicle_driver AS T2 ON T1.driver_id  =  T2.driver_id JOIN vehicle AS T3 ON T2.vehicle_id  =  T3.vehicle_id WHERE T3.model  =  'DJ1'