Запрос к сервису кф

select
    count(*)
    --,case when "userId" =1 then '44' else 'em' end
From "httpActions"
where 1=1
and "dateTime">'2023-12-11'
and "dateTime"<'2024-12-31'
and "uri" like '%comfinorgcheckapi?inn=%'
--group by case when "userId" =1 then '44' else 'em' end
-- and "uri" like 'http://estore.gz-spb.ru/electronicshop/procedure/comfinorgcheckapi?inn=%'