Products above average price · Study guide
Identify the required rows and columns and decide how to group the conditions. Open the practice screen to write SQL and inspect the results.
From Products(products), show Name(name) → Price (KRW)(price) in this order. Keep only rows where Price (KRW)(price) is greater than (calculate with a subquery: Use these tables: Products(products). Show these values in this order: average (Price (KRW)(price)).).
Learning objectives and tables
- Name (name)
- Price (KRW) (price)
- (Price (KRW) (price) > (calculate with a subquery: Use these tables: Products (products). Show these values in this order: average (Price (KRW) (price)).))
products (Products): id (ID), name (Name), category (Category), price (Price (KRW)), stock (Stock)
Concepts to review
Practice: Products above average price
Practice opens in this page’s language. Change it in the practice options at any time.