subquery error with group by

[skhanal]

Why do you need to group by all three columns in the select list?. I don't see any aggregate in the query.