SQL

get who is hired in specific month in sql

BY EXTENDING ABOVE QUERY , FIND OUT EVERYONE WHO IS HIRED IN JAN 
SELECT FIRST_NAME , HIRE_DATE 
FROM EMPLOYEES 
WHERE SUBSTR(HIRE_DATE, 4, 3) = 'JAN' ;