SQL EXERCISE
Who still owes us money?
3 minute exercise · runs on sample data
THE QUESTION
Finance wants to chase customers with unpaid invoices before month-end. An invoice is unpaid when its status is 'open'; 'void' invoices were cancelled and nobody owes them. Return one row per open invoice with three columns: the company name, the invoice_date and the amount. Any row order is fine.