Shop: Users from Amsterdam

Easy

Войдите, чтобы сохранялся прогресс.

Return all users who live in Amsterdam. Expected columns: id, name, city.

Структура таблиц

PRAGMA foreign_keys = ON;

  CREATE TABLE users (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    city TEXT NOT NULL,
    created_at TEXT NOT NULL
  );

  CREATE TABLE products (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    category TEXT NOT NULL,
    price REAL NOT NULL
  );

  CREATE TABLE orders (
    id INTEGER PRIMARY KEY,
    user_id INTEGER NOT NULL,
    status TEXT NOT NULL,
    ordered_at TEXT NOT NULL,
    FOREIGN KEY(user_id) REFERENCES users(id)
  );

  CREATE TABLE order_items (
    order_id INTEGER NOT NULL,
    product_id INTEGER NOT NULL,
    qty INTEGER NOT NULL,
    PRIMARY KEY(order_id, product_id),
    FOREIGN KEY(order_id) REFERENCES orders(id),
    FOREIGN KEY(product_id) REFERENCES products(id)
  );

Пример данных

order_items

order_id	product_id	qty
1	2	2
1	5	1
2	3	3
2	6	2
3	4	1

Показано строк: 5 (LIMIT 5)

orders

id	user_id	status	ordered_at
1	2	shipped	2026-01-02
2	3	delivered	2026-01-03
3	4	cancelled	2026-01-04
4	5	paid	2026-01-05
5	6	shipped	2026-01-06

Показано строк: 5 (LIMIT 5)

products

id	name	category	price
1	Laptop	Electronics	999.0
2	Mouse	Electronics	25.0
3	Keyboard	Electronics	70.0
4	Coffee beans	Grocery	12.5
5	Pasta	Grocery	3.2

Показано строк: 5 (LIMIT 5)

users

id	name	city	created_at
1	User 1	Berlin	2026-01-02
2	User 2	Paris	2026-01-03
3	User 3	Warsaw	2026-01-04
4	User 4	Rome	2026-01-05
5	User 5	Amsterdam	2026-01-06

Показано строк: 5 (LIMIT 5)

Ваш SQL

Результат

Результат пуст (0 строк).