Group conditions · 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 (Category(category) = 'Stationery' or Category(category) = 'Accessories') and Stock(stock) is at least 10.
Learning objectives and tables
- Name (name)
- Price (KRW) (price)
- ((Category (category) = 'Stationery') OR (Category (category) = 'Accessories'))
- (Stock (stock) >= 10)
products (Products): id (ID), name (Name), category (Category), price (Price (KRW)), stock (Stock)
Concepts to review
Practice opens in this page’s language. Change it in the practice options at any time.