Business metrics with SQL
Exercise 1 of 8
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.

SaaS company⌘/Ctrl + Enter to run · add Shift to check