Database: cre_Drama_Workshop_Groups
Schema: Ref_Payment_Methods: payment_method_code (text), payment_method_description (text) | Ref_Service_Types: Service_Type_Code (text), Parent_Service_Type_Code (text), Service_Type_Description (text) | Addresses: Address_ID (text), Line_1 (text), Line_2 (text), City_Town (text), State_County (text), Other_Details (text) | Products: Product_ID (text), Product_Name (text), Product_Price (number), Product_Description (text), Other_Product_Service_Details (text) | Marketing_Regions: Marketing_Region_Code (text), Marketing_Region_Name (text), Marketing_Region_Descriptrion (text), Other_Details (text) | Clients: Client_ID (number), Address_ID (number), Customer_Email_Address (text), Customer_Name (text), Customer_Phone (text), Other_Details (text) | Drama_Workshop_Groups: Workshop_Group_ID (number), Address_ID (number), Currency_Code (text), Marketing_Region_Code (text), Store_Name (text), Store_Phone (text), Store_Email_Address (text), Other_Details (text) | Performers: Performer_ID (number), Address_ID (number), Customer_Name (text), Customer_Phone (text), Customer_Email_Address (text), Other_Details (text) | Customers: Customer_ID (text), Address_ID (number), Customer_Name (text), Customer_Phone (text), Customer_Email_Address (text), Other_Details (text) | Stores: Store_ID (text), Address_ID (number), Marketing_Region_Code (text), Store_Name (text), Store_Phone (text), Store_Email_Address (text), Other_Details (text) | Bookings: Booking_ID (number), Customer_ID (number), Workshop_Group_ID (text), Status_Code (text), Store_ID (number), Order_Date (time), Planned_Delivery_Date (time), Actual_Delivery_Date (time), Other_Order_Details (text) | Performers_in_Bookings: Order_ID (number), Performer_ID (number) | Customer_Orders: Order_ID (number), Customer_ID (number), Store_ID (number), Order_Date (time), Planned_Delivery_Date (time), Actual_Delivery_Date (time), Other_Order_Details (text) | Order_Items: Order_Item_ID (number), Order_ID (number), Product_ID (number), Order_Quantity (text), Other_Item_Details (text) | Invoices: Invoice_ID (number), Order_ID (number), payment_method_code (text), Product_ID (number), Order_Quantity (text), Other_Item_Details (text), Order_Item_ID (number) | Services: Service_ID (number), Service_Type_Code (text), Workshop_Group_ID (number), Product_Description (text), Product_Name (text), Product_Price (number), Other_Product_Service_Details (text) | Bookings_Services: Order_ID (number), Product_ID (number) | Invoice_Items: Invoice_Item_ID (number), Invoice_ID (number), Order_ID (number), Order_Item_ID (number), Product_ID (number), Order_Quantity (number), Other_Item_Details (text)

Question: How many bookings do we have?
SQL: SELECT count(*) FROM BOOKINGS

Question: Count the total number of bookings made.
SQL: SELECT count(*) FROM BOOKINGS

Question: List the order dates of all the bookings.
SQL: SELECT Order_Date FROM BOOKINGS

Question: What is the order date of each booking?
SQL: SELECT Order_Date FROM BOOKINGS

Question: Show all the planned delivery dates and actual delivery dates of bookings.
SQL: SELECT Planned_Delivery_Date ,  Actual_Delivery_Date FROM BOOKINGS

Question: What are the planned delivery date and actual delivery date for each booking?
SQL: SELECT Planned_Delivery_Date ,  Actual_Delivery_Date FROM BOOKINGS

Question: How many customers do we have?
SQL: SELECT count(*) FROM CUSTOMERS

Question: Count the number of customers recorded.
SQL: SELECT count(*) FROM CUSTOMERS

Question: What are the phone and email for customer Harold?
SQL: SELECT Customer_Phone ,  Customer_Email_Address FROM CUSTOMERS WHERE Customer_Name  =  "Harold"

Question: Find the phone number and email address of customer "Harold".
SQL: SELECT Customer_Phone ,  Customer_Email_Address FROM CUSTOMERS WHERE Customer_Name  =  "Harold"

