1
A customer asks
Which dairy products cost less than 100 som?
Every customer has their own voice and request. In Kyrgyz, Russian, English, Kazakh, Uzbek and Tajik.
REAL PostgreSQL29 STAGES · FREE3D · WITH VOICE
Shopkeeper Boy
Run a village shop. A customer asks — you write SQL — the boy shows it on the shelf.
Sign in to play — signing up takes a minute
- stages
- 29
- tables
- 7
- customers
- 4
- installs
- 0
HOW IT WORKS
One customer, one lesson
2
You write SQL
Real PostgreSQL runs right in the browser. Make a mistake and it explains it plainly.
3
The boy shows it
1Kefir60 som
2Milk75 som
3Kurut90 som
He walks to every product in the result, in order, and names it. ORDER BY, right before your eyes.
The shop’s customers
Each comes with their own question — tap 🔊
Grandma Burul
neighbour
«What's in the bread section? Name and price. (The bread section is number 1.)»
Mr Bakyt
shop owner
«How many products are in each section? Section number and count.»
Ms Gulnara
teacher
«Hello! What costs less than 100 som? Name and price.»
Aiperi
pupil
«I want to buy my mum a present! Which 3 products are the most expensive? Name and price, priciest first.»
The shopkeeper boy
your helper
Runs your SQL queries.
7 chapters · 29 stages
0 / 29
- 2The customer choosesWHERE · AND · OR · IN · LIKE · NULL
- 3Put it in orderORDER BY · LIMIT · DISTINCT
- 4The owner's reportCOUNT · SUM · AVG · GROUP BY · HAVING
- 5Connect the tablesJOIN · LEFT JOIN
- 6The storeroomINSERT · UPDATE · DELETE
- 7The smart shopkeepersubquery · CASE · dates · BEGIN
Real PostgreSQL
Nothing to install on school computers — it runs inside the browser.
Mistakes teach
“I don’t understand FORM — did you mean FROM?”
No memorising
Your query is also checked in 2 hidden shops.
With voice
Customers talk and the boy names the products.
Your first customer is waiting
Sign in to play — signing up takes a minute