Database: e_commerce
Question: What are the invoice statuses for all orderes that have not been shipped out yet?
SQL:
SELECT invoice_status_code FROM Invoices WHERE invoice_number NOT IN ( SELECT invoice_number FROM Shipments )