For each product, return its id and the number of times it was ordered.
CREATE TABLE products (
    product_id number,
    product_name text,
    product_details text
)

CREATE TABLE order_items (
    order_item_id number,
    product_id number,
    order_id number,
    order_item_status text,
    order_item_details text
)

CREATE TABLE orders (
    order_id number,
    customer_id number,
    order_status text,
    date_order_placed time,
    order_details text
)

CREATE TABLE shipment_items (
    shipment_id number,
    order_item_id number
)

CREATE TABLE customers (
    customer_id number,
    customer_name text,
    customer_details text
)

CREATE TABLE invoices (
    invoice_number number,
    invoice_date time,
    invoice_details text
)

CREATE TABLE shipments (
    shipment_id number,
    order_id number,
    invoice_number number,
    shipment_tracking_number text,
    shipment_date time,
    other_shipment_details text
)
SELECT COUNT(*), T3.product_id FROM orders AS T1 JOIN order_items AS T2 JOIN products AS T3 ON T1.order_id = T2.order_id AND T2.product_id = T3.product_id GROUP BY T3.product_id
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: For each product, return its id and the number of times it was ordered. ### Input: CREATE TABLE products (
    product_id number,
    product_name text,
    product_details text
)

CREATE TABLE order_items (
    order_item_id number,
    product_id number,
    order_id number,
    order_item_status text,
    order_item_details text
)

CREATE TABLE orders (
    order_id number,
    customer_id number,
    order_status text,
    date_order_placed time,
    order_details text
)

CREATE TABLE shipment_items (
    shipment_id number,
    order_item_id number
)

CREATE TABLE customers (
    customer_id number,
    customer_name text,
    customer_details text
)

CREATE TABLE invoices (
    invoice_number number,
    invoice_date time,
    invoice_details text
)

CREATE TABLE shipments (
    shipment_id number,
    order_id number,
    invoice_number number,
    shipment_tracking_number text,
    shipment_date time,
    other_shipment_details text
) ### Response: SELECT COUNT(*), T3.product_id FROM orders AS T1 JOIN order_items AS T2 JOIN products AS T3 ON T1.order_id = T2.order_id AND T2.product_id = T3.product_id GROUP BY T3.product_id