SELECT `res_0`, count(DISTINCT `t1`.`pull`) AS `res_1`, `res_2`
FROM (
select build_type,
job_name, job_id, commit, branch, pull, run_timestamp
from `test_results/test_runs_column`
) AS `t1`
WHERE `t1`.`job_name` = 'PR-check' GROUP BY DateTime::MakeDatetime(DateTime::StartOf(`t1`.`run_timestamp`, DateTime::IntervalFromDays(1))) AS `res_0`, CASE WHEN (`t1`.`pull` LIKE '%_A1') THEN 1 WHEN (`t1`.`pull` LIKE '%_A2') THEN 2 WHEN (`t1`.`pull` LIKE '%_A3') THEN 3 ELSE 1 END AS `res_2`
LIMIT 1000001
Error
query
db monitoring https://nda.ya.ru/t/qO-4rUNt78RtEx Cloud of db https://nda.ya.ru/t/JZwCs8zs79nrsc