I want to know the proportion of products for each product name.
CREATE TABLE Customers (
    customer_id INTEGER,
    payment_method_code VARCHAR(15),
    customer_number VARCHAR(20),
    customer_name VARCHAR(80),
    customer_address VARCHAR(255),
    customer_phone VARCHAR(80),
    customer_email VARCHAR(80)
)

CREATE TABLE Customer_Orders (
    order_id INTEGER,
    customer_id INTEGER,
    order_date DATETIME,
    order_status_code VARCHAR(15)
)

CREATE TABLE Customer_Address_History (
    customer_id INTEGER,
    address_id INTEGER,
    date_from DATETIME,
    date_to DATETIME
)

CREATE TABLE Products (
    product_id INTEGER,
    product_type_code VARCHAR(15),
    product_name VARCHAR(80),
    product_price DOUBLE
)

CREATE TABLE Addresses (
    address_id INTEGER,
    line_1_number_building VARCHAR(80),
    city VARCHAR(50),
    zip_postcode VARCHAR(20),
    state_province_county VARCHAR(50),
    country VARCHAR(50)
)

CREATE TABLE Contacts (
    contact_id INTEGER,
    customer_id INTEGER,
    gender VARCHAR(1),
    first_name VARCHAR(80),
    last_name VARCHAR(50),
    contact_phone VARCHAR(80)
)

CREATE TABLE Order_Items (
    order_item_id INTEGER,
    order_id INTEGER,
    product_id INTEGER,
    order_quantity VARCHAR(80)
)
SELECT product_name, COUNT(product_name) FROM Products GROUP BY product_name
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: I want to know the proportion of products for each product name. ### Input: CREATE TABLE Customers (
    customer_id INTEGER,
    payment_method_code VARCHAR(15),
    customer_number VARCHAR(20),
    customer_name VARCHAR(80),
    customer_address VARCHAR(255),
    customer_phone VARCHAR(80),
    customer_email VARCHAR(80)
)

CREATE TABLE Customer_Orders (
    order_id INTEGER,
    customer_id INTEGER,
    order_date DATETIME,
    order_status_code VARCHAR(15)
)

CREATE TABLE Customer_Address_History (
    customer_id INTEGER,
    address_id INTEGER,
    date_from DATETIME,
    date_to DATETIME
)

CREATE TABLE Products (
    product_id INTEGER,
    product_type_code VARCHAR(15),
    product_name VARCHAR(80),
    product_price DOUBLE
)

CREATE TABLE Addresses (
    address_id INTEGER,
    line_1_number_building VARCHAR(80),
    city VARCHAR(50),
    zip_postcode VARCHAR(20),
    state_province_county VARCHAR(50),
    country VARCHAR(50)
)

CREATE TABLE Contacts (
    contact_id INTEGER,
    customer_id INTEGER,
    gender VARCHAR(1),
    first_name VARCHAR(80),
    last_name VARCHAR(50),
    contact_phone VARCHAR(80)
)

CREATE TABLE Order_Items (
    order_item_id INTEGER,
    order_id INTEGER,
    product_id INTEGER,
    order_quantity VARCHAR(80)
) ### Response: SELECT product_name, COUNT(product_name) FROM Products GROUP BY product_name