In 6.5, SQL: SUM\AVG FUNCTION CAN NOT WORK WITH LIKE the sql which like below is not work. eg; select avg(salary), sum(salary) from emp where first_name like 'G%'