[Solved] count(*) column to the right of the data? [closed]

Just switch name and count in your select

select name,count(*) from db.db group by name order by name desc