Write a SELECT statement that returns these columns from the Invoices table: Name Description invoice_number The invoice
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Write a SELECT statement that returns these columns from the Invoices table: Name Description invoice_number The invoice
Write a SELECT statement that returns these columns from theInvoices table:Name Descriptioninvoice_number The invoice_number columninvoice_date The invoice_date columnbalance_due The invoice_total column minus the payment_total andcredit_total columnspayment_date The payment_date columnResult should be sorted by balance_due descending. Return only therows where the payment_datecolumn contains a null value.This should retrieve 11 rows. Please show a screenshot of theexecuted query.