Database: advertising_agencies
Question: Show all the different invoice ids and statuses of the payments
SQL:
SELECT DISTINCT T1.invoice_id ,  T1.invoice_status FROM Invoices AS T1 JOIN Payments AS T2 ON T1.invoice_id  =  T2.invoice_id