logo

Oracle NextGen

score

SQL Challenge

Challenge #1 – Select All Products

EasyGo Back
Challenge Overview
Retrieve all products from the products table. This is a basic SELECT query to get familiar with querying data.

Requirements

  • •Return all columns from the products table.
  • •Return all rows without any filtering.
  • •No specific ordering required.
Sample Dataset
Preview the schema and seeded rows you can query against.

products

Contains product information.

Columns
NameTypeNotes
product_idINTPrimary key
product_nameVARCHARProduct name
priceDECIMALProduct price
categoryVARCHARProduct category
Sample Rows
product_idproduct_namepricecategory
1Laptop999.99Electronics
2Mouse25.5Electronics
3Desk299Furniture
4Chair150Furniture
SQL Playground
Loading editor…

Result Preview

Awaiting Run

Run your query to see the dataset preview.