Which query will output the table contents when the value of the string field P_DESCRIPT include the word ‘hammer’?Select one:a.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT = ‘hammer’;b.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT = ‘%hammer%’;c.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT include ‘hammer’;d.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT like ‘%hammer%’;

Which query will output the table contents when the value of V_CODE is NOT equal to 21344?Select one:a.SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE        FROM PRODUCT              WHERE V_CODE <= 21344;b.SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE        FROM PRODUCT              WHERE V_CODE => 21344;c.SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE        FROM PRODUCT              WHERE V_CODE <> 21344;d.SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE        FROM PRODUCT              WHERE V_CODE = 21344;

Which query produces the discount price and display the discount price in a column labelled DiscountPrice? Discount price is calculated as unit price (P_PRICE) minus the product of discount rate (P_DISCOUNT) and unit price (P_PRICE).Select one:a.​SELECT P_DESCRIPT, P_MIN, P_PRICE, (P_PRICE - P_DISCOUNT) * P_PRICE AS DISCOUNTPRICE        FROM PRODUCT;​b.​SELECT P_DESCRIPT, P_MIN, P_PRICE, (P_PRICE - P_DISCOUNT) / P_PRICE AS DISCOUNTPRICE        FROM PRODUCT;​c.​SELECT P_DESCRIPT, P_MIN, P_PRICE, P_PRICE / P_DISCOUNT - P_PRICE AS DISCOUNTPRICE        FROM PRODUCT;​d.​SELECT P_DESCRIPT, P_MIN, P_PRICE, P_PRICE - (P_DISCOUNT * P_PRICE) AS DISCOUNTPRICE        FROM PRODUCT;

Which query will output the rows where the value of P_PRICE is between 50 and 100 (inclusive)?Select one:a.SELECT *        FROM PRODUCT              WHERE P_PRICE >= 50 AND P_PRICE <=100;b.SELECT *        FROM PRODUCT              WHERE P_PRICE >= 50 OR P_PRICE <=100;c.SELECT *        FROM PRODUCT              WHERE P_PRICE <= 50 AND P_PRICE >=100;d.SELECT *        FROM PRODUCT              WHERE P_PRICE <= 50 AND P_PRICE <=100;

What is the output of the following SQL query? This question is required.*SELECT LOWER('Hello, World!') AS Result;A"hello, world!" Data with column name ‘LOWER(‘Hello, World!’)’.B"HELLO, WORLD!"C"hello, world!" With column name ‘Result’D"H,e,l,l,o, ,W,o,r,l,d,!"

Which SQL statement will list the names and phone numbers of vendors who supply any product with price above $100?Select one:a.​SELECT V_NAME, V_PHONE      FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE              WHERE NOT (P.P_PRICE > 100);​b.​SELECT V_NAME, V_PHONE      FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE        OR P.P_PRICE > 100;​c.SELECT V_NAME, V_PHONE      FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE               WHERE P.P_PRICE > 100;d.​SELECT V_NAME, V_PHONE      FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE              WHERE P.P_PRICE <= 100;