/
isadoraf
/
MyWorkComp
Обзор
Документация
Войти
/
isadoraf
/
MyWorkComp
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
PostgreSQL/SQL_beginner.Day02-1/src/ex02/day02_ex02.sql
30 строк
864 B
isadoraf
upgrade Repository
19 фев 2026, 10:44
19 фев 2026, 10:44
be1ac9e
Код
Авторство
О чём код?
SELECT COALESCE(p.name, '-') person_name, pv.visit_date, COALESCE(pi.name, '-') pizzeria_name FROM ( SELECT * FROM person_visits WHERE visit_date BETWEEN '2022-01-01' AND '2022-01-03' ) pv FULL JOIN pizzeria pi ON pi.id = pv.pizzeria_id FULL JOIN person p ON pv.person_id = p.id ORDER BY 1, 2, 3; -- SELECT -- CASE -- WHEN p.name IS NULL THEN '-' -- ELSE p.name -- END AS person_name, -- pv.visit_date, -- CASE -- WHEN pi.name IS NULL THEN '-' -- ELSE pi.name -- END AS pizzeria_name -- FROM ( -- SELECT * -- FROM person_visits -- WHERE -- visit_date BETWEEN '2022-01-01' AND '2022-01-03' -- ) pv -- FULL JOIN pizzeria pi ON pv.pizzeria_id = pi.id -- FULL JOIN person p ON pv.person_id = p.id -- ORDER BY 1, 2, 3;