Question: Show all the Store_Name of drama workshop groups.
SQL: SELECT Store_Name FROM Drama_Workshop_Groups

Question: What are the store names of drama workshop groups?
SQL: SELECT Store_Name FROM Drama_Workshop_Groups

Question: Show the minimum, average, maximum order quantity of all invoices.
SQL: SELECT min(Order_Quantity) ,  avg(Order_Quantity) ,  max(Order_Quantity) FROM INVOICES

Question: What are the minimum, average, and maximum quantities ordered? Check all the invoices.
SQL: SELECT min(Order_Quantity) ,  avg(Order_Quantity) ,  max(Order_Quantity) FROM INVOICES

Question: What are the distinct payment method codes in all the invoices?
SQL: SELECT DISTINCT payment_method_code FROM INVOICES

Question: Show me the distinct payment method codes from the invoice record.
SQL: SELECT DISTINCT payment_method_code FROM INVOICES

Question: What is the description of the marketing region China?
SQL: SELECT Marketing_Region_Descriptrion FROM Marketing_Regions WHERE Marketing_Region_Name  =  "China"

Question: Find the marketing region description of China?
SQL: SELECT Marketing_Region_Descriptrion FROM Marketing_Regions WHERE Marketing_Region_Name  =  "China"

Question: Show all the distinct product names with price higher than the average.
SQL: SELECT DISTINCT Product_Name FROM PRODUCTS WHERE Product_Price  >  (SELECT avg(Product_Price) FROM PRODUCTS)

Question: What are the distinct names of the products that cost more than the average?
SQL: SELECT DISTINCT Product_Name FROM PRODUCTS WHERE Product_Price  >  (SELECT avg(Product_Price) FROM PRODUCTS)

Question: What is the name of the most expensive product?
SQL: SELECT Product_Name FROM PRODUCTS ORDER BY Product_Price DESC LIMIT 1

Question: Tell me the name of the most pricy product.
SQL: SELECT Product_Name FROM PRODUCTS ORDER BY Product_Price DESC LIMIT 1

Question: List all product names in ascending order of price.
SQL: SELECT Product_Name FROM Products ORDER BY Product_Price ASC

Question: Sort the names of products in ascending order of their price.
SQL: SELECT Product_Name FROM Products ORDER BY Product_Price ASC

Question: What is the phone number of the performer Ashley?
SQL: SELECT Customer_Phone FROM PERFORMERS WHERE Customer_Name  =  "Ashley"

Question: Find the phone number of performer "Ashley".
SQL: SELECT Customer_Phone FROM PERFORMERS WHERE Customer_Name  =  "Ashley"

Question: Show all payment method codes and the number of orders for each code.
SQL: SELECT payment_method_code ,  count(*) FROM INVOICES GROUP BY payment_method_code

Question: List the distinct payment method codes with the number of orders made
SQL: SELECT payment_method_code ,  count(*) FROM INVOICES GROUP BY payment_method_code

Question: What is the payment method code used by the most orders?
SQL: SELECT payment_method_code FROM INVOICES GROUP BY payment_method_code ORDER BY count(*) DESC LIMIT 1

Question: Find the payment method that is used the most often in all the invoices. Give me its code.
SQL: SELECT payment_method_code FROM INVOICES GROUP BY payment_method_code ORDER BY count(*) DESC LIMIT 1

Question: Which city is the address of the store named "FJA Filming" located in?
SQL: SELECT T1.City_Town FROM Addresses AS T1 JOIN Stores AS T2 ON T1.Address_ID  =  T2.Address_ID WHERE T2.Store_Name  =  "FJA Filming"

Question: Find the city the store named "FJA Filming" is in.
SQL: SELECT T1.City_Town FROM Addresses AS T1 JOIN Stores AS T2 ON T1.Address_ID  =  T2.Address_ID WHERE T2.Store_Name  =  "FJA Filming"

Question: What are the states or counties of the address of the stores with marketing region code "CA"?
SQL: SELECT T1.State_County FROM Addresses AS T1 JOIN Stores AS T2 ON T1.Address_ID  =  T2.Address_ID WHERE T2.Marketing_Region_Code  =  "CA"

