mysql sorting and between using a sub query
===

I am executing a query in which i use joins. In that i have used a subquery which will total amount. i want to sort by the result of the subquery  like the following.

    "select users.*, (select sum(amount) as camount from donation where donation.uid=users.id) as camount from users where users.confirmed=1  and camount between 3 and 5 order by camount";

I get an error: 1064.

How to query by sotring using the result of a sub query?