Query: guardrails_control_invalid_between_90_365_days

with between_90_365_days as 
(
  select
    now()::date - update_timestamp::date as days 
  from
    guardrails_control 
  where
    update_timestamp between symmetric (now() - '90 days'::interval) and 
    (
      now() - '365 days'::interval
    )
    and state = 'invalid' 
)
select
  count(*) as value,
  '90-365 Days' as label 
from
  between_90_365_days;