SELECT
started_at::DATE AS date,
count(distinct query_id) AS query_count,
count(distinct created_by_id) AS unique_users
from "BI_ANALYTICS"."VELOCITY_APP_PROD"."QUERY_RUNS"
where started_at::DATE between '2022-06-15' and '2022-07-10'
and statement ilike '%avalanche%'
and execution_type = 'REALTIME'
group by date