Advertisement
Guest User

Untitled

a guest
Oct 12th, 2018
488
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.23 KB | None | 0 0
  1. SELECT e.first_name, e.last_name, e.hire_date, d.name
  2. FROM employees e
  3. JOIN departments d
  4. ON e.department_id = d.department_id
  5. WHERE date(e.hire_date) > '1999-01-01' AND d.name IN ('Sales', 'Finance')
  6. ORDER BY e.hire_date ASC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement