select datepart(hour,time) hour,count(1) count from table
where
Similarity<75
group by datepart(hour,time)
order by count desc
From:https://www.cnblogs.com/xuejianxiyang/p/11202931.html
原文：https://www.cnblogs.com/xuejianxiyang/p/11202931.html