/
isadoraf
/
MyWorkComp
Обзор
Документация
Войти
/
isadoraf
/
MyWorkComp
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
PostgreSQL/SQL_beginner.Day07-3/src/ex02/day07_ex02.sql
22 строки
512 B
isadoraf
upgrade Repository
19 фев 2026, 10:44
19 фев 2026, 10:44
be1ac9e
Код
Авторство
О чём код?
( SELECT pi.name name, COUNT(pi.name) count, 'order' action_type FROM pizzeria pi INNER JOIN menu m ON pi.id = m.pizzeria_id INNER JOIN person_order po ON m.id = po.menu_id GROUP BY pi.name ORDER BY 2 DESC LIMIT 3 ) UNION ( SELECT pi.name name, COUNT(pi.name) count, 'visit' action_type FROM pizzeria pi INNER JOIN person_visits pv ON pi.id = pv.pizzeria_id GROUP BY pi.name ORDER BY 2 DESC LIMIT 3 ) ORDER BY 3 ASC, 2 DESC;