SELECT $,$ P$\_$CODE, P$\_$PRICE

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.