offene liga ohne feste spieltage/teams abbildbar machen

[steam0r]

dann irgendwie nach gewinnquotient die tabelle bilden:

https://www.evanmiller.org/how-not-to-sort-by-average-rating.html

    SELECT
        name,
        wins,
        losses,
        ((wins + 1.9208) / (wins + losses) - 1.96 * SQRT((wins * losses) / (wins + losses) + 0.9604) / (wins + losses)) / (1 + 3.8416 / (wins + losses)) AS ci_lower_bound 
    FROM (
        SELECT 
            team.name as names, 
            sum(win) as wins,
            sum(loss) as losses
        FROM team_scores
        JOIN teams as team ON team.id = team_id
        WHERE gameDay_id >= 866 AND gameDay_id <= 1001
        GROUP BY team_id
    ) as scores
    WHERE wins + losses > 0
    ORDER BY ci_lower_bound DESC;