Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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"
- FROM employees;
Add Comment
Please, Sign In to add comment