How to find recent login attempts?

select username, count(*)
from knta_logon_attempts
where creation_date > sysdate - 1
group by username
order by username