Question: a. In My SQL write a SELECT statement that returns these columns from the Invoices table: - invoice_number (the invoice_number column) - invoice_total (the invoice_total
a. In My SQL write a SELECT statement that returns these columns from the Invoices table:
- invoice_number (the invoice_number column)
- invoice_total (the invoice_total column)
- payment_credit_total (sum of the payment_total and credit_total columns)
- balance_due (the invoice_total column minus the payment_total and credit_total columns)
b. Return only invoices that have a balance due that's greater than $50.
c. Sort the result set by balance due in descending sequence
three(3) SQL statements - they build on each other (meaning create and run a, then add b and run, then add c and run)
submit screenshots for each or submit just the SQL for each
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
