SELECT *,(kills_column/deaths_column) AS kdratio from STATS ORDER BY kdratio DESC

SELECT *, SUM(Wins + Losses) AS GamesPlayed FROM stats ORDER BY GamesPlayed DESC LIMIT 100 OFFSET <index>