Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT concat(e.first_name, ' ', e.last_name) AS name,
- concat(count(r.open_date), '/', count(r.close_date)) AS closed_open_reports
- FROM employees AS e
- JOIN reports AS r ON e.id = r.employee_id
- WHERE year(r.open_date) >= 2016 AND count(r.open_date) > 0 AND count(r.close_date) > 0
- ORDER BY name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement