CREATE TABLE order_items (order_item_id NUMBER, product_id NUMBER, order_id NUMBER, order_item_status CLOB, order_item_details CLOB)
CREATE TABLE shipment_items (shipment_id NUMBER, order_item_id NUMBER)
CREATE TABLE products (product_id NUMBER, product_name CLOB, product_details CLOB)
CREATE TABLE invoices (invoice_number NUMBER, invoice_date TIME, invoice_details CLOB)
CREATE TABLE orders (order_id NUMBER, customer_id NUMBER, order_status CLOB, date_order_placed TIME, order_details CLOB)
CREATE TABLE customers (customer_id NUMBER, customer_name CLOB, customer_details CLOB)
CREATE TABLE shipments (shipment_id NUMBER, order_id NUMBER, invoice_number NUMBER, shipment_tracking_number CLOB, shipment_date TIME, other_shipment_details CLOB)

Find all the order items whose product id is 11. What are the order item ids?
SELECT order_item_id FROM order_items WHERE product_id = 11
SELECT "order_item_id" FROM "order_items" WHERE "product_id" = 11