View the Exhibit and examine the structure of the PRODUCT_INFORMATION and
INVENTORIES tables. You have a requirement from the supplies department to give a list
containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products
wherein QUANTITY_ON_HAND is less than five. Which two SQL statements can
accomplish the task? (Choose two.)
A.
SELECT i.product_id, i.quantity_on_hand , pi.supplier_id FROM product_information pi
JOIN inventories i ON (pi. product_id=i. product_id) WHERE quantity_on_hand < 5;
B.
SELECT i.product_id, i.quantity_on_hand , pi.supplier_id FROM product_information pi
JOIN inventories i ON (pi. product_id=i. product_id) AND quantity_on_hand < 5;
C.
SELECT product_id, quantity_on_hand , supplier_id FROM product_information
NATURAL JOIN inventories AND quantity_on_hand < 5;
D.
SELECT i.product_id, i.quantity_on_hand , pi.supplier_id FROM product_information pi
JOIN inventories i USING (product_id) AND quantity_on_hand < 5;
Explanation: