/
isadoraf
/
MyWorkComp
Обзор
Документация
Войти
/
isadoraf
/
MyWorkComp
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
PostgreSQL/SQL_beginner.Day00-2/src/ex09/day00_ex09.sql
18 строк
448 B
isadoraf
upgrade Repository
19 фев 2026, 10:44
19 фев 2026, 10:44
be1ac9e
Код
Авторство
О чём код?
SELECT ( SELECT name FROM person WHERE person.id = pv.person_id ) AS person_name, ( SELECT name FROM pizzeria WHERE pizzeria.id = pv.pizzeria_id ) AS pizzeria_name FROM ( SELECT person_id, pizzeria_id FROM person_visits WHERE visit_date BETWEEN '2022-01-07' AND '2022-01-09' ) AS pv ORDER BY person_name ASC, pizzeria_name DESC;