select trunc(last_connection_date) day_of_year, count(*) number_of_users
from gui_users
where last_connection_date is not null
group by trunc(last_connection_date)
order by 1 desc;