query.sql

SELECT views, case WHEN (hour(now()) + x) >= 24 THEN (hour(now()) + x) - 24 ELSE hour(now()) + x END AS part FROM long_sequence(24),
JOIN (SELECT count() as views, hour(timestamp) as part FROM hits WHERE timestamp > dateadd('d', -1, now()) GROUP BY part) as b
ON part = b.part

Current results.

"views","part"
7,10
118,10
7,11
118,11
7,12
118,12
7,13
118,13
7,14
118,14
7,15
118,15
7,16
118,16
7,17
118,17
7,18
118,18
7,19
118,19
7,20
118,20
7,21
118,21
7,22
118,22
7,23
118,23
7,0
118,0
7,1
118,1
7,2
118,2
7,3
118,3
7,4
118,4
7,5
118,5
7,6
118,6
7,7
118,7
7,8
118,8
7,9
118,9