## Контекст (таблицы и пример данных) ### Таблицы - `users(id, full_name, email, city, age, registe
SQL Developer
Senior
## Контекст (таблицы и пример данных)
### Таблицы
- `users(id, full_name, email, city, age, registered_at)`
- `orders(id, user_id, order_date, amount, status)`
- `payments(id, order_id, payment_date, payment_type, paid_amount)`
### Пример данных
**users**
| id | full_name | email | city | age | registered_at |
|---:|--------------|----------------|----------|----:|---------------|
| 1 | Ivan Petrov | ivan@mail.com | Helsinki | 29 | 2025-01-10 |
| 2 | Anna Ivanova | anna@gmail.com | Espoo | 34 | 2025-02-01 |
| 4 | No Orders | no@ex.com | Espoo | 22 | 2025-02-10 |
**orders**
| id | user_id | order_date | amount | status |
|---:|--------:|-----------|-------:|--------|
| 10 | 1 | 2025-03-01| 120.00 | paid |
| 11 | 2 | 2025-03-02| 250.00 | new |
**payments**
| id | order_id | payment_date | payment_type | paid_amount |
|----:|---------:|-------------|--------------|------------:|
| 100 | 10 | 2025-03-01 | card | 120.00 |
---
## Задача
Найти пользователей, у которых нет заказов.
Ответы
```sql
SELECT u.*
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE o.id IS NULL;
```