For every invoice, display the invoice number, invoice date and the total dollar amount for all products purchased in the invoice, ordered by invoice number in descending order. Here you will use an aggregate SUM$($x$*$y$)$ function in your SELECT clause to calculate the total dollar amount $($a calculated field $$ name it with the alias TOTAL$).$

CUSTOMER TABLE

CUS$\_$CODE CUS$\_$LNAME CUS$\_$FNAME CUS$\_$INITIAL CUS$\_$AREACODE CUS$\_$PHONE CUS$\_$BALANCE

$10010$ Ramas Alfred A $615844-25730$

$10011$ Dunne Leona K $713894-12380$

$10012$ Smith Kathy W $615894-2285345\mathrm{.}86$

$10013$ Olowski Paul F $615894-2180536\mathrm{.}75$

$10014$ Orlando Myron $-615222-16720$

$10015$ O'Brian Amy B $713442-33810$

$10016$ Brown James G $615297-1228221\mathrm{.}19$

$10017$ Williams George $-615290-2556768\mathrm{.}93$

$10018$ Farriss Anne G $713382-7185216\mathrm{.}55$

$10019$ Smith Olivette K $615297-38090$

INVOICE

INV$\_$NUMBER CUS$\_$CODE INV$\_$DATE

$10011001416-$JAN$-2022$

$10021001116-$JAN$-2022$

$10031001216-$JAN$-2022$

$10041001117-$JAN$-2022$

$10051001817-$JAN$-2022$

$10061001417-$JAN$-2022$

$10071001517-$JAN$-2022$

$10081001117-$JAN$-2022$

LINE

INV$\_$NUMBER LINE$\_$NUMBER P$\_$CODE LINE$\_$UNITS LINE$\_$PRICE

$1001113-$Q$2/$P$2114\mathrm{.}99$

$1001223109-$HB $19\mathrm{.}95$

$1002154778-2$T $24\mathrm{.}99$

$100312238/$QPD $138\mathrm{.}95$

$100321546-$QQ$2139\mathrm{.}95$

$1003313-$Q$2/$P$2514\mathrm{.}99$

$1004154778-2$T $34\mathrm{.}99$

$1004223109-$HB $29\mathrm{.}95$

$10051$ PVC$23$DRT $125\mathrm{.}87$

$10061$ SM$-1827736\mathrm{.}99$

$100622232/$QTY $1109\mathrm{.}92$

$1006323109-$HB $19\mathrm{.}95$

$1006489-$WRE$-$Q $1256\mathrm{.}99$

$1007113-$Q$2/$P$2214\mathrm{.}99$

$1007254778-2$T $14\mathrm{.}99$

$10081$ PVC$23$DRT $55\mathrm{.}87$

$10082$ WR$3/$TT$33119\mathrm{.}95$

$1008323109-$HB $19\mathrm{.}95$

PRODUCT

P$\_$CODE P$\_$DESCRIPT P$\_$INDATE P$\_$QOH P$\_$MIN P$\_$PRICE P$\_$DISCOUNT V$\_$CODE

$11$QER$/31$ Power painter, $15$ psi., $3-$nozzle $03-$NOV$-202185109\mathrm{.}99025595$

$13-$Q$2/$P$27\mathrm{.}25$ in$.$ pwr$.$ saw blade $13-$DEC$-2021321514\mathrm{.}99\mathrm{.}0521344$

$14-$Q$1/$L$39\mathrm{.}00-$in$.$ pwr$.$ saw blade $13-$NOV$-2021181217\mathrm{.}49021344$

$1546-$QQ$2$ Hrd$.$ cloth, $14-$in$.,2$x$5015-$JAN$-202215839\mathrm{.}95023119$

$1558-$QW$1$ Hrd$.$ cloth, $12-$in$.,3$x$5015-$JAN$-202223543\mathrm{.}99023119$

$2232/$QTY BD jigsaw, $12-$in$.$ blade $30-$DEC$-202185109\mathrm{.}92\mathrm{.}0524288$

$2232/$QWE BD jigsaw, $8-$in$.$ blade $24-$DEC$-20216599\mathrm{.}87\mathrm{.}0524288$

$2238/$QPD BD cordless drill, $12-$in$.20-$JAN$-202212538\mathrm{.}95\mathrm{.}0525595$

$23109-$HB Claw hammer $20-$JAN$-202223109\mathrm{.}95\mathrm{.}121225$

$23114-$AA Sledge hammer, $12$ lb$.02-$JAN$-20228514\mathrm{.}4\mathrm{.}05-$

$54778-2$T Rat$-$tail file, $18-$in$.$ fine $15-$DEC$-202143204\mathrm{.}99021344$

$89-$WRE$-$Q Hicut chain saw, $16$ in$.07-$FEB$-2022115256\mathrm{.}99\mathrm{.}0524288$

PVC$23$DRT PVC pipe, $3\mathrm{.}5-$in$.,8-$ft $20-$FEB$-2022188755\mathrm{.}870-$

SM$-182771\mathrm{.}25-$in$.$ metal screw, $2501-$MAR$-2022172756\mathrm{.}99021225$

SW$-231162\mathrm{.}5-$in$.$ wd$.$ screw, $5024-$FEB$-20222371008\mathrm{.}45021231$

WR$3/$TT$3$ Steel, $4$x$8$x$16,\mathrm{.}5$ mesh $17-$JAN$-2022185119\mathrm{.}95\mathrm{.}125595$