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;

Which SQL statement to display the products that have the price between RM50 and RM100a.SELECT * FROM Products WHERE Price &lt;50 AND 100&gt;b.SELECT * FROM Products WHERE Price LIKE 50 AND 100c.SELECT * FROM Products WHERE Price BETWEEN 50 OR 100d.SELECT * FROM Products WHERE Price BETWEEN 50 AND 100

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 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;

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%’;