Shop: Users with 3+ orders

Medium

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

Return users who have at least 3 orders. Expected columns: user_id, name, orders_cnt.

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

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 строк).