Question: Find the states or counties where the stores with marketing region code "CA" are located.
SQL: SELECT T1.State_County FROM Addresses AS T1 JOIN Stores AS T2 ON T1.Address_ID  =  T2.Address_ID WHERE T2.Marketing_Region_Code  =  "CA"

Question: What is the name of the marketing region that the store Rob Dinning belongs to?
SQL: SELECT T1.Marketing_Region_Name FROM Marketing_Regions AS T1 JOIN Stores AS T2 ON T1.Marketing_Region_Code  =  T2.Marketing_Region_Code WHERE T2.Store_Name  =  "Rob Dinning"

Question: Return the name of the marketing region the store Rob Dinning is located in.
SQL: SELECT T1.Marketing_Region_Name FROM Marketing_Regions AS T1 JOIN Stores AS T2 ON T1.Marketing_Region_Code  =  T2.Marketing_Region_Code WHERE T2.Store_Name  =  "Rob Dinning"

Question: What are the descriptions of the service types with product price above 100?
SQL: SELECT T1.Service_Type_Description FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code  =  T2.Service_Type_Code WHERE T2.Product_Price  >  100

Question: Give me the descriptions of the service types that cost more than 100.
SQL: SELECT T1.Service_Type_Description FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code  =  T2.Service_Type_Code WHERE T2.Product_Price  >  100

Question: What is the description, code and the corresponding count of each service type?
SQL: SELECT T1.Service_Type_Description ,  T2.Service_Type_Code ,  COUNT(*) FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code  =  T2.Service_Type_Code GROUP BY T2.Service_Type_Code

Question: List the description, code and the number of services for each service type.
SQL: SELECT T1.Service_Type_Description ,  T2.Service_Type_Code ,  COUNT(*) FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code  =  T2.Service_Type_Code GROUP BY T2.Service_Type_Code

Question: What is the description and code of the type of service that is performed the most often?
SQL: SELECT T1.Service_Type_Description , T1.Service_Type_Code FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code  =  T2.Service_Type_Code GROUP BY T1.Service_Type_Code ORDER BY COUNT(*) DESC LIMIT 1

Question: Find the description and code of the service type that is performed the most times.
SQL: SELECT T1.Service_Type_Description , T1.Service_Type_Code FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code  =  T2.Service_Type_Code GROUP BY T1.Service_Type_Code ORDER BY COUNT(*) DESC LIMIT 1

Question: What are the phones and emails of workshop groups in which services are performed?
SQL: SELECT T1.Store_Phone ,  T1.Store_Email_Address FROM Drama_Workshop_Groups AS T1 JOIN Services AS T2 ON T1.Workshop_Group_ID  =  T2.Workshop_Group_ID

Question: Give me all the phone numbers and email addresses of the workshop groups where services are performed.
SQL: SELECT T1.Store_Phone ,  T1.Store_Email_Address FROM Drama_Workshop_Groups AS T1 JOIN Services AS T2 ON T1.Workshop_Group_ID  =  T2.Workshop_Group_ID

Question: What are the names of workshop groups in which services with product name "film" are performed?
SQL: SELECT T1.Store_Phone ,  T1.Store_Email_Address FROM Drama_Workshop_Groups AS T1 JOIN Services AS T2 ON T1.Workshop_Group_ID  =  T2.Workshop_Group_ID WHERE T2.Product_Name  =  "film"

Question: Find the names of the workshop groups where services with product name "film" are performed.
SQL: SELECT T1.Store_Phone ,  T1.Store_Email_Address FROM Drama_Workshop_Groups AS T1 JOIN Services AS T2 ON T1.Workshop_Group_ID  =  T2.Workshop_Group_ID WHERE T2.Product_Name  =  "film"

Question: What are the different product names? What is the average product price for each of them?
SQL: SELECT Product_Name ,  avg(Product_Price) FROM PRODUCTS GROUP BY Product_Name

Question: For each distinct product name, show its average product price.
SQL: SELECT Product_Name ,  avg(Product_Price) FROM PRODUCTS GROUP BY Product_Name

