Fix: Illegal query in grouped aggregates

Fixed Illegal query bug for some queries that fetch aggregates using the group by feature.