SELECT ROW_NUMBER() OVER (ORDER BY 1.0 * kills / deaths DESC), Pos, kills, deaths, auth FROM tablename WHERE enabled = 1 AND kills > 0 AND deaths > 0 AND kills > 100;
deaths DESC)