* I have left the chat *
select product_id from order_items where order_item_id = 1
How many product quantity does order item 1 have ?
select product_quantity from order_items where order_item_id = 1
What is the product type code of order item 1?
select production_type_code from order_items as t1 join products as t2 on t1.product_id = t2.product_id where t1.order_item_id = 1