Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e.first_name, e.last_name, e.hire_date, d.name
- FROM employees e
- JOIN departments d
- ON e.department_id = d.department_id
- WHERE date(e.hire_date) > '1999-01-01' AND d.name IN ('Sales', 'Finance')
- ORDER BY e.hire_date ASC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement