MySQL Date and Time Exercises: Query to get the years in which more than 10 employees joined

MySQL Date Time: Exercise-16 with Solution

Write a query to get the years in which more than 10 employees joined.

Sample table : employees

Code:

SELECT DATE_FORMAT(HIRE_DATE,'%Y') 
     FROM employees  
       GROUP BY DATE_FORMAT(HIRE_DATE,'%Y') 
          HAVING COUNT(EMPLOYEE_ID) > 10;

Sample Output:

DATE_FORMAT(HIRE_DATE,'%Y')
1987

Pictorial Presentation of the above query:

MySQL Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous:Write a query to get the firstname, lastname who joined in the month of June.
Next:Write a query to get first name of employees who joined in 1987.