Level 1 - Question 2: Filter Products by Price

Scenario

You are managing an online store's inventory. The manager wants a list of products that cost more than 100 units so they can consider them for a premium promotion.

Task

Write a query to display the product name of all items that are priced above 100.

Sample Schema: products

SELECT product_name
FROM products
WHERE price > 100;