Question: What are the product names with average product price smaller than 1000000?
SQL: SELECT Product_Name FROM PRODUCTS GROUP BY Product_Name HAVING avg(Product_Price)  <  1000000

Question: Find the product names whose average product price is below 1000000.
SQL: SELECT Product_Name FROM PRODUCTS GROUP BY Product_Name HAVING avg(Product_Price)  <  1000000

Question: What are the total order quantities of photo products?
SQL: SELECT sum(T1.Order_Quantity) FROM ORDER_ITEMS AS T1 JOIN Products AS T2 ON T1.Product_ID  =  T2.Product_ID WHERE T2.Product_Name  =  "photo"

Question: Compute the total order quantities of the product "photo".
SQL: SELECT sum(T1.Order_Quantity) FROM ORDER_ITEMS AS T1 JOIN Products AS T2 ON T1.Product_ID  =  T2.Product_ID WHERE T2.Product_Name  =  "photo"

Question: What are the order details of the products with price higher than 2000?
SQL: SELECT T1.Other_Item_Details FROM ORDER_ITEMS AS T1 JOIN Products AS T2 ON T1.Product_ID  =  T2.Product_ID WHERE T2.Product_price  >  2000

Question: Find the order detail for the products with price above 2000.
SQL: SELECT T1.Other_Item_Details FROM ORDER_ITEMS AS T1 JOIN Products AS T2 ON T1.Product_ID  =  T2.Product_ID WHERE T2.Product_price  >  2000

Question: What are the actual delivery dates of orders with quantity 1?
SQL: SELECT T1.Actual_Delivery_Date FROM Customer_Orders AS T1 JOIN ORDER_ITEMS AS T2 ON T1.Order_ID  =  T2.Order_ID WHERE T2.Order_Quantity  =  1

Question: List the actual delivery date for all the orders with quantity 1
SQL: SELECT T1.Actual_Delivery_Date FROM Customer_Orders AS T1 JOIN ORDER_ITEMS AS T2 ON T1.Order_ID  =  T2.Order_ID WHERE T2.Order_Quantity  =  1

Question: What are the order dates of orders with price higher than 1000?
SQL: SELECT T1.Order_Date FROM Customer_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 WHERE T3.Product_price  >  1000

Question: Find the order dates of the orders with price above 1000.
SQL: SELECT T1.Order_Date FROM Customer_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 WHERE T3.Product_price  >  1000

Question: How many distinct currency codes are there for all drama workshop groups?
SQL: SELECT count(DISTINCT Currency_Code) FROM Drama_Workshop_Groups

Question: Find the number of distinct currency codes used in drama workshop groups.
SQL: SELECT count(DISTINCT Currency_Code) FROM Drama_Workshop_Groups

Question: What are the names of the drama workshop groups with address in Feliciaberg city?
SQL: SELECT T2.Store_Name FROM Addresses AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Address_ID  =  T2.Address_ID WHERE T1.City_Town  =  "Feliciaberg"

Question: Return the the names of the drama workshop groups that are located in Feliciaberg city.
SQL: SELECT T2.Store_Name FROM Addresses AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Address_ID  =  T2.Address_ID WHERE T1.City_Town  =  "Feliciaberg"

Question: What are the email addresses of the drama workshop groups with address in Alaska state?
SQL: SELECT T2.Store_Email_Address FROM Addresses AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Address_ID  =  T2.Address_ID WHERE T1.State_County  =  "Alaska"

Question: List the email addresses of the drama workshop groups located in Alaska state.
SQL: SELECT T2.Store_Email_Address FROM Addresses AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Address_ID  =  T2.Address_ID WHERE T1.State_County  =  "Alaska"

Question: Show all cities along with the number of drama workshop groups in each city.
SQL: SELECT T1.City_Town ,  count(*) FROM Addresses AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Address_ID  =  T2.Address_ID GROUP BY T1.City_Town

Question: How many drama workshop groups are there in each city? Return both the city and the count.
SQL: SELECT T1.City_Town ,  count(*) FROM Addresses AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Address_ID  =  T2.Address_ID GROUP BY T1.City_Town

