GROUPRES

filtros: proyecto, rango de fechas, vendedor

formato exp a excel

select
startdate::date,
op.salesrep_id,
ta.name as gestion,
count(*) as cant
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
where ge.ad_client_id = 1000005
and ge.startdate >= '2024-01-01'
group by 1,2,3
order by 1,2,3