Computers and Technology
evaluate this sql statement: select product id, product name, price from product where supplier id in (select supplier id from product where price > 120 or qty in stock > 100); which values will be displayed? a. the product id, product name, and price of products that are priced greater than $120.00 and have a qty in stock value greater than 100 b. the product id, product name, and price of products that are priced greater than $120.00 or that have a qty in stock value greater than 100 c. the product id, product name, and price of products that are priced greater than $120.00 or that have a qty in stock value greater than 100 and have a supplier d. the product id, product name, and price of products supplied by a supplier with products that are priced greater than $120.00 or with products that have a qty in stock value greater than 100