SQL Sum(Case When 统计日期

[天生一对小角]

"Select 处理,Sum(Case When Id in('100') and Datediff(d,sdate,'" & Date & "')<2 Then 1 else 0 end) as '<3天',Sum(Case When Id in('100') and Datediff(d,sdate,'" & Date & "')=2 Then 1 else 0 end) as '=3天',Sum(Case When Id in('100') and Datediff(d,sdate,'" & Date & "')>30 Then 1 else 0 end) as '=3天' From tb_AAAA Group by 处理"

数据库中没有>30的日期，所有数据都不能显示，怎么解决。