Query Run
select SUBSTRING(rc_timestamp,1,10) as hour, count(*),... 9 years ago