Select max(sal),min(hire_date),ename, lastname

from emp

where lastname like '_a%'

group by ename;

So you have to use atleast one column (No aggregate funciton).