Database: e_commerce
Question: What are the statuses, dates, and shipment dates for all invoices?
SQL:
SELECT T1.invoice_status_code ,  T1.invoice_date ,  T2.shipment_date FROM Invoices AS T1 JOIN Shipments AS T2 ON T1.invoice_number  =  T2.invoice_number