SELECT 
	   a.RELEASEUSERID, 
	   sum(a.NUMPAGES) as "Page Count(Total)",
	   
	   ( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'P'
        Group by a.RELEASEUSERID ) as "PRINT(TOTAL)",
		
		( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'P'
		and a.PRINTJOBCOLOR = 'Y'
        Group by a.RELEASEUSERID ) as "PRINT(COLOR)",		
			
		( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'P'
		and a.PRINTJOBCOLOR = 'Y'
		and a.PRINTJOBPAPERSIZE='A3' 
        Group by a.RELEASEUSERID ) as "PRINT(COLOR_LARGE)",
		
			( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'P'
		and a.PRINTJOBCOLOR = 'M' 
        Group by a.RELEASEUSERID ) as "PRINT(MONO)",
		
		( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'P'
		and a.PRINTJOBCOLOR = 'N'
		and a.PRINTJOBPAPERSIZE='A3' 
        Group by a.RELEASEUSERID ) as "PRINT(MONO_LARGE)",
		
			( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'P'
		and a.PRINTJOBDUPLEX = 'Y' 
        Group by a.RELEASEUSERID ) as "PRINT(DUPLEX)",
		
			( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'C' 
        Group by a.RELEASEUSERID ) as "COPY(TOTAL)",
		
		( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'C'
		and a.PRINTJOBCOLOR = 'Y'
        Group by a.RELEASEUSERID ) as "COPY(COLOR)",	
		
		( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'C'
		and a.PRINTJOBCOLOR = 'Y'
		and a.PRINTJOBPAPERSIZE='A3' 
        Group by a.RELEASEUSERID ) as "COPY(COLOR_LARGE)",
		
		( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'C'
		and a.PRINTJOBCOLOR = 'M' 
        Group by a.RELEASEUSERID ) as "COPY(MONO)",
		
		( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'C'
		and a.PRINTJOBCOLOR = 'N'
		and a.PRINTJOBPAPERSIZE='A3' 
        Group by a.RELEASEUSERID ) as "COPY(MONO_LARGE)",
		
					( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'C'
		and a.PRINTJOBDUPLEX = 'Y' 
        Group by a.RELEASEUSERID ) as "COPY(DUPLEX)",
		
					( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'E' 
        Group by a.RELEASEUSERID ) as "EMAIL",
		
							( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'F' 
        Group by a.RELEASEUSERID ) as "FAX",
		
							( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'S' 
        Group by a.RELEASEUSERID ) as "SCAN",
		
							( SELECT 
	   sum(a.NUMPAGES)
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
		and a.FINALACTION = 'T' 
        Group by a.RELEASEUSERID ) as "FTP"
		
FROM PR_STATS a 
        where FINALDATE > '01.12.2019'
        and FINALDATE <= '05.12.2019'
        Group by a.RELEASEUSERID