Write a SELECT statement that returns these column names and data from the Invoi

Question

Write a SELECT statement that returns these column names and data from the Invoices table:     Due Date The invoice_due_date column     Invoice Total The invoice_total column     10% 10% of the value of invoice_total     Plus 10% The value of invoice_total plus 10% Return only the rows with an invoice total that’s greater than or equal to 500 and less than or equal to 1000. This should retrieve 12 rows. Sort the result set in descending sequence by invoice_due_date. 9. Write a SELECT statement that returns these columns from the Invoices. Im having the hardest time trying to code this.

Explanation / Answer

SELECT invoice_due_date,invoice_total,invoice_total/10 as 10%,invoice_total+(invoice_total/10) as plus_10%
FROM Invoices
WHERE invoice_total>=500 AND invoice_total <=1000
ORDER BY invoice_due_date DESC
FETCH FIRST 12 ROWS ONLY;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.