human
Schema:
Addresses (address_id, line_1_number_building, city, zip_postcode, state_province_county, country)
Products (product_id, product_type_code, product_name, product_price)
Customers (customer_id, payment_method_code, customer_number, customer_name, customer_address, customer_phone, customer_email)
Contacts (contact_id, customer_id, gender, first_name, last_name, contact_phone)
Customer_Address_History (customer_id, address_id, date_from, date_to)
Customer_Orders (order_id, customer_id, order_date, order_status_code)
Order_Items (order_item_id, order_id, product_id, order_quantity)
Please answer with SQL.
assistant
Sure, I understand.
human
Show the product name for all products.
assistant
SELECT product_name FROM products ;