Unique value and descending sort?

Question

SQL

Answer 1

SELECT name,  SUM(viewersCount) AS viewersCount
FROM   games_stat
GROUP BY name
ORDER BY viewersCount DESC