如何计算mysql中两列的结果

Question

我有一个预测表，包括homescore和awayscore。我希望输出所有不同的预测，以及每个预测的实例数。

matchid    homescore    awayscore
 1         1            2
 1         1            0
 1         9            3
 1         2            0
 1         1            2
 1         1            0
 2         3            2
 2         2            2
...

我希望它输出一个这样的表，用于匹配I 1：

result    predictions
1-2       2           
1-0       2
9-3       1
2-0       1

Answer 1

SELECT 
    CONCAT(homescore, '-', awayscore) as result,
    COUNT(*) as predictions
FROM table
WHERE matched = 1
GROUP BY CONCAT(homescore, '-', awayscore);