[Solved] Mysql team/score [closed]

by


I’m answering this because it’s non-trivial and because I want to see if I can actually do it :p

SELECT `ID_PLAYER`, COUNT(*) AS `MATCH_WIN` FROM
    (SELECT
        IF(`SCORE_PLAYER1`>`SCORE_PLAYER2`, `ID_PLAYER1`, `ID_PLAYER2`) AS `ID_PLAYER`
        FROM `your_table_name_here`
    ) AS `tmp`
GROUP BY `ID_PLAYER`

3

solved Mysql team/score [closed]