>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.