Re: count of a certain value in two columns

[Khaba]

Thanks another time...

... in this case I have to know the ID of the assistman. What if I don't know it or if I generally want to display a sorted list?

By the way.. can it be, that I can not use an aggregate field in the where clause?

The following query generate an error: #1054 - Unknown column 'nr_of_items' in 'where clause'

SELECT game, sum( p1 *2 + p2 *5 + p3 *10 + p4 *20 ) AS nr_of_items
FROM playergame
WHERE player =1010
AND nr_of_items > 0
GROUP BY game
ORDER BY nr_of_items DESC