• You need to use any aggregate function on columns col2, col3 as these are not part of group by clause.