SELECT goods_id, COUNT(1) AS cnt
FROM sales_slip
WHERE TD_TIME_RANGE(time, '2006-05-01', '2006-06-01','JST')
GROUP BY goods_id
HAVING 100 <= COUNT(1)
ORDER BY cnt DESC
LIMIT 10