Database: e_commerce
Question: What is the status code of the items have been ordered and shipped, and also what are their shipment tracking numbers?
SQL:
SELECT T1.order_item_status_code ,  T3.shipment_tracking_number FROM Order_items AS T1 JOIN Shipment_Items AS T2 ON T1.order_item_id  =  T2.order_item_id JOIN Shipments AS T3 ON T2.shipment_id  =  T3.shipment_id