Section A: Rewrite the following queries:

SELECT $*$ FROM emp WHERE lname $=$ 'FULLER' AND empid $=\text{'}439394\text{'}$;

SELECT $*$ FROM Employee WHERE salary$/12=4000$

SELECT P$\_$NAME FROM PRODUCTS WHERE P$\_$PRICE $-10=7$

SELECT P$\_$NAME FROM PRODUCTS WHERE

$P_{-}$MIN$=P_{-}REORDER{P}_{-}$QOH$=10FL{P}_{-}$QOH AND $P_{-}$MIN$=P_{-}$REORDER AND $P_{-}$QOH$=10$

SELECT $P_N$AME FROM PRODUCTS WHERE $P_P$RICE $>10$ AND $V_S$TATE $=$

$\text{'}FL\text{'}$

$(You$ know that only a few vendors are located $in$ Florida$)$

SELECT $P_N$AME FROM PRODUCTS WHERE NOT $(P_P$RICE $>10\mathrm{.}00)$

SELECT $*$ FROM Employee WHERE NOT $(EM{P}_{S}EX=\text{'}M\text{'})$Assume that $10,000$ vendors are distributed as shown in Table $1.$

Table $1$ Distribution of Vendors by State

Using Table $1$ as an example, create two alternative access plans.

Table $2$ Comparing Access Plans and I$/$O Costs