I've got this at the end of my SQL:

ORDER BY metal, amount DESCENDING

It puts it in order by metal, but not by amount. I have no idea why.

Thanks,

Michelle