Трюк дня. SQL - Сортировка зеркальных строк

SELECT game, count(game)
FROM (
    select
        case when a < b then concat(a, '-' , b)
             else concat(b , '-', a ) end as game
    from data
) as t
GROUP by game|

#tips