MySQL Database Questions

Which command is used to join the P DESCRIPT and P_PRICE fields from the PRODUCT table and the V NAME, V_AREACODE, V PHONE, and V CONTACT fields from the VENDOR table where the values of V CODE match and the output is ordered by P_PRICE? A. The_clause is especially useful when the listing sequence is important. a. ORDER BY b. SELECT c. GROUP BY d. HAVING SELECT PDESCRIPT, P_PRICE, VNAME, V CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V CODE>VENDORV CODE; ORDER BY P PRICE; The aggregate functions, such as COUNT, MIN, MAX, AVG, and SUM. clause is valid only when used in conjunction with one of the SQL b. a. HAVING b. SELECT c. WHERE d. GROUP BY SELECT PDESCRIPT, P_PRICE, VNAME, V CONTACT, V AREACODE, V PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V CODE VENDOR.V CODE; ORDER BY P PRICE C. Which of the following commands is used to join the P_DESCRIPT and P PRICE fields from the PRODUCT table and the V NAME, V AREACODE, V PHONE and V CONTACT fields from the VENDOR table where the values of V CODE match? SELECT P DESCRIPT, P_PRICE, V NAME, V CONTACT, V AREACODE, V PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V CODE VENDOR.V CODE; ORDER BY P_PRICE; a. d. SELECT P DESCRIPT, P PRICE, V NAME, V CONTACT, V AREACODE, V PHONE FROM PRODUCT, VENDOR WHERE SELECT P DESCRIPT, P PRICE, V NAME, V CONTACT, V AREACODE, V PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V-CODE => VENDOR.V-CODE; ORDER BY P PRICE; PRODUCT.V CODEVENDOR.V CODE; SELECT PDESCRIPT, P_PRICE, V_NAME, V CONTACT, V AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCTV-CODE VENDOR CODE; d. SELECT PDESCRIPT, P_PRICE, V NAME, V_CONTACT, V AREACODE, V PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V CODE VENDOR.V CODE