SELECT $,$ P$\_$CODE, P$\_$PRICESELECT $,$ P$\_$CODE, P$\_{?}_{-}QO{H}^{**}{P}_{-}$PRICE

FROM PRODUCT

WHERE $,$ P$\_QO{H}^{**}{P}_{?}$PRICE $>($SELECT AVG PRICE$)$ FROM

PRODUCT$)$

What is the likely data sparsity of the $P_{-}$QOH and $P_{-}$PRICE columns?

Should you create an index, what would the index column$($s$)$ be$,$ and why should you

create that index?

SELECT P$\_$CODE, P$\_$DESCRIPT, P$\_$QOH, P$\_$PRICE, V$\_$CODE

FROM PRODUCT

WHERE $,$ V$\_$CODE $=\text{'}21344\text{'}$

ORDER BY P$\_$CODE;

$12.$What index would you recommend, and what command would you use?

SELECT CUS$\_$CODE, MAX $($LINE$\_$TOTAL$)$

FROM CUSTOMER NATURAL JOIN INVOICE NATURAL JOIN LINE

WHERE CUS$\_$AREACODE $=\text{'}615\text{'}$

GROUP BY CUS$\_$CODE;

What indexes would you recommend for the query you above?

FROM PRODUCT

WHERE P$\_$PRICE $>=($SELECT AVG $($P$\_$PRICE$)$ FROM PRODUCT$)$ ;

What is the likely data sparsity of the P$\_$PRICE column?

Should you create an index? Why or why not?

SELECT P$\_$CODE, SUM$($LINE$\_$UNITS$)$

FROM LINE

GROUP BY P$\_$CODE

HAVING SUM$($LINE$\_$UNITS$)>($SELECT MAX $($LINE$\_$UNITS$)$ FROM LINE$)$;

What is the likely data sparsity of the LINE$\_$UNITS column?

Should you create an index? If so$,$ what would the index column$($s$)$ be and why

would you create that index?

Should you create an index on $P_{-}$CODE? If so$,$ write the SQL command to create

that index. If not, explain your reasoning.