Re: Problems with a query

[Space Enterprises]

SELECT titles.title, departments.dept_name, employees.hire_date, COUNT(*) AS number_of_employees

FROM titles

JOIN offices ON titles.title

JOIN workers ON titles.title

WHERE hire_date BETWEEN '1995-01-01' and '2005-01-01'

Bunch BY title, dept_name, hire_date;