MySQL按小时计算记录计数，即使没有记录的小时也是如此

I want to query for the average of the column values in a table by hour for the past 24 hours. I'm having trouble displaying results even for the hours with no records (in these cases, I should print an average of 0)I want to query for the average of the column v