这个查询，应该怎么写呢？

[linshilong]

SELECT ip,count(ip) as a
FROM [WZll].[dbo].[CnzzContent17] as main 
where dtime between '2013-01-10 00:00:00' and '2013-01-17 23:59:59' 
and lzi like '%baidu%' 
and Zluye like '%?%' 
group by ip 
order by a desc

下面是我的，查询结果
ip a
220.161.148.210 22
220.161.148.211 16
220.161.148.212 10
220.161.148.213 9
220.161.148.214 8
220.161.148.215 8
220.161.148.216 8
220.161.148.217 8
220.161.148.218 7
220.161.148.219 7
现在我只想让a的查询结果，大于8的出现也就是下面的结果
ip a
220.161.148.210 22
220.161.148.211 16
220.161.148.212 10
220.161.148.213 9
220.161.148.214 8
220.161.148.215 8
220.161.148.216 8
220.161.148.217 8

要上面的查询结果，语句应该怎么写呢

[饮水需思源]

SELECT ip,count(ip) as a 
FROM [WZll].[dbo].[CnzzContent17] as main  
where dtime between '2013-01-10 00:00:00' and '2013-01-17 23:59:59' and lzi like '%baidu%' and Zluye like '%?%' 
group by ip HAVING COUNT(IP)>=8
order by a desc

[骑着蜗牛去爬山]

SELECT ip,count(ip) as a FROM [WZll].[dbo].[CnzzContent17] as main where dtime between '2013-01-10 00:00:00' and '2013-01-17 23:59:59' and lzi like '%baidu%' and Zluye like '%?%' group by ip having count(ip)>=8 order by a desc