Your query is wrong, since you would need to perform some aggregation function on EMPLOYEE_ID if you want that to work.
Like:
select substr(first_name,1,1) as alpha, count(employee_id)
from employees
group by substr(first_name,1,1)
What exactly you are trying to accomplish?