View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries?
View the Exhibit and examine the structure of the PRODUCTS table.Which two tasks require subqueries? (Choose two.) A. Display suppliers whose PROD_LIST_PRICE is less than 1000 B. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is… Read More »