View the Exhibit and examine the data in the PRODUCT INFORMATION table.
Which two tasks would require subqueries? (Choose two.)
A.
displaying the minimum list price for each product status
B.
displaying all supplier IDs whose average list price is more than 500
C.
displaying the number of products whose list prices are more than the average list price
D.
displaying all the products whose minimum list prices are more than the average list price of
products having the product status orderable
E.
displaying the total number of products supplied by supplier 102071 and having product status
OBSOLETE
C, D
select min(list_price), pdt_status from product group by pdt_status;
select sup_id, list_price from product having avg(list_price) > 500 group by sup_id,list_price;
select pdt_id from product where list_price> (select avg(list_price) from product) and pdt_status=’orderable’;(C & D)
select count(*) from product where pdt_status=’obselete’ group by sup_id