Query: Failed Login Attempts Over Time

select
  date_trunc('hour', created_at) as "Hour",
  count(*) as "Failed Logins"
from
  github_security_log
where
  action = 'user.failed_login'
group by
 "Hour"
order by
  "Hour" DESC;