SELECT * FROM ( SELECT WORK_COUNTRY as country, JOB FROM WWV_DEMO_EMP ) PIVOT (COUNT(*) FOR JOB IN ( 'President' as President, 'Manager' as Manager, 'Analyst' as Analyst, 'Salesman' as Salesman, 'Clerk' as Clerk) )