Database: e_commerce
Question: What are invoices status of all the orders which have not been shipped?
SQL:
SELECT invoice_status_code FROM Invoices WHERE invoice_number NOT IN ( SELECT invoice_number FROM Shipments )