Total Number of Employees hired in a certain year

[voyagerxii]

Ok, first I'll admit I am working on a class. However I am stumped. I can get the following to work and it returns the number of employees hired in a specific year.

SELECT COUNT(hire_date) "1995"
FROM EMPLOYEES
WHERE hire_date LIKE '%95'
GROUP By hire_date;

But then if i try to add another year for it to look at, like this

SELECT COUNT(hire_date WHERE hire_date LIKE '%95') "1995", COUNT(hire_date WHERE hire_date LIKE '%96') "1996"
FROM EMPLOYEES
GROUP By hire_date;

I get the following error.

ERROR at line 1:
ORA-00907: missing right parenthesis

if I add a right parenthesis after '%95') and '%96') it give the same error.

What am I doing wrong? I'm trying to understand that when adding a multiple search what needs to be done to accomplish this.

[r035198x]

Don't put a where clause inside the COUNT statement. That is illegal syntax.
Just add an OR clause to your original where clause.

[voyagerxii]

I'm not sure I understand. I replaced WHERE with OR and received the same error as before.

[Dilip1983]

Try this

SELECT COUNT(employee_no),hire_date FROM EMPLOYEE GROUP BY trunc(hire_date) HAVING hire_date IN ()

Thanks
Dilip

[r035198x]

I'm not sure I understand. I replaced WHERE with OR and received the same error as before.

Well I did say to add ( and not replace) to your original statement.