I finally got the solution
SELECT
CASE EXTRACT(HOUR FROM (CONVERT_TZ(created, ‘+00:00’, ‘-04:00’)))
WHEN 0 THEN ‘00:00’
WHEN 1 THEN ‘01:00’
WHEN 2 THEN ‘02:00’
WHEN 3 THEN ‘03:00’
WHEN 4 THEN ‘04:00’
WHEN 5 THEN ‘05:00’
WHEN 6 THEN ‘06:00’
WHEN 7 THEN ‘07:00’
WHEN 8 THEN ‘08:00’
WHEN 9 THEN ‘09:00’
WHEN 10 THEN ‘10:00’
WHEN 11 THEN ‘11:00’
WHEN 12 THEN ‘12:00’
WHEN 13 THEN ‘13:00’
WHEN 14 THEN ‘14:00’
WHEN 15 THEN ‘15:00’
WHEN 16 THEN ‘16:00’
WHEN 17 THEN ‘17:00’
WHEN 18 THEN ‘18:00’
WHEN 19 THEN ‘19:00’
WHEN 20 THEN ‘20:00’
WHEN 21 THEN ‘21:00’
WHEN 22 THEN ‘22:00’
WHEN 23 THEN ‘23:00’
END AS Hours
, SUM(CASE WHEN DAYOFWEEK(created) = 1 THEN 1 ELSE 0 END) AS ‘Sunday’
, SUM(CASE WHEN DAYOFWEEK(created) = 2 THEN 1 ELSE 0 END) AS ‘Monday’
, SUM(CASE WHEN DAYOFWEEK(created) = 3 THEN 1 ELSE 0 END) AS ‘Tuesday’
, SUM(CASE WHEN DAYOFWEEK(created) = 4 THEN 1 ELSE 0 END) AS ‘Wednesday’
, SUM(CASE WHEN DAYOFWEEK(created) = 5 THEN 1 ELSE 0 END) AS ‘Thursday’
, SUM(CASE WHEN DAYOFWEEK(created) = 6 THEN 1 ELSE 0 END) AS ‘Friday’
, SUM(CASE WHEN DAYOFWEEK(created) = 7 THEN 1 ELSE 0 END) AS ‘Saturday’
Group by Hours
Order by Hours