Consider the table TRUCK with attributes TruckID, TruckModel, Miles, and Gallons, and the table LIMITS with attribute HighMPGLimit, defined and populated by the following script:

DROP TABLE TRUCK CASCADE CONSTRAINTS;

CREATE TABLE TRUCK

$($

TruckID INTEGER PRIMARY KEY,

TruckModel CHAR$(16),$

Miles NUMBER$(7,1),$

Gallons NUMBER$(5,1)$

$)$;

INSERT INTO TRUCK VALUES $(1,$ 'Silverado', $2651\mathrm{.}0,135\mathrm{.}0)$;

INSERT INTO TRUCK VALUES $(2,$ 'Sierra $2500\text{'},1388\mathrm{.}8,55\mathrm{.}0)$;

INSERT INTO TRUCK VALUES $(3,$ 'Silverado', $2301\mathrm{.}1,160\mathrm{.}4)$;

INSERT INTO TRUCK VALUES $(4,$ 'Sierra $1000\text{'},2575\mathrm{.}0,115\mathrm{.}5)$;

INSERT INTO TRUCK VALUES $(5,\text{'}$F$-150\text{'},2817\mathrm{.}0,150\mathrm{.}0)$;

INSERT INTO TRUCK VALUES $(6,$ 'Titan XD$\text{'},3698\mathrm{.}5,165\mathrm{.}6)$;

INSERT INTO TRUCK VALUES $(7,$ 'Ram $1500\text{'},4434\mathrm{.}8,185\mathrm{.}7)$;

SELECT $*$ FROM TRUCK;

DROP TABLE LIMITS CASCADE CONSTRAINTS;

CREATE TABLE LIMITS

$($

HighMPGLimit NUMBER$(2,0)$

$)$;

INSERT INTO LIMITS VALUES $(22)$;

SELECT $*$ FROM LIMITS;

COMMIT;

Write a script file Assignment$6.$sql containing just an anonymous PL$/$SQL block that will do the following:

$$ First, read the high miles$-$per$-$gallon $($MPG$)$ limit from the LIMITS table, store it in a variable, and display its value. $($You may assume that the LIMITS table contains exactly one record.$)$

$$ Next, for each truck in the TRUCK table, compute the miles$-$per$-$gallon for the truck $($number of miles for the truck divided by the number of gallons used, rounded to two decimal places$).$ Output each truck$$s information on a single line, showing the ID$,$ model, and miles$-$per$-$gallon for the truck. Add the word HIGH to the end of each line in which the miles$-$per$-$gallon is greater than or equal to the high miles$-$per$-$gallon limit$.$

$$ Also compute the overall miles$-$per$-$gallon for all of the trucks together $($total miles driven by all trucks divided by total gallons used by all trucks, rounded to two decimal places$)$ and the number of trucks that reached or exceeded the high miles$-$per$-$gallon limit$,$ and report those values at the end.

For the sample data given, the output should be:

High MPG limit: $22$

Truck $1$: Silverado $19\mathrm{.}64$

Truck $2$: Sierra $250025\mathrm{.}25$ HIGH

Truck $3$: Silverado $14\mathrm{.}35$

Truck $4$: Sierra $100022\mathrm{.}29$ HIGH

Truck $5$: F$-15018\mathrm{.}78$

Truck $6$: Titan XD $22\mathrm{.}33$ HIGH

Truck $7$: Ram $150023\mathrm{.}88$ HIGH

Overall fleet MPG: $20\mathrm{.}54$

Trucks with high MPG: $4$