MySQL count row values WHERE column = value

Question

I have a database that looks pretty much like this:

I wanna make a MySQL query where I count the votes for each id and order them by starting from the highest. I want the output to be like:

Is it possible without making like 3 queries inside each other?

Answer 1

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