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:

YITH WooCommerce Quick View Premium
Porto | Multipurpose & WooCommerce Theme
YITH Product Size Charts for WooCommerce Premium
Avada Theme
Elementor PRO và Pro Templates
Betheme 27.2.12
The7 - Ultimate Website & Online Store Builder for WordPress and WooCommerce