2CDue date: as indicated on Stream Submission: via Stre

2CDue date: as indicated on Stream Submission: via Stream Problem 1 [15-16] Problems 1.1-1.2 are based on the following SQL query: SELECT P_CODE P_QOH*P_PRICE FROM PRODUCT WHERE P_QOH*P_PRICE > (SELECT AVG(P_QOH*P_PRICE) FROM PRODUCT) 1.1 What is the likely data sparsity of the P_QOH and P_PRICE columns? [ 2 marks ] 1.2 Should you create an index what would the index column(s) be and why should you create that index? [ 3 marks ] Problem 2 [27 -28] Problems 2.1 and 2.2 are based on the following query: SELECT P_CODE P_DESCRIPT P_QOH P_PRICE V_CODE FROM PRODUCT WHERE P_QOH