SQL使用group by如何使用

大家看下图求帮忙解决

为什么不直接用where？
select count(*) as cc, orderuserid from orders
where convert(varchar(10)...
group by orderuserid
order by cc desc

那就先根据日期select出来，然后外面再套一层 select * from (select xxx from xxx where xxxx) group by xxx

 select cornr ( * ) as cc, OrderUserID from Orders 
group by OrderUserID 
having  Convert(VARCHAR(10),MIN(ConsigneeDateTime,120) >= '2013-10-1'

order by cc desc