Correction of the question tense

[M-Matin-dev]

Complete-SQL-Database-Bootcamp-Zero-to-Mastery/SQL Deep Dive/Having/answers.sql

Line 16 in 3fa6008

* Show me all the employees that have had more than 15 salary changes that work in the department development

Please change the question to Show me all the employees that have had more than 15 salary changes and have ever worked in the department development

The original sentence conveys showing the employees that are currently working in the "Development" department which is not the intended result and need an extra de.to_date > NOW() condition:

SELECT e.emp_no, count(s.from_date) as "amount of raises"
FROM employees as e
JOIN salaries as s USING(emp_no)
JOIN dept_emp AS de USING(emp_no)
WHERE de.to_date > NOW() And de.dept_no = 'd005'
GROUP BY e.emp_no
HAVING count(s.from_date) > 15
ORDER BY e.emp_no;