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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started