Q89 View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries? (Choose two.)

- (A). Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
- (B). Display suppliers whose PROD_LIST_PRICE is less than 1000
- (C). Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
- (D). Display the total number of products supplied by supplier 102 which have a product status of obsolete
- (E). Display the minimum PROD_LIST_PRICE for each product status
Xem thêm:

Photoluke - Photography Template Kit
Shoots - Photography Elementor Template Kits
Consulting - Business Finance WordPress Theme
Hestia Pro Themes
Clenix - Cleaning Services WordPress Theme
Ella - Multipurpose Shopify Theme OS 2.0
Binim - Lingerie & Bikini Responsive Shopify Theme
Anon - Minimal Responsive Shopify Theme
Minimog - Next-gen Multipurpose Shopify theme grade-A