target-benchmark/spider-queries huggingface dataset:
Database: flight_4 (tables: airports)
Question: What are the names of all airports in Cuba or Argentina?
SQL: SELECT name FROM airports WHERE country  =  'Cuba' OR country  =  'Argentina'
Database: flight_4 (tables: airlines)
Question: Find the country of the airlines whose name starts with 'Orbit'.
SQL: SELECT country FROM airlines WHERE name LIKE 'Orbit%'
Database: flight_4 (tables: airlines)
Question: What are the countries of all airlines whose names start with Orbit?
SQL: SELECT country FROM airlines WHERE name LIKE 'Orbit%'
Database: flight_4 (tables: airports)
Question: Find the name of airports whose altitude is between -50 and 50.
SQL: SELECT name FROM airports WHERE elevation BETWEEN -50 AND 50
Database: flight_4 (tables: airports)
Question: What are the names of all airports whose elevation is between -50 and 50?
SQL: SELECT name FROM airports WHERE elevation BETWEEN -50 AND 50
Database: flight_4 (tables: airports)
Question: Which country is the airport that has the highest altitude located in?
SQL: SELECT country FROM airports ORDER BY elevation DESC LIMIT 1
Database: flight_4 (tables: airports)
Question: What is the country of the airport with the highest elevation?
SQL: SELECT country FROM airports ORDER BY elevation DESC LIMIT 1
Database: flight_4 (tables: airports)
Question: Find the number of airports whose name contain the word 'International'.
SQL: SELECT count(*) FROM airports WHERE name LIKE '%International%'
Database: flight_4 (tables: airports)
Question: How many airports' names have the word Interanation in them?
SQL: SELECT count(*) FROM airports WHERE name LIKE '%International%'
Database: flight_4 (tables: airports)
Question: How many different cities do have some airport in the country of Greenland?
SQL: SELECT count(DISTINCT city) FROM airports WHERE country  =  'Greenland'
Database: flight_4 (tables: airports)
Question: In how many cities are there airports in the country of Greenland?
SQL: SELECT count(DISTINCT city) FROM airports WHERE country  =  'Greenland'
Database: flight_4 (tables: routes, airlines)
Question: Find the number of routes operated by American Airlines.
SQL: SELECT count(*) FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid WHERE T1.name  =  'American Airlines'
Database: flight_4 (tables: routes, airlines)
Question: How many routes does American Airlines operate?
SQL: SELECT count(*) FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid WHERE T1.name  =  'American Airlines'
Database: flight_4 (tables: airports, routes)
Question: Find the number of routes whose destination airports are in Canada.
SQL: SELECT count(*) FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.dst_apid WHERE country  =  'Canada'
Database: flight_4 (tables: airports, routes)
Question: How many routes end in a Canadian airport?
SQL: SELECT count(*) FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.dst_apid WHERE country  =  'Canada'
Database: flight_4 (tables: airports)
Question: Find the name, city, and country of the airport that has the lowest altitude.
SQL: SELECT name ,  city ,  country FROM airports ORDER BY elevation LIMIT 1
Database: flight_4 (tables: airports)
Question: What is the name, city, and country of the airport with the lowest altitude?
SQL: SELECT name ,  city ,  country FROM airports ORDER BY elevation LIMIT 1
Database: flight_4 (tables: airports)
Question: Find the name, city, and country of the airport that has the highest latitude.
SQL: SELECT name ,  city ,  country FROM airports ORDER BY elevation DESC LIMIT 1
Database: flight_4 (tables: airports)
Question: What is the name, city, and country of the airport with the highest elevation?
SQL: SELECT name ,  city ,  country FROM airports ORDER BY elevation DESC LIMIT 1
Database: flight_4 (tables: airports, routes)
Question: Find the name and city of the airport which is the destination of the most number of routes.
SQL: SELECT T1.name ,  T1.city ,  T2.dst_apid FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.dst_apid GROUP BY T2.dst_apid ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: airports, routes)
Question: What is the name and city of the airport that the most routes end at?
SQL: SELECT T1.name ,  T1.city ,  T2.dst_apid FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.dst_apid GROUP BY T2.dst_apid ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: routes, airlines)
Question: Find the names of the top 10 airlines that operate the most number of routes.
SQL: SELECT T1.name ,  T2.alid FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid GROUP BY T2.alid ORDER BY count(*) DESC LIMIT 10
Database: flight_4 (tables: routes, airlines)
Question: For the airline ids with the top 10 most routes operated, what are their names?
SQL: SELECT T1.name ,  T2.alid FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid GROUP BY T2.alid ORDER BY count(*) DESC LIMIT 10
Database: flight_4 (tables: airports, routes)
Question: Find the name and city of the airport which is the source for the most number of flight routes.
SQL: SELECT T1.name ,  T1.city ,  T2.src_apid FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.src_apid GROUP BY T2.src_apid ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: airports, routes)
Question: What is the name and city of the airport from most of the routes start?
SQL: SELECT T1.name ,  T1.city ,  T2.src_apid FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.src_apid GROUP BY T2.src_apid ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: routes, airlines)
Question: Find the number of different airports which are the destinations of the American Airlines.
SQL: SELECT count(DISTINCT dst_apid) FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid WHERE T1.name  =  'American Airlines'
Database: flight_4 (tables: routes, airlines)
Question: What is the number of different different airports that are destinations for American Airlines?
SQL: SELECT count(DISTINCT dst_apid) FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid WHERE T1.name  =  'American Airlines'
Database: flight_4 (tables: airlines)
Question: Which countries has the most number of airlines?
SQL: SELECT country FROM airlines GROUP BY country ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: airlines)
Question: What is the name of the country with the most number of home airlines?
SQL: SELECT country FROM airlines GROUP BY country ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: airlines)
Question: Which countries has the most number of airlines whose active status is 'Y'?
SQL: SELECT country FROM airlines WHERE active  =  'Y' GROUP BY country ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: airlines)
Question: What are the countries with the most airlines whose active status is Y?
SQL: SELECT country FROM airlines WHERE active  =  'Y' GROUP BY country ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: airlines)
Question: List all countries and their number of airlines in the descending order of number of airlines.
SQL: SELECT country ,  count(*) FROM airlines GROUP BY country ORDER BY count(*) DESC
Database: flight_4 (tables: airlines)
Question: How many airlines operate out of each country in descending order?
SQL: SELECT country ,  count(*) FROM airlines GROUP BY country ORDER BY count(*) DESC
Database: flight_4 (tables: airports)
Question: How many airports are there per country? Order the countries by decreasing number of airports.
SQL: SELECT count(*) ,  country FROM airports GROUP BY country ORDER BY count(*) DESC
Database: flight_4 (tables: airports)
Question: What is the number of airports per country, ordered from most to least?
SQL: SELECT count(*) ,  country FROM airports GROUP BY country ORDER BY count(*) DESC
Database: flight_4 (tables: airports)
Question: How many airports are there per city in the United States? Order the cities by decreasing number of airports.
SQL: SELECT count(*) ,  city FROM airports WHERE country  =  'United States' GROUP BY city ORDER BY count(*) DESC
Database: flight_4 (tables: airports)
Question: How many airports are there per city in the US ordered from most to least?
SQL: SELECT count(*) ,  city FROM airports WHERE country  =  'United States' GROUP BY city ORDER BY count(*) DESC
Database: flight_4 (tables: airports)
Question: Return the cities with more than 3 airports in the United States.
SQL: SELECT city FROM airports WHERE country  =  'United States' GROUP BY city HAVING count(*)  >  3
Database: flight_4 (tables: airports)
Question: What is the number of cities in the United States with more than 3 airports?
SQL: SELECT city FROM airports WHERE country  =  'United States' GROUP BY city HAVING count(*)  >  3
Database: flight_4 (tables: airports)
Question: How many cities are there that have more than 3 airports?
SQL: SELECT count(*) FROM (SELECT city FROM airports GROUP BY city HAVING count(*)  >  3)
Database: flight_4 (tables: airports)
Question: What is the count of cities with more than 3 airports?
SQL: SELECT count(*) FROM (SELECT city FROM airports GROUP BY city HAVING count(*)  >  3)
Database: flight_4 (tables: airports)
Question: List the cities which have more than one airport and number of airports.
SQL: SELECT city ,  count(*) FROM airports GROUP BY city HAVING count(*)  >  1
Database: flight_4 (tables: airports)
Question: What are the names of all cities with more than one airport and how many airports do they have?
SQL: SELECT city ,  count(*) FROM airports GROUP BY city HAVING count(*)  >  1
Database: flight_4 (tables: airports)
Question: List the cities which have more than 2 airports sorted by the number of airports.
SQL: SELECT city FROM airports GROUP BY city HAVING count(*)  >  2 ORDER BY count(*)
Database: flight_4 (tables: airports)
Question: What are the cities that have more than 2 airports sorted by number of airports?
SQL: SELECT city FROM airports GROUP BY city HAVING count(*)  >  2 ORDER BY count(*)
Database: flight_4 (tables: airports, routes)
Question: Find the number of routes for each source airport and the airport name.
SQL: SELECT count(*) ,  T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.src_apid GROUP BY T1.name
Database: flight_4 (tables: airports, routes)
Question: For each airport name, how many routes start at that airport?
SQL: SELECT count(*) ,  T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.src_apid GROUP BY T1.name
Database: flight_4 (tables: airports, routes)
Question: Find the number of routes and airport name for each source airport, order the results by decreasing number of routes.
SQL: SELECT count(*) ,  T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.src_apid GROUP BY T1.name ORDER BY count(*) DESC
Database: flight_4 (tables: airports, routes)
Question: For each  airport name, how many routes start at that airport, ordered from most to least?
SQL: SELECT count(*) ,  T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.src_apid GROUP BY T1.name ORDER BY count(*) DESC
Database: flight_4 (tables: airports)
Question: Find the average elevation of all airports for each country.
SQL: SELECT avg(elevation) ,  country FROM airports GROUP BY country
Database: flight_4 (tables: airports)
Question: For each country, what is the average elevation of that country's airports?
SQL: SELECT avg(elevation) ,  country FROM airports GROUP BY country
Database: flight_4 (tables: airports)
Question: Find the cities which have exactly two airports.
SQL: SELECT city FROM airports GROUP BY city HAVING count(*)  =  2
Database: flight_4 (tables: airports)
Question: What are the cities with exactly two airports?
SQL: SELECT city FROM airports GROUP BY city HAVING count(*)  =  2
Database: flight_4 (tables: routes, airlines)
Question: For each country and airline name, how many routes are there?
SQL: SELECT T1.country ,  T1.name ,  count(*) FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid GROUP BY T1.country ,  T1.name
Database: flight_4 (tables: routes, airlines)
Question: What is the total number of routes for each country and airline in that country?
SQL: SELECT T1.country ,  T1.name ,  count(*) FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid GROUP BY T1.country ,  T1.name
Database: flight_4 (tables: airports, routes)
Question: Find the number of routes with destination airports in Italy.
SQL: SELECT count(*) FROM routes AS T1 JOIN airports AS T2 ON T1.dst_apid  =  T2.apid WHERE T2.country  =  'Italy'
Database: flight_4 (tables: airports, routes)
Question: What is the number of routes whose destinations are Italian airports?
SQL: SELECT count(*) FROM routes AS T1 JOIN airports AS T2 ON T1.dst_apid  =  T2.apid WHERE T2.country  =  'Italy'
Database: flight_4 (tables: airports, routes, airlines)
Question: Return the number of routes with destination airport in Italy operated by the airline with name 'American Airlines'.
SQL: SELECT count(*) FROM routes AS T1 JOIN airports AS T2 ON T1.dst_apid  =  T2.apid JOIN airlines AS T3 ON T1.alid  =  T3.alid WHERE T2.country  =  'Italy' AND T3.name  =  'American Airlines'
Database: flight_4 (tables: airports, routes, airlines)
Question: What is the number of routes operated by the airline American Airlines whose destinations are in Italy?
SQL: SELECT count(*) FROM routes AS T1 JOIN airports AS T2 ON T1.dst_apid  =  T2.apid JOIN airlines AS T3 ON T1.alid  =  T3.alid WHERE T2.country  =  'Italy' AND T3.name  =  'American Airlines'
Database: flight_4 (tables: airports, routes)
Question: Find the number of routes that have destination John F Kennedy International Airport.
SQL: SELECT count(*) FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.dst_apid WHERE T1.name  =  'John F Kennedy International Airport'
Database: flight_4 (tables: airports, routes)
Question: What is the number of routes that end at John F Kennedy International Airport?
SQL: SELECT count(*) FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.dst_apid WHERE T1.name  =  'John F Kennedy International Airport'
Database: flight_4 (tables: airports, routes)
Question: Find the number of routes from the United States to Canada.
SQL: SELECT count(*) FROM routes WHERE dst_apid IN (SELECT apid FROM airports WHERE country  =  'Canada') AND src_apid IN (SELECT apid FROM airports WHERE country  =  'United States')
Database: flight_4 (tables: airports, routes)
Question: How many routes go from the United States to Canada?
SQL: SELECT count(*) FROM routes WHERE dst_apid IN (SELECT apid FROM airports WHERE country  =  'Canada') AND src_apid IN (SELECT apid FROM airports WHERE country  =  'United States')
Database: flight_4 (tables: airports, routes)
Question: Find the id of routes whose source and destination airports are in the United States.
SQL: SELECT rid FROM routes WHERE dst_apid IN (SELECT apid FROM airports WHERE country  =  'United States') AND src_apid IN (SELECT apid FROM airports WHERE country  =  'United States')
Database: flight_4 (tables: airports, routes)
Question: What is the id of the routes whose source and destination airports are in the United States?
SQL: SELECT rid FROM routes WHERE dst_apid IN (SELECT apid FROM airports WHERE country  =  'United States') AND src_apid IN (SELECT apid FROM airports WHERE country  =  'United States')
Database: flight_4 (tables: routes, airlines)
Question: Find the name of airline which runs the most number of routes.
SQL: SELECT T1.name FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid GROUP BY T1.name ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: routes, airlines)
Question: What is the name of the airline with the most routes?
SQL: SELECT T1.name FROM airlines AS T1 JOIN routes AS T2 ON T1.alid  =  T2.alid GROUP BY T1.name ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: airports, routes)
Question: Find the busiest source airport that runs most number of routes in China.
SQL: SELECT T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.src_apid WHERE T1.country  =  'China' GROUP BY T1.name ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: airports, routes)
Question: What is the name of the airport with the most number of routes that start in China?
SQL: SELECT T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.src_apid WHERE T1.country  =  'China' GROUP BY T1.name ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: airports, routes)
Question: Find the busiest destination airport that runs most number of routes in China.
SQL: SELECT T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.dst_apid WHERE T1.country  =  'China' GROUP BY T1.name ORDER BY count(*) DESC LIMIT 1
Database: flight_4 (tables: airports, routes)
Question: What is the name of the airport that is the destination of the most number of routes that start in China?
SQL: SELECT T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid  =  T2.dst_apid WHERE T1.country  =  'China' GROUP BY T1.name ORDER BY count(*) DESC LIMIT 1
Database: tracking_orders (tables: orders)
Question: What is the id of the most recent order?
SQL: SELECT order_id FROM orders ORDER BY date_order_placed DESC LIMIT 1
Database: tracking_orders (tables: orders)
Question: Find the id of the order made most recently.
SQL: SELECT order_id FROM orders ORDER BY date_order_placed DESC LIMIT 1
Database: tracking_orders (tables: orders)
Question: what are the order id and customer id of the oldest order?
SQL: SELECT order_id ,  customer_id FROM orders ORDER BY date_order_placed LIMIT 1
Database: tracking_orders (tables: orders)
Question: Find the order id and customer id associated with the oldest order.
SQL: SELECT order_id ,  customer_id FROM orders ORDER BY date_order_placed LIMIT 1
Database: tracking_orders (tables: shipments)
Question: Find the id of the order whose shipment tracking number is "3452".
SQL: SELECT order_id FROM shipments WHERE shipment_tracking_number = "3452"
Database: tracking_orders (tables: shipments)
Question: Which order's shipment tracking number is "3452"? Give me the id of the order.
SQL: SELECT order_id FROM shipments WHERE shipment_tracking_number = "3452"
Database: tracking_orders (tables: order_items)
Question: Find the ids of all the order items whose product id is 11.
SQL: SELECT order_item_id FROM order_items WHERE product_id = 11
Database: tracking_orders (tables: order_items)
Question: Find all the order items whose product id is 11. What are the order item ids?
SQL: SELECT order_item_id FROM order_items WHERE product_id = 11
Database: tracking_orders (tables: orders, customers)
Question: List the name of all the distinct customers who have orders with status "Packing".
SQL: SELECT DISTINCT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.order_status = "Packing"
Database: tracking_orders (tables: orders, customers)
Question: Which customers have orders with status "Packing"? Give me the customer names.
SQL: SELECT DISTINCT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.order_status = "Packing"
Database: tracking_orders (tables: orders, customers)
Question: Find the details of all the distinct customers who have orders with status "On Road".
SQL: SELECT DISTINCT T1.customer_details FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.order_status = "On Road"
Database: tracking_orders (tables: orders, customers)
Question: What are the distinct customers who have orders with status "On Road"? Give me the customer details?
SQL: SELECT DISTINCT T1.customer_details FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.order_status = "On Road"
Database: tracking_orders (tables: orders, customers)
Question: What is the name of the customer who has the most orders?
SQL: SELECT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_orders (tables: orders, customers)
Question: Which customer made the most orders? Find the customer name.
SQL: SELECT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_orders (tables: orders, customers)
Question: What is the customer id of the customer who has the most orders?
SQL: SELECT T1.customer_id FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_orders (tables: orders, customers)
Question: Find the id of the customer who made the most orders.
SQL: SELECT T1.customer_id FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_orders (tables: orders, customers)
Question: Give me a list of id and status of orders which belong to the customer named "Jeramie".
SQL: SELECT T2.order_id ,  T2.order_status FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T1.customer_name = "Jeramie"
Database: tracking_orders (tables: orders, customers)
Question: Which orders are made by the customer named "Jeramie"? Give me the order ids and status.
SQL: SELECT T2.order_id ,  T2.order_status FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T1.customer_name = "Jeramie"
Database: tracking_orders (tables: orders, customers)
Question: Find the dates of orders which belong to the customer named "Jeramie".
SQL: SELECT T2.date_order_placed FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T1.customer_name = "Jeramie"
Database: tracking_orders (tables: orders, customers)
Question: What are the dates of the orders made by the customer named "Jeramie"?
SQL: SELECT T2.date_order_placed FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T1.customer_name = "Jeramie"
Database: tracking_orders (tables: orders, customers)
Question: Give me the names of customers who have placed orders between 2009-01-01 and 2010-01-01.
SQL: SELECT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.date_order_placed >= "2009-01-01" AND T2.date_order_placed <= "2010-01-01"
Database: tracking_orders (tables: orders, customers)
Question: Which customers made orders between 2009-01-01 and 2010-01-01? Find their names.
SQL: SELECT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.date_order_placed >= "2009-01-01" AND T2.date_order_placed <= "2010-01-01"
Database: tracking_orders (tables: orders, order_items)
Question: Give me a list of distinct product ids from orders placed between 1975-01-01 and 1976-01-01?
SQL: SELECT DISTINCT T2.product_id FROM orders AS T1 JOIN order_items AS T2 ON T1.order_id = T2.order_id WHERE T1.date_order_placed >= "1975-01-01" AND T1.date_order_placed <= "1976-01-01"
Database: tracking_orders (tables: orders, order_items)
Question: What are the distinct ids of products ordered between 1975-01-01 and 1976-01-01??
SQL: SELECT DISTINCT T2.product_id FROM orders AS T1 JOIN order_items AS T2 ON T1.order_id = T2.order_id WHERE T1.date_order_placed >= "1975-01-01" AND T1.date_order_placed <= "1976-01-01"
Database: tracking_orders (tables: orders, customers)
Question: Find the names of the customers who have order status both "On Road" and "Shipped".
SQL: SELECT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.order_status = "On Road" INTERSECT SELECT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.order_status = "Shipped"
Database: tracking_orders (tables: orders, customers)
Question: Which customers have both "On Road" and "Shipped" as order status? List the customer names.
SQL: SELECT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.order_status = "On Road" INTERSECT SELECT T1.customer_name FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id = T2.customer_id WHERE T2.order_status = "Shipped"