SQL

SQL Playground

Run real SQL against the FreshMart database — DuckDB-WASM, fully in your browser

Interactive April 2026

DuckDB-WASM

6 tablesFreshMart DBNo install100% local

Ctrl + Enter to run

// 8 challenges

Loading FreshMart DB…
-- Welcome to the FreshMart SQL Playground
-- Pick a challenge on the left, or write your own query below

SELECT first_name, last_name, city, loyalty_tier
FROM customers
ORDER BY loyalty_tier
LIMIT 10;Ctrl + Enter to run
Loading FreshMart database in your browser…

// Schema reference

stores

PK: store_id

store_name

city

monthly_target

customers

PK: customer_id

first_name

loyalty_tier

joined_date

orders

PK: order_id

customer_id

store_id

total_amount

order_items

PK: item_id

order_id

product_id

quantity

line_total

products

PK: product_id

product_name

Discussion

Have a better approach? Found something outdated? Share it — your knowledge helps everyone learning here.

Continue with GitHub