Find part of a name · 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 (Name(name) LIKE '%cup%').
Learning objectives and tables
- Name (name)
- Price (KRW) (price)
- (Name (name) LIKE '%cup%')
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.