Your supervisor has asked you to write a report showing the details for each order, along with the grand total for the order. After grouping the ORDER$\_$ITEMS and PRODUCT$\_$INFORMATION tables, use ROLLUP to show the grand totals

Return these columns for each order:

The ORDER$\_$ID from the OE$.$ORDER$\_$ITEMS table

The PRODUCT$\_$NAME from the OE$.$PRODUCT$\_$INFORMATION table

The sum of $($UNIT$\_$PRICE $*$ QUANTITY$)$ from the OE$.$ORDER$\_$ITEMS table with an alias of TOTAL

Use the ROLLUP operator to include a row that gives Ithe grand total.

The results should be something like:

$\backslash$table$[[$ORDER$\_$ID$,$PRODUCT$\_$NAME,TOTAL$],[2400,$Drive Mount $-$ A$,41],[2400,$Drive Mount $-$ D$,208],[2400,$Laptop $\frac{16}{8}\frac{?}{110},14080],[2400,$Manual $-$ Vision OS$/2$X $+,492],[2400,$Laptop $\frac{128}{12}\frac{?}{?}\frac{56}{?}$ V$90/110,54465\mathrm{.}4],[2400,-,69286\mathrm{.}4]]$