/
vibecoder123
/
GraphProcessorFork
Обзор
Документация
Войти
/
vibecoder123
/
GraphProcessorFork
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
SQLScripts/Views/user_tourist_status_view.sql
18 строк
738 B
vibecoderhex
added user_tourist_status_view.sql
21 апр 2026, 00:39
21 апр 2026, 00:39
fb3490b
Код
Авторство
О чём код?
CREATE OR REPLACE VIEW user_tourist_status AS SELECT "user".first_name, "user".last_name, SUM(processing_result.total_distance) AS sum_of_distances, CASE WHEN SUM(processing_result.total_distance) < 1000 THEN 'Beginner' WHEN SUM(processing_result.total_distance) >= 1000 AND SUM(processing_result.total_distance) <= 10000 THEN 'Intermediate' ELSE 'Master' END AS tourist_status FROM "user" JOIN graph ON "user".user_id = graph.user_id JOIN processing_result ON graph.graph_id = processing_result.graph_id GROUP BY "user".first_name, "user".last_name ORDER BY sum_of_distances DESC; SELECT * FROM user_tourist_status;