SELECT sales, COUNT(1) AS cnt
FROM
(
  SELECT TD_TIME_FORMAT(time, 'yyyy-MM-dd', 'JST') AS d, SUM(price * amount)/1000000 AS sales
  FROM sales_slip
  WHERE TD_TIME_RANGE(time, '2006-01-01', '2007-01-01','JST')
  GROUP BY TD_TIME_FORMAT(time, 'yyyy-MM-dd', 'JST')
)
GROUP BY sales
ORDER BY sales