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

Consider the below table:Products TableColumn NameDatatypeConstraintProd_idNumberPKProd_nameVarchar Prod_list_pricevarchar Cust_credit_limitNumber  What would be the outcome of executing the below SQL statement?select prod_name from products where prod_id in(select prod_id from products where prod_list_price=(select max(prod_list_price) from products where prod_list_price<(select max(prod_list_price)from products)));Select one:a.It shows the names of all products in the table.b.It shown the names of products whose list price is the second highest in the tablec.It produces an errord.It shown the names of all products whose list price is less than the maximum list priceClear my choiceQuestion 9Not yet answeredMarked out of 1.00Flag questionTipsQuestion text_____ is used to retrieve records that do not meet the join conditionSelect one:a.Outer Joinb.Equi Joinc.Non Equi Joind.Self Join