Question: What is the marketing region code that has the most drama workshop groups?
SQL: SELECT Marketing_Region_Code FROM Drama_Workshop_Groups GROUP BY Marketing_Region_Code ORDER BY count(*) DESC LIMIT 1

Question: Which marketing region has the most drama workshop groups? Give me the region code.
SQL: SELECT Marketing_Region_Code FROM Drama_Workshop_Groups GROUP BY Marketing_Region_Code ORDER BY count(*) DESC LIMIT 1

Question: Show all cities where at least one customer lives in but no performer lives in.
SQL: SELECT T1.City_Town FROM Addresses AS T1 JOIN Customers AS T2 ON T1.Address_ID  =  T2.Address_ID EXCEPT SELECT T1.City_Town FROM Addresses AS T1 JOIN Performers AS T2 ON T1.Address_ID  =  T2.Address_ID

Question: Which cities have at least one customer but no performer?
SQL: SELECT T1.City_Town FROM Addresses AS T1 JOIN Customers AS T2 ON T1.Address_ID  =  T2.Address_ID EXCEPT SELECT T1.City_Town FROM Addresses AS T1 JOIN Performers AS T2 ON T1.Address_ID  =  T2.Address_ID

Question: What is the most frequent status of bookings?
SQL: SELECT Status_Code FROM BOOKINGS GROUP BY Status_Code ORDER BY count(*) DESC LIMIT 1

Question: Which status code is the most common of all the bookings?
SQL: SELECT Status_Code FROM BOOKINGS GROUP BY Status_Code ORDER BY count(*) DESC LIMIT 1

Question: What are the names of the workshop groups that have bookings with status code "stop"?
SQL: SELECT T2.Store_Name FROM Bookings AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Workshop_Group_ID  =  T2.Workshop_Group_ID WHERE T1.Status_Code  =  "stop"

Question: Which workshop groups have bookings with status code "stop"? Give me the names.
SQL: SELECT T2.Store_Name FROM Bookings AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Workshop_Group_ID  =  T2.Workshop_Group_ID WHERE T1.Status_Code  =  "stop"

Question: Show the names of all the clients with no booking.
SQL: SELECT Customer_Name FROM Clients EXCEPT SELECT T2.Customer_Name FROM Bookings AS T1 JOIN Clients AS T2 ON T1.Customer_ID  =  T2.Client_ID

Question: What are the names of the clients who do not have any booking?
SQL: SELECT Customer_Name FROM Clients EXCEPT SELECT T2.Customer_Name FROM Bookings AS T1 JOIN Clients AS T2 ON T1.Customer_ID  =  T2.Client_ID

Question: What is the average quantities ordered with payment method code "MasterCard" on invoices?
SQL: SELECT avg(Order_Quantity) FROM Invoices WHERE payment_method_code  =  "MasterCard"

Question: Check the invoices record and compute the average quantities ordered with the payment method "MasterCard".
SQL: SELECT avg(Order_Quantity) FROM Invoices WHERE payment_method_code  =  "MasterCard"

Question: What is the product ID of the most frequently ordered item on invoices?
SQL: SELECT Product_ID FROM INVOICES GROUP BY Product_ID ORDER BY COUNT(*) DESC LIMIT 1

Question: Find the id of the product ordered the most often on invoices.
SQL: SELECT Product_ID FROM INVOICES GROUP BY Product_ID ORDER BY COUNT(*) DESC LIMIT 1

Question: What is the description of the service type which offers both the photo product and the film product?
SQL: SELECT T1.Service_Type_Description FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code  =  T2.Service_Type_Code WHERE T2.Product_Name  =  'photo' INTERSECT SELECT T1.Service_Type_Description FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code  =  T2.Service_Type_Code WHERE T2.Product_Name  =  'film'

Question: Give me the description of the service type that offers not only the photo product but also the film product.
SQL: SELECT T1.Service_Type_Description FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code  =  T2.Service_Type_Code WHERE T2.Product_Name  =  'photo' INTERSECT SELECT T1.Service_Type_Description FROM Ref_Service_Types AS T1 JOIN Services AS T2 ON T1.Service_Type_Code  =  T2.Service_Type_Code WHERE T2.Product_Name  =  'film'