SELECT top 10 UserID, COUNT(*) AS Expr1
FROM MoneyLog
WHERE (WriteTime BETWEEN '2005-09-12' AND '2005-09-18') AND (ModeName <> '充值')
AND (SourceName IN ('10111', '10105', '10102', '10101', '10110', '10107', '10108',
'10070', '10081'))
GROUP BY UserID
HAVING (COUNT(*) > 20)
order by expr1
FROM MoneyLog
WHERE (WriteTime BETWEEN '2005-09-12' AND '2005-09-18') AND (ModeName <> '充值')
AND (SourceName IN ('10111', '10105', '10102', '10101', '10110', '10107', '10108',
'10070', '10081'))
GROUP BY UserID
HAVING (COUNT(*) > 20)
order by expr1