## Контекст (таблицы и пример данных) ### Таблицы - `orders(id, created_at, status, total_amount)`
SQL Developer
Senior
## Контекст (таблицы и пример данных)
### Таблицы
- `orders(id, created_at, status, total_amount)`
### Пример данных
**orders**
| id | created_at | status | total_amount |
|---:|------------|-----------|-------------:|
| 1 | 2025-01-01 | paid | 100 |
| 2 | 2025-01-01 | cancelled | 50 |
| 3 | 2025-01-02 | paid | 70 |
---
## Задача
Сделать pivot-таблицу по дням: суммы `total_amount` по статусам в отдельные колонки `paid_sum`, `cancelled_sum`.
Вернуть: `day`, `paid_sum`, `cancelled_sum`.
Ответы
```sql
SELECT
created_at::date AS day,
SUM(total_amount) FILTER (WHERE status = 'paid') AS paid_sum,
SUM(total_amount) FILTER (WHERE status = 'cancelled') AS cancelled_sum
FROM orders
GROUP BY created_at::date
ORDER BY day;
```