06. Employees Hired After

SELECT e.first_name, e.last_name, e.hire_date, d.name
FROM employees AS e
JOIN departments AS d ON e.department_id = d.department_id
WHERE DATE(e.hire_date) > '1999-01-01' AND (d.name = 'Finance' OR d.name = 'Sales')
ORDER BY e.hire_date;