Problems with a query

[blaine mitchell]

Here is the question, I have tried EVERYTHING, tried EVERYONE, so now I am here.

Using the departments, employees, titles, and dept_emp tables, find the number of employees per department per position between 01/01/1995 and 01/01/2005.


Here is my syntax so far, but the query never stops running...HELP!!!

SELECT titles.title, departments.dept_name, employees.hire_date, COUNT(*) AS number_of_employees FROM titles, departments, employees WHERE hire_date BETWEEN '1995-01-01' and '2005-01-01'
GROUP BY title;