Yes as Sean Said you have to specify all the columns that you are using in the select statement in your Group By Clause expect the aggregate.