garry@schoolteachers.co.uk wrote:
> Quoting Richard Huxton <dev@archonet.com>:
>> But I'm guessing that's not what you mean. Can you show what output
>> you'd like to have?
>
> effort sum
> 1 245
> 2 463
> etc.
>
> Each value for effort has a different statistical meaning as in the case
> statement.
Sorry - still don't understand. The query you originally gave should
have provided the sum for each case (which you seem to be calling
"effort" here. I don't see where the problem is.
--
Richard Huxton
Archonet Ltd
