SELECT member_id, price, amount, price * amount AS sales
FROM sales_slip
WHERE TD_TIME_RANGE(time, '2006-05-01', '2006-06-01','JST')
ORDER BY sales DESC
LIMIT 10