Guest User

Untitled

a guest
Jan 22nd, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT COUNT(*) AS total, SUM(CASE WHEN TO_CHAR(Hire_date, 'YYYY') = '1995' THEN 1 ELSE 0 END) AS "1995", SUM(CASE WHEN TO_CHAR(Hire_date, 'YYYY') = '1996' THEN 1 ELSE 0 END) AS "1996", SUM(CASE WHEN TO_CHAR(Hire_date, 'YYYY') = '1997' THEN 1 ELSE 0 END) AS "1997", SUM(CASE WHEN TO_CHAR(Hire_date, 'YYYY') = '1998' THEN 1 ELSE 0 END) AS "1998"
  2. FROM employees;
Add Comment
Please, Sign In to add comment