SELECT
SUM(puan) AS tpuan,
SUM(averaj) AS taveraj,
takim
FROM takim
GROUP BY takim
ORDER BY tpuan DESC,taveraj DESC