target-benchmark/spider-queries huggingface dataset:
Database: soccer_3 (tables: club)
Question: How many clubs are there?
SQL: SELECT count(*) FROM club
Database: soccer_3 (tables: club)
Question: Count the number of clubs.
SQL: SELECT count(*) FROM club
Database: soccer_3 (tables: club)
Question: List the name of clubs in ascending alphabetical order.
SQL: SELECT Name FROM club ORDER BY Name ASC
Database: soccer_3 (tables: club)
Question: What are the names of clubs, ordered alphabetically?
SQL: SELECT Name FROM club ORDER BY Name ASC
Database: soccer_3 (tables: club)
Question: What are the managers and captains of clubs?
SQL: SELECT Manager ,  Captain FROM club
Database: soccer_3 (tables: club)
Question: Return the managers and captains of all clubs.
SQL: SELECT Manager ,  Captain FROM club
Database: soccer_3 (tables: club)
Question: List the name of clubs whose manufacturer is not "Nike"
SQL: SELECT Name FROM club WHERE Manufacturer != "Nike"
Database: soccer_3 (tables: club)
Question: What are the names of clubs who do not have the manufacturer Nike?
SQL: SELECT Name FROM club WHERE Manufacturer != "Nike"
Database: soccer_3 (tables: player)
Question: What are the names of players in ascending order of wins count?
SQL: SELECT Name FROM player ORDER BY Wins_count ASC
Database: soccer_3 (tables: player)
Question: Return the names of players in order of count of wins, ascending.
SQL: SELECT Name FROM player ORDER BY Wins_count ASC
Database: soccer_3 (tables: player)
Question: What is the name of the player with the highest earnings?
SQL: SELECT Name FROM player ORDER BY Earnings DESC LIMIT 1
Database: soccer_3 (tables: player)
Question: Return the name of the player who earns the most money.
SQL: SELECT Name FROM player ORDER BY Earnings DESC LIMIT 1
Database: soccer_3 (tables: player)
Question: What are the distinct countries of players with earnings higher than 1200000?
SQL: SELECT DISTINCT Country FROM player WHERE Earnings  >  1200000
Database: soccer_3 (tables: player)
Question: From which countries are players who make more than 1200000 from?
SQL: SELECT DISTINCT Country FROM player WHERE Earnings  >  1200000
Database: soccer_3 (tables: player)
Question: What is the country of the player with the highest earnings among players that have more than 2 win counts?
SQL: SELECT Country FROM player WHERE Wins_count  >  2 ORDER BY Earnings DESC LIMIT 1
Database: soccer_3 (tables: player)
Question: Of players who have more than 2 wins, what is the country of the player who makes the most?
SQL: SELECT Country FROM player WHERE Wins_count  >  2 ORDER BY Earnings DESC LIMIT 1
Database: soccer_3 (tables: club, player)
Question: Show names of players and names of clubs they are in.
SQL: SELECT T2.Name ,  T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID
Database: soccer_3 (tables: club, player)
Question: What are the names of players and the corresponding clubs that they are in?
SQL: SELECT T2.Name ,  T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID
Database: soccer_3 (tables: club, player)
Question: Show names of clubs that have players with more than 2 win counts.
SQL: SELECT T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID WHERE T2.Wins_count  >  2
Database: soccer_3 (tables: club, player)
Question: What are the names of clubs that have players who have won more than twice?
SQL: SELECT T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID WHERE T2.Wins_count  >  2
Database: soccer_3 (tables: club, player)
Question: Show names of players from the club with manager "Sam Allardyce".
SQL: SELECT T2.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID WHERE T1.Manager  =  "Sam Allardyce"
Database: soccer_3 (tables: club, player)
Question: What are the names of players from the club managed by Sam Allardyce?
SQL: SELECT T2.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID WHERE T1.Manager  =  "Sam Allardyce"
Database: soccer_3 (tables: club, player)
Question: Show names of clubs in descending order of average earnings of players belonging.
SQL: SELECT T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID GROUP BY T1.Club_ID ORDER BY avg(T2.Earnings) DESC
Database: soccer_3 (tables: club, player)
Question: What are the names of clubs, ordered descending by the average earnings of players within each?
SQL: SELECT T1.Name FROM club AS T1 JOIN player AS T2 ON T1.Club_ID  =  T2.Club_ID GROUP BY T1.Club_ID ORDER BY avg(T2.Earnings) DESC
Database: soccer_3 (tables: club)
Question: Show different manufacturers and the number of clubs they are associated with.
SQL: SELECT Manufacturer ,  COUNT(*) FROM club GROUP BY Manufacturer
Database: soccer_3 (tables: club)
Question: How many clubs use each manufacturer?
SQL: SELECT Manufacturer ,  COUNT(*) FROM club GROUP BY Manufacturer
Database: soccer_3 (tables: club)
Question: Please show the most common manufacturer of clubs.
SQL: SELECT Manufacturer FROM club GROUP BY Manufacturer ORDER BY COUNT(*) DESC LIMIT 1
Database: soccer_3 (tables: club)
Question: Which manufacturer is most common among clubs?
SQL: SELECT Manufacturer FROM club GROUP BY Manufacturer ORDER BY COUNT(*) DESC LIMIT 1
Database: soccer_3 (tables: club)
Question: List the manufacturers that are associated with more than one club.
SQL: SELECT Manufacturer FROM club GROUP BY Manufacturer HAVING COUNT(*)  >  1
Database: soccer_3 (tables: club)
Question: Which manufacturers work for more than 1 club?
SQL: SELECT Manufacturer FROM club GROUP BY Manufacturer HAVING COUNT(*)  >  1
Database: soccer_3 (tables: player)
Question: List the country that have more than one player.
SQL: SELECT Country FROM player GROUP BY Country HAVING COUNT(*)  >  1
Database: soccer_3 (tables: player)
Question: Which countries have produced more than one player?
SQL: SELECT Country FROM player GROUP BY Country HAVING COUNT(*)  >  1
Database: soccer_3 (tables: club, player)
Question: List the name of clubs that do not have players.
SQL: SELECT Name FROM club WHERE Club_ID NOT IN (SELECT Club_ID FROM player)
Database: soccer_3 (tables: club, player)
Question: What are the names of clubs that do not have any players?
SQL: SELECT Name FROM club WHERE Club_ID NOT IN (SELECT Club_ID FROM player)
Database: soccer_3 (tables: player)
Question: Show the country of players with earnings more than 1400000 and players with earnings less than 1100000.
SQL: SELECT Country FROM player WHERE Earnings  >  1400000 INTERSECT SELECT Country FROM player WHERE Earnings  <  1100000
Database: soccer_3 (tables: player)
Question: Which country has produced both players with earnings over 1400000 and players with earnings below 1100000?
SQL: SELECT Country FROM player WHERE Earnings  >  1400000 INTERSECT SELECT Country FROM player WHERE Earnings  <  1100000
Database: soccer_3 (tables: player)
Question: What is the number of distinct countries of all players?
SQL: SELECT COUNT (DISTINCT Country) FROM player
Database: soccer_3 (tables: player)
Question: How many different countries are players from?
SQL: SELECT COUNT (DISTINCT Country) FROM player
Database: soccer_3 (tables: player)
Question: Show the earnings of players from country "Australia" or "Zimbabwe".
SQL: SELECT Earnings FROM player WHERE Country  =  "Australia" OR Country  =  "Zimbabwe"
Database: soccer_3 (tables: player)
Question: What are the earnings of players from either of the countries of Australia or Zimbabwe?
SQL: SELECT Earnings FROM player WHERE Country  =  "Australia" OR Country  =  "Zimbabwe"
Database: e_commerce (tables: order_items, orders, customers)
Question: List the id, first name and last name of the customers who both have placed more than 2 orders and have bought at least 3 items.
SQL: SELECT T1.customer_id ,  T1.customer_first_name ,  T1.customer_last_name FROM Customers AS T1 JOIN Orders AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id HAVING count(*)  >  2 INTERSECT SELECT T1.customer_id ,  T1.customer_first_name ,  T1.customer_last_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 GROUP BY T1.customer_id HAVING count(*)  >= 3
Database: e_commerce (tables: order_items, orders, customers)
Question: What are the ids, first and last names of the customers who have ordered more than twice and have bought at least 3 items?
SQL: SELECT T1.customer_id ,  T1.customer_first_name ,  T1.customer_last_name FROM Customers AS T1 JOIN Orders AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id HAVING count(*)  >  2 INTERSECT SELECT T1.customer_id ,  T1.customer_first_name ,  T1.customer_last_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 GROUP BY T1.customer_id HAVING count(*)  >= 3
Database: e_commerce (tables: order_items, orders)
Question: For the orders with any produts, how many products does each orders contain ? List the order id, status and the number.
SQL: SELECT T1.order_id ,  T1.order_status_code ,  count(*) FROM Orders AS T1 JOIN Order_items AS T2 ON T1.order_id  =  T2.order_id GROUP BY T1.order_id
Database: e_commerce (tables: order_items, orders)
Question: For every order, how many products does it contain, and what are the orders' statuses and ids?
SQL: SELECT T1.order_id ,  T1.order_status_code ,  count(*) FROM Orders AS T1 JOIN Order_items AS T2 ON T1.order_id  =  T2.order_id GROUP BY T1.order_id
Database: e_commerce (tables: order_items, orders)
Question: List the dates of the orders which were placed at the earliest time or have more than 1 items.
SQL: SELECT min(date_order_placed) FROM Orders UNION SELECT T1.date_order_placed FROM Orders AS T1 JOIN Order_items AS T2 ON T1.order_id  =  T2.order_id GROUP BY T1.order_id HAVING count(*)  >  1
Database: e_commerce (tables: order_items, orders)
Question: What are the dates of the earliest order and the dates of all orders with more than 1 item?
SQL: SELECT min(date_order_placed) FROM Orders UNION SELECT T1.date_order_placed FROM Orders AS T1 JOIN Order_items AS T2 ON T1.order_id  =  T2.order_id GROUP BY T1.order_id HAVING count(*)  >  1
Database: e_commerce (tables: orders, customers)
Question: Which customers did not make any orders? List the first name, middle initial and last name.
SQL: SELECT customer_first_name ,  customer_middle_initial ,  customer_last_name FROM Customers EXCEPT SELECT T1.customer_first_name ,  T1.customer_middle_initial ,  T1.customer_last_name FROM Customers AS T1 JOIN Orders AS T2 ON T1.customer_id  =  T2.customer_id
Database: e_commerce (tables: orders, customers)
Question: WHat are the first and last names, and middle initials of all customers who did not make any orders?
SQL: SELECT customer_first_name ,  customer_middle_initial ,  customer_last_name FROM Customers EXCEPT SELECT T1.customer_first_name ,  T1.customer_middle_initial ,  T1.customer_last_name FROM Customers AS T1 JOIN Orders AS T2 ON T1.customer_id  =  T2.customer_id
Database: e_commerce (tables: order_items, orders, products)
Question: What are the id, name, price and color of the products which have not been ordered for at least twice?
SQL: SELECT product_id ,  product_name ,  product_price ,  product_color FROM Products EXCEPT SELECT T1.product_id ,  T1.product_name ,  T1.product_price ,  T1.product_color FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id JOIN Orders AS T3 ON T2.order_id  =  T3.order_id GROUP BY T1.product_id HAVING count(*)  >=  2
Database: e_commerce (tables: orders, products, order_items)
Question: What are the ids , names , prices , and colors of all products that have been listed in less than two orders ?
SQL: select t1.product_id ,  t1.product_name ,  t1.product_price ,  t1.product_color from products as t1 join order_items as t2 on t1.product_id  =  t2.product_id join orders as t3 on t2.order_id  =  t3.order_id group by t1.product_id having count(*) < 2
Database: e_commerce (tables: order_items, orders)
Question: Which orders have at least 2 products on it? List the order id and date.
SQL: SELECT T1.order_id ,  T1.date_order_placed FROM Orders AS T1 JOIN Order_items AS T2 ON T1.order_id  =  T2.order_id GROUP BY T1.order_id HAVING count(*)  >=  2
Database: e_commerce (tables: order_items, orders)
Question: What are the ids and dates of the orders with at least two products?
SQL: SELECT T1.order_id ,  T1.date_order_placed FROM Orders AS T1 JOIN Order_items AS T2 ON T1.order_id  =  T2.order_id GROUP BY T1.order_id HAVING count(*)  >=  2
Database: e_commerce (tables: order_items, products)
Question: Which product are listed in orders most frequently? List the id, product name and price.
SQL: SELECT T1.product_id ,  T1.product_name ,  T1.product_price FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id GROUP BY T1.product_id ORDER BY count(*) DESC LIMIT 1
Database: e_commerce (tables: order_items, products)
Question: What are the ids, names, and prices of all products that are ordered most frequently?
SQL: SELECT T1.product_id ,  T1.product_name ,  T1.product_price FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id GROUP BY T1.product_id ORDER BY count(*) DESC LIMIT 1
Database: e_commerce (tables: order_items, products)
Question: Which order have the least sum of the product prices. List the order id and sum.
SQL: SELECT T1.order_id ,  sum(T2.product_price) FROM Order_items AS T1 JOIN Products AS T2 ON T1.product_id  =  T2.product_id GROUP BY T1.order_id ORDER BY sum(T2.product_price) ASC LIMIT 1
Database: e_commerce (tables: products, order_items)
Question: What is the order that total cost the least , and how much is the total cost ?
SQL: select t1.order_id ,  sum(t2.product_price) from order_items as t1 join products as t2 on t1.product_id  =  t2.product_id group by t1.order_id order by sum(t2.product_price) asc limit 1
Database: e_commerce (tables: customer_payment_methods)
Question: What is the most popular payment method?
SQL: SELECT Payment_method_code FROM Customer_Payment_Methods GROUP BY Payment_method_code ORDER BY count(*) DESC LIMIT 1
Database: e_commerce (tables: customer_payment_methods)
Question: What is the payment method that most customers use?
SQL: SELECT Payment_method_code FROM Customer_Payment_Methods GROUP BY Payment_method_code ORDER BY count(*) DESC LIMIT 1
Database: e_commerce (tables: order_items, orders, customers)
Question: How many number of products does each gender of customers buy? List the gender and the number
SQL: SELECT T1.gender_code ,  count(*) 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 GROUP BY T1.gender_code
Database: e_commerce (tables: order_items, orders, customers)
Question: How many products does each gender buy?
SQL: SELECT T1.gender_code ,  count(*) 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 GROUP BY T1.gender_code
Database: e_commerce (tables: orders, customers)
Question: How many orders has each gender of customers placed?
SQL: SELECT T1.gender_code ,  count(*) FROM Customers AS T1 JOIN Orders AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.gender_code
Database: e_commerce (tables: orders, customers)
Question: How many orders has each gender placed?
SQL: SELECT T1.gender_code ,  count(*) FROM Customers AS T1 JOIN Orders AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.gender_code
Database: e_commerce (tables: customer_payment_methods, customers)
Question: List the customers' first name, middle initial, last name and payment methods.
SQL: SELECT T1.customer_first_name ,  T1.customer_middle_initial ,  T1.customer_last_name ,  T2.Payment_method_code FROM Customers AS T1 JOIN Customer_Payment_Methods AS T2 ON T1.customer_id  =  T2.customer_id
Database: e_commerce (tables: customer_payment_methods, customers)
Question: What are the first names, middle initials, last names, and payment methods of all customers?
SQL: SELECT T1.customer_first_name ,  T1.customer_middle_initial ,  T1.customer_last_name ,  T2.Payment_method_code FROM Customers AS T1 JOIN Customer_Payment_Methods AS T2 ON T1.customer_id  =  T2.customer_id
Database: e_commerce (tables: shipments, invoices)
Question: List the invoices' status, date and the date of shipment.
SQL: SELECT T1.invoice_status_code ,  T1.invoice_date ,  T2.shipment_date FROM Invoices AS T1 JOIN Shipments AS T2 ON T1.invoice_number  =  T2.invoice_number
Database: e_commerce (tables: shipments, invoices)
Question: What are the statuses, dates, and shipment dates for all invoices?
SQL: SELECT T1.invoice_status_code ,  T1.invoice_date ,  T2.shipment_date FROM Invoices AS T1 JOIN Shipments AS T2 ON T1.invoice_number  =  T2.invoice_number
Database: e_commerce (tables: order_items, products, shipments, shipment_items)
Question: List the names of the products being shipped and the corresponding shipment date.
SQL: SELECT T1.product_name ,  T4.shipment_date FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id JOIN Shipment_Items AS T3 ON T2.order_item_id  =  T3.order_item_id JOIN Shipments AS T4 ON T3.shipment_id  =  T4.shipment_id
Database: e_commerce (tables: order_items, products, shipments, shipment_items)
Question: What are the names of the products tht have been shipped, and on what days were they shipped?
SQL: SELECT T1.product_name ,  T4.shipment_date FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id JOIN Shipment_Items AS T3 ON T2.order_item_id  =  T3.order_item_id JOIN Shipments AS T4 ON T3.shipment_id  =  T4.shipment_id
Database: e_commerce (tables: order_items, shipments, shipment_items)
Question: What is the status code of the items being ordered and shipped and its corresponding shipment tracking number?
SQL: SELECT T1.order_item_status_code ,  T3.shipment_tracking_number FROM Order_items AS T1 JOIN Shipment_Items AS T2 ON T1.order_item_id  =  T2.order_item_id JOIN Shipments AS T3 ON T2.shipment_id  =  T3.shipment_id
Database: e_commerce (tables: order_items, shipments, shipment_items)
Question: What is the status code of the items have been ordered and shipped, and also what are their shipment tracking numbers?
SQL: SELECT T1.order_item_status_code ,  T3.shipment_tracking_number FROM Order_items AS T1 JOIN Shipment_Items AS T2 ON T1.order_item_id  =  T2.order_item_id JOIN Shipments AS T3 ON T2.shipment_id  =  T3.shipment_id
Database: e_commerce (tables: order_items, products, shipments, shipment_items)
Question: What is the product name and the color of the ordered items which have been shipped?
SQL: SELECT T1.product_name ,  T1.product_color FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id JOIN Shipment_Items AS T3 ON T2.order_item_id  =  T3.order_item_id JOIN Shipments AS T4 ON T3.shipment_id  =  T4.shipment_id
Database: e_commerce (tables: order_items, products, shipments, shipment_items)
Question: What are the names and colors of all products that have been shipped?
SQL: SELECT T1.product_name ,  T1.product_color FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id JOIN Shipment_Items AS T3 ON T2.order_item_id  =  T3.order_item_id JOIN Shipments AS T4 ON T3.shipment_id  =  T4.shipment_id
Database: e_commerce (tables: order_items, orders, products, customers)
Question: List all the distinct product names, price and descriptions which are bought by female customers.
SQL: SELECT DISTINCT T1.product_name ,  T1.product_price ,  T1.product_description FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id JOIN Orders AS T3 ON T2.order_id  =  T3.order_id JOIN Customers AS T4 ON T3.customer_id  =  T4.customer_id WHERE T4.gender_code  =  'Female'
Database: e_commerce (tables: order_items, orders, products, customers)
Question: What are the different names, prices, and descriptions for all products bought by female customers?
SQL: SELECT DISTINCT T1.product_name ,  T1.product_price ,  T1.product_description FROM Products AS T1 JOIN Order_items AS T2 ON T1.product_id  =  T2.product_id JOIN Orders AS T3 ON T2.order_id  =  T3.order_id JOIN Customers AS T4 ON T3.customer_id  =  T4.customer_id WHERE T4.gender_code  =  'Female'
Database: e_commerce (tables: shipments, invoices)
Question: What are invoices status of all the orders which have not been shipped?
SQL: SELECT invoice_status_code FROM Invoices WHERE invoice_number NOT IN ( SELECT invoice_number FROM Shipments )
Database: e_commerce (tables: shipments, invoices)
Question: What are the invoice statuses for all orderes that have not been shipped out yet?
SQL: SELECT invoice_status_code FROM Invoices WHERE invoice_number NOT IN ( SELECT invoice_number FROM Shipments )
Database: e_commerce (tables: orders, products, order_items)
Question: What are the total cost of all the orders ? List the order id , date , and total cost .
SQL: select t1.order_id ,  t1.date_order_placed ,  sum(t3.product_price) from orders as t1 join order_items as t2 on t1.order_id  =  t2.order_id join products as t3 on t2.product_id  =  t3.product_id group by t1.order_id
Database: e_commerce (tables: order_items, orders, products)
Question: For each order, what is its id, date, and total amount paid?
SQL: SELECT T1.order_id ,  T1.date_order_placed ,  sum(T3.product_price) FROM Orders AS T1 JOIN Order_items AS T2 ON T1.order_id  =  T2.order_id JOIN Products AS T3 ON T2.product_id  =  T3.product_id GROUP BY T1.order_id
Database: e_commerce (tables: orders)
Question: How many customers have placed any order?
SQL: SELECT count(DISTINCT customer_id) FROM Orders
Database: e_commerce (tables: orders)
Question: How many different customers have ordered things?
SQL: SELECT count(DISTINCT customer_id) FROM Orders
Database: e_commerce (tables: order_items)
Question: How many item states are there in the orders?
SQL: SELECT count(DISTINCT order_item_status_code) FROM Order_items
Database: e_commerce (tables: order_items)
Question: How many different item status codes are there listed in ordered items?
SQL: SELECT count(DISTINCT order_item_status_code) FROM Order_items
Database: e_commerce (tables: customer_payment_methods)
Question: How many different payment methods are there?
SQL: SELECT count(DISTINCT Payment_method_code) FROM Customer_Payment_Methods
Database: e_commerce (tables: customer_payment_methods)
Question: How many different payment methods can customers choose from?
SQL: SELECT count(DISTINCT Payment_method_code) FROM Customer_Payment_Methods
Database: e_commerce (tables: customers)
Question: What are the login names and passwords of the customers whose phone number have the prefix '+12'?
SQL: SELECT login_name ,  login_password FROM Customers WHERE phone_number LIKE '+12%'
Database: e_commerce (tables: customers)
Question: What are the usernames and passwords of all customers whose phone number starts with '+12'?
SQL: SELECT login_name ,  login_password FROM Customers WHERE phone_number LIKE '+12%'
Database: e_commerce (tables: products)
Question: What are the product sizes of the products whose name has the substring 'Dell'?
SQL: SELECT product_size FROM Products WHERE product_name LIKE '%Dell%'
Database: e_commerce (tables: products)
Question: What are the sizes of all products whose name includes the word 'Dell'?
SQL: SELECT product_size FROM Products WHERE product_name LIKE '%Dell%'
Database: e_commerce (tables: products)
Question: What are the product price and the product size of the products whose price is above average?
SQL: SELECT product_price ,  product_size FROM Products WHERE product_price  >  ( SELECT avg(product_price) FROM Products )
Database: e_commerce (tables: products)
Question: What are the prices and sizes of all products whose price is above the mean?
SQL: SELECT product_price ,  product_size FROM Products WHERE product_price  >  ( SELECT avg(product_price) FROM Products )
Database: e_commerce (tables: order_items, products)
Question: How many kinds of products have not been sold?
SQL: SELECT count(*) FROM Products WHERE product_id NOT IN ( SELECT product_id FROM Order_items )
Database: e_commerce (tables: order_items, products)
Question: What is the number of products that have not been ordered yet?
SQL: SELECT count(*) FROM Products WHERE product_id NOT IN ( SELECT product_id FROM Order_items )