All columns in the SELECT list that are not there in the GROUP function, should be in the group by clause