Questions in this part ask you to write SQL queriesthat would retrieve certain information from the...

If you have any doubts, please give me comment...

1)

SELECT PNO, PNAME

FROM P

WHERE pWeight>(

SELECT AVG(pWeight)

FROM P

);

2)

SELECT SNO

FROM S

WHERE sNo IN(

SELECT sNo

FROM SP

WHERE pNo IN(

SELECT pNo

FROM P

WHERE pName = 'Screw'

)

);

3)

SELECT SNO

FROM S

WHERE sCity = 'London' AND sNo IN(

SELECT sNo

FROM SP

WHERE pNo IN(

SELECT pNo

FROM P

WHERE pName = 'Screw' OR pName ='Bolt'

)

);

4)

SELECT COUNT(PNo), SUM(qty), MIN(qty), AVG(qty), MAX(qty)

FROM SP;

5)

SELECT COUNT(PNo), SUM(qty), MIN(qty), AVG(qty), MAX(qty)

FROM SP

GROUP BY PNo

ORDER BY PNo DESC;