Database: advertising_agencies
Question: What are the distinct invoice ids and statuses for all 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