Group employees based on the first letter of their names

SELECT SUBSTR(FIRST_NAME,1,1), COUNT(*)

FROM employees

GROUP BY SUBSTR(FIRST_NAME,1,1);