/
vaiforic
/
abd6
Обзор
Документация
Войти
/
vaiforic
/
abd6
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
request.sql
20 строк
589 B
vaiforic-lin-nt
lab4 and lab3
30 май 2026, 05:33
30 май 2026, 05:33
46bc341
Код
Авторство
О чём код?
select a.status, a.city, count(*) as join_rows, avg(a.numeric_attr_1 + b.numeric_attr_2 + c.score_1) as avg_metric from public.synthetic_data as a join public.synthetic_data as b on a.status = b.status and a.city = b.city join public.synthetic_data as c on b.text_attr_2 = c.text_attr_2 and (a.int_attr_1 % 100) = (c.int_attr_1 % 100) where extract( year from a.date_attr_1 ) = 2023 and a.bool_attr_1 = true and b.score_1 between 50 and 90 and c.bool_attr_2 = false group by a.status, a.city order by join_rows desc limit 20;