Write a select statement that returns three columns


Write a SELECT statement that returns three columns:
InvoiceTotal From the Invoices table
10% 10% of the value of InvoiceTotal
Plus 10% The value of InvoiceTotal plus 10%
(For example, if InvoiceTotal is 100.0000, 10% is 10.0000, and Plus 10% is 110.0000.)
Only return those rows with a balance due greater than 1000. Sort the result set by InvoiceTotal,with the largest invoice first. 

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write a select statement that returns three columns
Reference No:- TGS0125256

Expected delivery within 24 Hours