I want to know the proportion of total number for each product category.
CREATE TABLE Mailshot_Campaigns (
    mailshot_id INTEGER,
    product_category VARCHAR(15),
    mailshot_name VARCHAR(80),
    mailshot_start_date DATETIME,
    mailshot_end_date DATETIME
)

CREATE TABLE Customers (
    customer_id INTEGER,
    payment_method VARCHAR(15),
    customer_name VARCHAR(80),
    customer_phone VARCHAR(80),
    customer_email VARCHAR(80),
    customer_address VARCHAR(255),
    customer_login VARCHAR(80),
    customer_password VARCHAR(10)
)

CREATE TABLE Products (
    product_id INTEGER,
    product_category VARCHAR(15),
    product_name VARCHAR(80)
)

CREATE TABLE Customer_Addresses (
    customer_id INTEGER,
    premise_id INTEGER,
    date_address_from DATETIME,
    address_type_code VARCHAR(15),
    date_address_to DATETIME
)

CREATE TABLE Premises (
    premise_id INTEGER,
    premises_type VARCHAR(15),
    premise_details VARCHAR(255)
)

CREATE TABLE Mailshot_Customers (
    mailshot_id INTEGER,
    customer_id INTEGER,
    outcome_code VARCHAR(15),
    mailshot_customer_date DATETIME
)

CREATE TABLE Customer_Orders (
    order_id INTEGER,
    customer_id INTEGER,
    order_status_code VARCHAR(15),
    shipping_method_code VARCHAR(15),
    order_placed_datetime DATETIME,
    order_delivered_datetime DATETIME,
    order_shipping_charges VARCHAR(255)
)

CREATE TABLE Order_Items (
    item_id INTEGER,
    order_item_status_code VARCHAR(15),
    order_id INTEGER,
    product_id INTEGER,
    item_status_code VARCHAR(15),
    item_delivered_datetime DATETIME,
    item_order_quantity VARCHAR(80)
)
SELECT product_category, COUNT(*) FROM Mailshot_Campaigns GROUP BY product_category
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 total number for each product category. ### Input: CREATE TABLE Mailshot_Campaigns (
    mailshot_id INTEGER,
    product_category VARCHAR(15),
    mailshot_name VARCHAR(80),
    mailshot_start_date DATETIME,
    mailshot_end_date DATETIME
)

CREATE TABLE Customers (
    customer_id INTEGER,
    payment_method VARCHAR(15),
    customer_name VARCHAR(80),
    customer_phone VARCHAR(80),
    customer_email VARCHAR(80),
    customer_address VARCHAR(255),
    customer_login VARCHAR(80),
    customer_password VARCHAR(10)
)

CREATE TABLE Products (
    product_id INTEGER,
    product_category VARCHAR(15),
    product_name VARCHAR(80)
)

CREATE TABLE Customer_Addresses (
    customer_id INTEGER,
    premise_id INTEGER,
    date_address_from DATETIME,
    address_type_code VARCHAR(15),
    date_address_to DATETIME
)

CREATE TABLE Premises (
    premise_id INTEGER,
    premises_type VARCHAR(15),
    premise_details VARCHAR(255)
)

CREATE TABLE Mailshot_Customers (
    mailshot_id INTEGER,
    customer_id INTEGER,
    outcome_code VARCHAR(15),
    mailshot_customer_date DATETIME
)

CREATE TABLE Customer_Orders (
    order_id INTEGER,
    customer_id INTEGER,
    order_status_code VARCHAR(15),
    shipping_method_code VARCHAR(15),
    order_placed_datetime DATETIME,
    order_delivered_datetime DATETIME,
    order_shipping_charges VARCHAR(255)
)

CREATE TABLE Order_Items (
    item_id INTEGER,
    order_item_status_code VARCHAR(15),
    order_id INTEGER,
    product_id INTEGER,
    item_status_code VARCHAR(15),
    item_delivered_datetime DATETIME,
    item_order_quantity VARCHAR(80)
) ### Response: SELECT product_category, COUNT(*) FROM Mailshot_Campaigns GROUP BY product_category