Question: UNION ------------------ Review the following UNION query. Correct the error to produce the following result: USE Examples SELECT InvoiceID AS Invoice ID, InvoiceNumber AS Invoice
UNION ------------------ Review the following UNION query. Correct the error to produce the following result: USE Examples SELECT InvoiceID AS "Invoice ID", InvoiceNumber AS "Invoice Number", InvoiceTotal AS "Invoice Total" FROM Invoices WHERE InvoiceTotal < 500 UNION SELECT InvoiceID AS "Invoice ID", InvoiceNumber AS "Invoice Number", InvoiceTotal AS"Invoice Total" FROM PaidInvoices WHERE InvoiceTotal <10; Invoice ID Invoice Number Invoice Total ---------------- ------------- ----------- ---------- 1 8937 $50 2 3662 $100 4 4553 $250 5 8937 $0 14 25022117 $6 20 24863706 $6 70 24780512 $6' + CHAR(10) we should result from small money of InvoiceTotal FROM Incoices table with no decimal places and a dollar sign. Then, use ROUND to round it. Conversion to an Integer is another way of doing it
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
