Question $1(10$ points$)$

$$

Build a report about product shelf prices by vendors with the query

CREATE VIEW GROUP$\_$PRICES AS SELECT VEND$\_$NAME, PROD$\_$DESCRIP, PROD$\_$PRICE FROM PRODUCT GROUP BY VEND$\_$NAME;

CREATE VIEW GROUP$\_$PURCHASE AS SELECT VEND$\_$NAME, PROD$\_$DESCRIP, PROD$\_$NAME FROM PRODUCT GROUP BY VEND$\_$NAME;

CREATE VIEW VEND$\_$NAME AS SELECT VEND$\_$NAME, PROD$\_$DESCRIP, PROD$\_$PRICE FROM PRODUCT GROUP BY VEND$\_$NAME;

CREATE VIEW GROUP$\_$PRICES AS SELECT VEND$\_$NAME, PROD$\_$DESCRIP, PROD$\_$PRICE FROM PRODUCT GROUP BY VEND$\_$NAME