统计问题。急！！

[daozhou]

select DEST_TERMID,count(DEST_TERMID) as cont from DB_SWG_DX_NEW.sms.T_SUBMIT where SRV_CODE='WZD' group by DEST_TERMID

得出结果是
DEST_TERMID,cont
3267378 22
0082778 10
0090223 9
0094063 5
0097185 9
9002212 2
9003388 2
9006486 1
9007618 18
9011991 1
9014101 3
9014620 2
9016690 4
9017577 3
9020785 55
现在我想只显示 cont 〉20的号码怎么写啊？高手帮忙啊

[godhuang]

select DEST_TERMID,count(DEST_TERMID) as cont from DB_SWG_DX_NEW.sms.T_SUBMIT where SRV_CODE='WZD' group by DEST_TERMID having count(DEST_TERMID) > 20

[godhuang]

select DEST_TERMID,count(DEST_TERMID) as cont from DB_SWG_DX_NEW.sms.T_SUBMIT where SRV_CODE='WZD' group by DEST_TERMID having count(DEST_TERMID) > 20

[phantomMan]

select DEST_TERMID,count(DEST_TERMID) as cont
from DB_SWG_DX_NEW.sms.T_SUBMIT
where SRV_CODE='WZD' and count(DEST_TERMID)>20
group by DEST_TERMID

[子陌红尘]

select
DEST_TERMID,
count(DEST_TERMID) as cont
from
DB_SWG_DX_NEW.sms.T_SUBMIT
where
SRV_CODE='WZD'
group by
DEST_TERMID
having
count(DEST_TERMID) > 20

[daozhou]

谢谢各位了！！！