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
hey guys how to determine which task requires a subquery
?plz explain
you can try to answer the task mentally,and you will find if you need to use a subquery or it will be done with a simple query.
C and D
For A
SELECT MIN(LIST_PRICE)
FROM PRODUCTION_INFORMATION
GROUP BY PDT_STATUS;
For B
SELECT SUP_ID
FROM PRODUCTION_INFORMATION
GROUP BY PDT_STATUS
HAVING AVG(LIST_PRICE)>500;
For D
SELECT COUNT(PDT_ID)
FROM PRODUCTION_INFORMATION
WHERE SUP_ID = 102071
AND PDT_STATUS = “OBSOLETE”
last query is for E