database:

1.

2.

3.

4.

5.

Which query lists all products with a total quantity sold less than the average quantity sold? Select one: a. SELECT P_CODE, SUM(LINE_UNITS) AS TOTALUNITS FROM LINE GROUP BY P_CODE HAVING SUM(LINE_UNITS) (SELECT SUM(LINE_UNITS) FROM LINE); Which query returns the number of different vendors in the PRODUCT table? Select one: a. SELECT DISTINCT(V_CODE) FROM PRODUCT; O b. SELECT COUNT(DISTINCT V_CODE) FROM PRODUCT; C. SELECT DISTINCT COUNT(V_CODE) FROM PRODUCT; d. SELECT COUNT(V_CODE) FROM PRODUCT; Which query returns the number of products in the inventory supplied by each vendor and limit the listing to products whose prices average greater than equal $100? Select one: O a. SELECT V_CODE, COUNT(P_CODE) AS NUMPRODS FROM PRODUCT GROUP BY V_CODE HAVING AVG(P_PRICE) >= 100 ORDER BY V_CODE; O b. SELECT V_CODE, COUNT(P_CODE) AS NUMPRODS FROM PRODUCT WHERE AVG(P_PRICE) >= 100 ORDER BY V CODE; SELECT V_CODE, COUNT(P_CODE) AS NUMPRODS, AVG(P_PRICE) AS AVGPRICE FROM PRODUCT GROUP BY V_CODE WHERE AVG(P_PRICE) >= 100 ORDER BY V_CODE; d. SELECT V_CODE, COUNT(P_CODE) AS NUMPRODS, AVG(P_PRICE) AS AVGPRICE FROM PRODUCT WHERE AVG(P_PRICE) >= 100 GROUP BY V_CODE ORDER BY V_CODE; Aggregate functions ignore nulls when performing calculations, but the GROUP BY clause includes nulls and considers all of the nulls to be the same when forming collections. Select one: O True O False Unlike ORDER BY clause, the order of attributes in GROUP BY clause does not matter. Select one: O True O False