Consider the table given below and write the output of the following:

Question

Write the output for the following queries:

 (a)Select SUM(PRICE) from ITEM where Name LIKE 'P%'; 

(b) Select from ITEM where PRICE IN (4,20);

(c)Select COUNT(DISTINCT NAME) FROM ITEM; (d)Select MAX(PRICE) as "HIGHEST PRICE" FROM ITEM;