logo

Oracle NextGen

score

SQL Challenge

Challenge #3 – Filter by Price

EasyGo Back
Challenge Overview
Find all products that cost less than $100.

Requirements

  • •Return columns: product_name, price.
  • •Filter for products with price less than 100.
  • •Order by price ascending.
Sample Dataset
Preview the schema and seeded rows you can query against.

products

Contains product catalog.

Columns
NameTypeNotes
product_idINTPrimary key
product_nameVARCHARProduct name
priceDECIMALProduct price
Sample Rows
product_idproduct_nameprice
1Keyboard45.99
2Monitor249.99
3Mouse Pad12.5
4USB Cable8.99
5Webcam89.99
SQL Playground
Loading editor…

Result Preview

Awaiting Run

Run your query to see the dataset preview.