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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!