Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. SELECT concat(e.first_name, ' ', e.last_name) AS name,
  2. concat(count(r.open_date), '/', count(r.close_date)) AS closed_open_reports
  3. FROM employees AS e
  4. JOIN reports AS r ON e.id = r.employee_id
  5. WHERE year(r.open_date) >= 2016 AND count(r.open_date) > 0 AND count(r.close_date) > 0
  6. ORDER BY name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement