MySQL row values ​​count WHERE column = value

Question

I have a database that looks something like this:

I want to make a MySQL query where I count the votes for each id and order them starting from the highest. I want the result to be as follows:

Is this possible if you do not make 3 requests inside each other?

Answer 1

select name, sum(votes) as total_votes from mytable group by 1 order by 2 desc