raising a pay of a worker, how to query

[king03]

hi guys just wanted to ask how to raise the pay of a worker in sql statement. By the way this is in oracle 10g. I uploaded the instructions for your reference, thank you for those who will help out.

[pritaeas]

What do you have so far?

[king03]

I attempted the first condition the "Hired before January 1, 1990 -->15%", but I do not know how to do the before January 1, 1990 condition. heres my code

select count(hire_date) "employees hired"
from employees 
where hire_date = before('1-jan-90');

error message: RA-00904: "BEFORE": invalid identifier

[king03]

I've already done it:

select count(employee_id) 
from employees 
where hire_date < '01-jan-90';

[debasisdas]

This is not the solution for what you are looking for.