计算两个日期之间的差异并计算出现的次数

I am trying to calculate the difference between two dates and in the same query trying to count the frequency of occurence.I am trying to calculate the difference between