1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
CREATE VIEW vSyntheseGlobalClienttt
AS
SELECT
comp_name
,count(CASE WHEN case_natureofdemande = 'incident' THEN 1 END) as NbIncident
,count(CASE WHEN case_natureofdemande = 'demande' THEN 1 END) as NbDemande
, count(CASE WHEN case_stage = 'en cours' THEN 1 END) as NbEnCours
, count(CASE WHEN case_stage = 'fermé' THEN 1 END) as NbFerme
FROM COMPANY
left outer JOIN cases
ON comp_companyid = case_primarycompanyid
where comp_deleted is null
and case_deleted is null
and (comp_name='masociete1' or comp_name='masociete2')
and comp_type='Customer'
group by comp_name |
Partager