/
isadoraf
/
MyWorkComp
Обзор
Документация
Войти
/
isadoraf
/
MyWorkComp
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
PostgreSQL/SQL_beginner.Team01-1/src/ex01/team01_ex01.sql
21 строка
1 KB
isadoraf
upgrade Repository
19 фев 2026, 10:44
19 фев 2026, 10:44
be1ac9e
Код
Авторство
О чём код?
insert into currency values (100, 'EUR', 0.85, '2022-01-01 13:29'); insert into currency values (100, 'EUR', 0.79, '2022-01-08 13:29'); SELECT COALESCE("user".name, 'not defined') AS name, COALESCE("user".lastname, 'not defined') AS lastname, c.name AS currency_name, COALESCE((SELECT rate_to_usd FROM currency WHERE updated = (SELECT MAX(updated) FROM currency WHERE updated < b.updated AND id = b.currency_id) AND id = b.currency_id), (SELECT rate_to_usd FROM currency WHERE updated = (SELECT MIN(updated) FROM currency WHERE updated >= b.updated AND id = b.currency_id) AND id = b.currency_id)) * b.money AS currency_in_usd FROM (SELECT * FROM balance WHERE currency_id IN (SELECT id FROM currency)) b LEFT JOIN "user" ON "user".id = b.user_id JOIN (SELECT DISTINCT id, name FROM currency) c ON c.id = b.currency_id ORDER BY 1 DESC, 2, 3;