human
Schema:
Ref_Payment_Methods (payment_method_code, payment_method_description)
Ref_Service_Types (Service_Type_Code, Parent_Service_Type_Code, Service_Type_Description)
Addresses (Address_ID, Line_1, Line_2, City_Town, State_County, Other_Details)
Products (Product_ID, Product_Name, Product_Price, Product_Description, Other_Product_Service_Details)
Marketing_Regions (Marketing_Region_Code, Marketing_Region_Name, Marketing_Region_Descriptrion, Other_Details)
Clients (Client_ID, Address_ID, Customer_Email_Address, Customer_Name, Customer_Phone, Other_Details)
Drama_Workshop_Groups (Workshop_Group_ID, Address_ID, Currency_Code, Marketing_Region_Code, Store_Name, Store_Phone, Store_Email_Address, Other_Details)
Performers (Performer_ID, Address_ID, Customer_Name, Customer_Phone, Customer_Email_Address, Other_Details)
Customers (Customer_ID, Address_ID, Customer_Name, Customer_Phone, Customer_Email_Address, Other_Details)
Stores (Store_ID, Address_ID, Marketing_Region_Code, Store_Name, Store_Phone, Store_Email_Address, Other_Details)
Bookings (Booking_ID, Customer_ID, Workshop_Group_ID, Status_Code, Store_ID, Order_Date, Planned_Delivery_Date, Actual_Delivery_Date, Other_Order_Details)
Performers_in_Bookings (Order_ID, Performer_ID)
Customer_Orders (Order_ID, Customer_ID, Store_ID, Order_Date, Planned_Delivery_Date, Actual_Delivery_Date, Other_Order_Details)
Order_Items (Order_Item_ID, Order_ID, Product_ID, Order_Quantity, Other_Item_Details)
Invoices (Invoice_ID, Order_ID, payment_method_code, Product_ID, Order_Quantity, Other_Item_Details, Order_Item_ID)
Services (Service_ID, Service_Type_Code, Workshop_Group_ID, Product_Description, Product_Name, Product_Price, Other_Product_Service_Details)
Bookings_Services (Order_ID, Product_ID)
Invoice_Items (Invoice_Item_ID, Invoice_ID, Order_ID, Order_Item_ID, Product_ID, Order_Quantity, Other_Item_Details)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the delivery dates of orders with 1 quantity? | do you mean the actual delivery dates ? | Yes
assistant
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 ;