GROUPRES

select
ca.name as canal,
'CITAS' as tipo,
count(ge.*) as citas,
0 as entrevistas
from c_contactactivity ge
inner join tb_activitytype ta on ta.tb_activitytype_ID = ge.tb_activitytype_ID
inner join c_opportunity op on op.c_opportunity_id = ge.c_opportunity_id
left join c_channel ca on ca.c_channel_id = op.c_channel_id
where ge.ad_client_id = 1000005 --$P{AD_Client_ID}
and ge.startdate >= COALESCE
and ge.startdate <= COALESCE
and ActivityCategory = 'C'
group by 1,2
UNION
select
ca.name as canal,
'ENTREVISTAS' as tipo,
0 as citas,
count(ge.*) as entrevistas
from c_contactactivity ge
inner join tb_activitytype ta on ta.tb_activitytype_ID = ge.tb_activitytype_ID
inner join c_opportunity op on op.c_opportunity_id = ge.c_opportunity_id
left join c_channel ca on ca.c_channel_id = op.c_channel_id
where ge.ad_client_id =1000005 --$P{AD_Client_ID}
and ge.startdate >= COALESCE
and ge.startdate <= COALESCE
and ActivityCategory = 'E'
group by 1,2
order by 1,2