Delivery: Клиенты без доставок

Medium

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

Выведите клиентов, у которых нет заказов со статусом delivered. Ожидаемые колонки: customer_id, full_name

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

PRAGMA foreign_keys = ON;
  CREATE TABLE customers (id INTEGER PRIMARY KEY, full_name TEXT NOT NULL, city TEXT NOT NULL);
  CREATE TABLE restaurants (id INTEGER PRIMARY KEY, name TEXT NOT NULL, city TEXT NOT NULL);
  CREATE TABLE menu_items (id INTEGER PRIMARY KEY, restaurant_id INTEGER NOT NULL, item_name TEXT NOT NULL, price INTEGER NOT NULL, category TEXT NOT NULL,
    FOREIGN KEY(restaurant_id) REFERENCES restaurants(id));
  CREATE TABLE orders (id INTEGER PRIMARY KEY, customer_id INTEGER NOT NULL, restaurant_id INTEGER NOT NULL, ordered_at TEXT NOT NULL, status TEXT NOT NULL, delivery_fee INTEGER NOT NULL,
    FOREIGN KEY(customer_id) REFERENCES customers(id), FOREIGN KEY(restaurant_id) REFERENCES restaurants(id));
  CREATE TABLE order_items (id INTEGER PRIMARY KEY, order_id INTEGER NOT NULL, menu_item_id INTEGER NOT NULL, qty INTEGER NOT NULL,
    FOREIGN KEY(order_id) REFERENCES orders(id), FOREIGN KEY(menu_item_id) REFERENCES menu_items(id));

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

customers

id	full_name	city
1	Customer 1	Utrecht
2	Customer 2	Rotterdam
3	Customer 3	Eindhoven
4	Customer 4	Amsterdam
5	Customer 5	Utrecht

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

menu_items

id	restaurant_id	item_name	price	category
1	2	Item 1	7	Burger
2	3	Item 2	9	Salad
3	4	Item 3	11	Sushi
4	5	Item 4	13	Dessert
5	6	Item 5	15	Pizza

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

order_items

id	order_id	menu_item_id	qty
1	2	2	2
2	3	3	3
3	4	4	1
4	5	5	2
5	6	6	3

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

orders

id	customer_id	restaurant_id	ordered_at	status	delivery_fee
1	2	2	2026-01-02 13:00:00	delivered	3
2	3	3	2026-01-03 14:00:00	delivered	4
3	4	4	2026-01-04 15:00:00	delivered	5
4	5	5	2026-01-05 16:00:00	delivered	6
5	6	6	2026-01-06 17:00:00	delivered	2

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

restaurants

id	name	city
1	Restaurant 1	Utrecht
2	Restaurant 2	Rotterdam
3	Restaurant 3	Eindhoven
4	Restaurant 4	Amsterdam
5	Restaurant 5	Utrecht

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

Ваш SQL

Результат

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