SELECT goods_id, cnt
FROM(
  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
)
WHERE 100 <= cnt
ORDER BY cnt DESC
LIMIT 10