select x.tag, x.n as "ALL" , 
	hja.n as "AND",
	arc.n as "ARC",
	bes.n as "BES",
	ble.n as "BLE",
	bnz.n as "BNZ",
	cap.n as "CAP",
	cce.n as "CCE",
	cdr.n as "CDR",
	cwt.n as "CWT",
	edi.n as "EDI",
	fce.n as "FCE",
	gce.n as "GCE",
	hbr.n as "HBR",
	hfr.n as "HFR",
	jrn.n as "JRN",
	kbs.n as "KBS",
	knz.n as "KNZ",
	luq.n as "LUQ",
	mcm.n as "MCM",
	mcr.n as "MCR",
	nes.n as "NES",
	nin.n as "NIN",
	ntl.n as "NTL",
	nwk.n as "NWK",
	nwt.n as "NWT",
	pal.n as "PAL",
	pie.n as "PIE",
	sbc.n as "SBC",
	sev.n as "SEV",
	sgs.n as "SGS",
	vcr.n as "VCR"
from

(select tag, sum(count) as n
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id
group by tag) as x

left outer join -- AND is a reserved keyword 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id
where site like 'and' AND d.date_created > '2018-01-01'
group by tag) as hja
on x.tag=hja.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'arc' AND d.date_created > '2018-01-01'
group by tag) as arc
on x.tag=arc.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'bes' AND d.date_created > '2018-01-01'
group by tag) as bes
on x.tag=bes.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'ble' AND d.date_created > '2018-01-01'
group by tag) as ble
on x.tag=ble.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'bnz' AND d.date_created > '2018-01-01'
group by tag) as bnz
on x.tag=bnz.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'cap' AND d.date_created > '2018-01-01'
group by tag) as cap
on x.tag=cap.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'cce' AND d.date_created > '2018-01-01'
group by tag) as cce
on x.tag=cce.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'cdr' AND d.date_created > '2018-01-01'
group by tag) as cdr
on x.tag=cdr.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'cwt' AND d.date_created > '2018-01-01'
group by tag) as cwt
on x.tag=cwt.tag


left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'edi' AND d.date_created > '2018-01-01'
group by tag) as edi
on x.tag=edi.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'fce' AND d.date_created > '2018-01-01'
group by tag) as fce
on x.tag=fce.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'gce' AND d.date_created > '2018-01-01'
group by tag) as gce
on x.tag=gce.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'hbr' AND d.date_created > '2018-01-01'
group by tag) as hbr
on x.tag=hbr.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'hfr' AND d.date_created > '2018-01-01'
group by tag) as hfr
on x.tag=hfr.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'jrn' AND d.date_created > '2018-01-01'
group by tag) as jrn
on x.tag=jrn.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'kbs' AND d.date_created > '2018-01-01'
group by tag) as kbs
on x.tag=kbs.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'knz' AND d.date_created > '2018-01-01'
group by tag) as knz
on x.tag=knz.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'luq' AND d.date_created > '2018-01-01'
group by tag) as luq
on x.tag=luq.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'mcm' AND d.date_created > '2018-01-01'
group by tag) as mcm
on x.tag=mcm.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'mcr' AND d.date_created > '2018-01-01'
group by tag) as mcr
on x.tag=mcr.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'nes' AND d.date_created > '2018-01-01'
group by tag) as nes
on x.tag=nes.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'nin' AND d.date_created > '2018-01-01'
group by tag) as nin
on x.tag=nin.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'ntl' AND d.date_created > '2018-01-01'
group by tag) as ntl
on x.tag=ntl.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'nwk' AND d.date_created > '2018-01-01'
group by tag) as nwk
on x.tag=nwk.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'nwt' AND d.date_created > '2018-01-01'
group by tag) as nwt
on x.tag=nwt.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'pal' AND d.date_created > '2018-01-01'
group by tag) as pal
on x.tag=pal.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'pie' AND d.date_created > '2018-01-01'
group by tag) as pie
on x.tag=pie.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'sbc' AND d.date_created > '2018-01-01'
group by tag) as sbc
on x.tag=sbc.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'sev' AND d.date_created > '2018-01-01'
group by tag) as sev
on x.tag=sev.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'sgs' AND d.date_created > '2018-01-01'
group by tag) as sgs
on x.tag=sgs.tag

left outer join 
(select sum(count) as n, tag 
from cpu.site_pkg_tag_count t join cpu.pkg_date_created d on t.pkg_id=d.pkg_id 
where site like 'vcr' AND d.date_created > '2018-01-01'
group by tag) as vcr
on x.tag=vcr.tag
