- Original Message -
From: "Riaan Oberholzer" <[EMAIL PROTECTED]>
> 2-0, 2-1, 2-2, 2-3
> 1-0, 1-1, 1-2, 1-3
> 0-0, 0-1, 0-2, 0-3
>
SELECT CONCAT(predictionA, '-', predictionB) AS score,
COUNT(CONCAT(predictionA, '-', predictionB)) AS count
FROM table
WHERE CONCAT(predictionA, '-', predic
Hi,
Background: I run a prediction league for soccer
competitions. For every game, I want to show how many
predictions were submitted per scoreline, ie.
10% said 1-0
20% said 0-1
30% said 2-3
etc.
My prediction table has a predictionA and predicionB
column with the submitted scores.
Currently I
