human
Schema:
Premises (premise_id, premises_type, premise_details)
Products (product_id, product_category, product_name)
Customers (customer_id, payment_method, customer_name, customer_phone, customer_email, customer_address, customer_login, customer_password)
Mailshot_Campaigns (mailshot_id, product_category, mailshot_name, mailshot_start_date, mailshot_end_date)
Customer_Addresses (customer_id, premise_id, date_address_from, address_type_code, date_address_to)
Customer_Orders (order_id, customer_id, order_status_code, shipping_method_code, order_placed_datetime, order_delivered_datetime, order_shipping_charges)
Mailshot_Customers (mailshot_id, customer_id, outcome_code, mailshot_customer_date)
Order_Items (item_id, order_item_status_code, order_id, product_id, item_status_code, item_delivered_datetime, item_order_quantity)
Please answer with SQL.
assistant
Sure, I understand.
human
Show the name and phone for all customers.
assistant
SELECT customer_name , customer_phone FROM customers ;