validate non-aggregate columns in `having` and `order by` during `group by` validation

[angelamayxie]

MySQL documentation states

Reject queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on (uniquely determined by) GROUP BY columns.

We currently don't check having and order by nodes during group by validation.