Which SQL statement to display the products that have the price between RM50 and RM100a.SELECT * FROM Products WHERE Price <50 AND 100>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 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 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 statement would you use to query the database for the quantity and description of each item thatwas ordered before June 1, 1999, and whose price is less than 0.25 or greater than 10.00?

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