select TOB.id_obra, TOB.nome_artista, TOB.nome_obra, TOB.tecnica, count(TV.id_obra) as total_votos
from tb_voto TV, tb_obra TOB
WHERE TV.id_obra = TOB.id_obra
group by TV.id_obra
order by total_votos desc