Show how many days an employee have served during his first month of joining

SELECT EMPLOYEE_ID,DATEDIFF(LAST_DAY(HIRE_DATE),HIRE_DATE)+1

FROM employees;