Usa questa

SELECT id, sum(punteggio) as tot
FROM tabella
group by id_account
having tot > 10
order by tot