Problema con query simple de mysql

[vikutor]

select count(firma)as firma, total from mitabla group by firma order by total desc limit 5