MySQL Database Questions

A. What is the command used to list the P CODE, P DESCRIPT, PINDATE, and P_PRICE fields from the PRODUCT table in ascendiner by P_PRICE? What command is used to produce a list of only those unique values, for the column Vendor Code (V CODE), those are different from one another? SELECT FROM PRODUCT SELECT ONLY V CODE SELECT FROM PRODUCT SEQUENCE BY P PRICE: P CODE, P.DESCRIPT, P INDATE, PPRICE b. DIFFERENT V CODE P CODE, P DESCRIPT, P INDATE, P PRICE FROM PRODUCT: SELECT FROM PRODUCT ORDER BY P PRICE; C. SELECT DISTINCT V CODE C. FROM PRODUCT: d. SELECT P CODE, P DESCRIPT, P_INDATE, P PRICE FROM PRODUCT SELECT UNIQUE V CODE FROM PRODUCT: ASCENDING BY P PRICE; d. SELECT P CODE, P DESCRIPT, P INDATE, P PRICE FROM PRODUCT LIST BY PPRICE; D. clause is applied to the output of a GROUP BY operation. a. WHERE GROUP b. LIKE c. DISTINCT d. HAVING B. What is the SQL command that lists the contents of the EMPLOYEE table sorted by last name, first name, and initial? a. EMP LNAME, EMP FNAME, EMP INITIAL, EMP AREACODE. SELECT EMP PHONE FROM EMPLOYEE LIST BY EMP LNAME, EMP_FNAME, EMP INITIAL; SELECT EMP LNAME, EMP FNAME, EMP INITIAL, EMP AREACODE EMP PHONE FROM EMPLOYEE DISPLAY BY EMP LNAME, EMP_FNAME, EMP INITIAL SELECT EMP LNAME, EMP FNAME, EMP INITIAL, EMP AREACODE, EMP PHONE FROM EMPLOYEE SEQUENCE BY EMP LNAME, EMP FNAME, EMP INITIAL: d. SELECT EMP LNAME, EMP FNAME, EMP INITIAL, EMP_AREACODE EMP PHONE FROM EMPLOYEE ORDER BY EMP LNAME, EMP FNAME, EMP INITIAL