I have a database of employees and I am trying to count the number of employees I have between specific dates in 10 year increments. I have my syntax incorrect but I am not very proficient at identifying why this will not run.

**I need the query to produce the following:**

12 employees were hired between 1970 and 1980

19 employees were hired between 1980 and 1990

etc.

[![enter image description here](https://i.stack.imgur.com/3wvF4.png)](https://i.stack.imgur.com/3wvF4.png)

I keep getting this error:
[![enter image description here](https://i.stack.imgur.com/qQ6Zn.png)](https://i.stack.imgur.com/qQ6Zn.png)