As an addition
basically the number of columns have to be equal to the number of columns in the GROUP BY clause
is not a correct statement.
- Any attribute which is not a part of GROUP BY clause can not be used for selection
- Any attribute which is a part of GROUP BY clause can be used for selection but not mandatory.