How can I find my top 10 spenders in my game over a particular period of time?

You want to know which of your users have spent the most money in your game over a certain period of time.

SELECT customer_user_id, cnt1 FROM ( SELECT customer_user_id, sum(amount) AS cnt1 FROM cooladata WHERE date_range(last 7 days)  GROUP BY customer_user_id ORDER BY cnt1 DESC LIMIT 10 ) ORDER BY cnt1 DESC