>I don't understand what that has to do with grouping. I tried it anyway, though
>and got the same error
Does it work if you do GROUP BY 3 instead, to indicate the third field in the list?
>I don't understand 1) why I need a group clause
To keep from getting ambiguous results in the columns that aren't aggregated.