SELECT goods_id, MAX(amount) AS max_amount, MAX_BY(d, amount) AS max_day, MIN(amount) AS min_amount, MIN_BY(d, amount) AS min_day
FROM
(
  SELECT TD_TIME_FORMAT(time, 'yyyy-MM-dd', 'JST') AS d, goods_id, SUM(amount) AS amount
  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'), goods_id
)
GROUP BY goods_id
ORDER BY max_amount DESC
LIMIT 10