SELECT Let.leaTitle as Tipo,COUNT(Lea.IDStatus) as Totale,
   
CASE Let.leaTitle 
WHEN 'Ferie' THEN 
CASE Lea.IDStatus WHEN 50 THEN  COUNT(isnull(Lea.IDStatus,0))
WHEN 90 THEN  COUNT(isnull(Lea.IDStatus,0)) END

      WHEN 'Allattamento' THEN 
CASE Lea.IDStatus WHEN 50 THEN  COUNT(isnull(Lea.IDStatus,0))
 WHEN 90 THEN  COUNT(isnull(Lea.IDStatus,0)) END
       
      WHEN 'Esame scolastico' THEN
 CASE Lea.IDStatus WHEN 50 THEN  COUNT(isnull(Lea.IDStatus,0))
  WHEN 90 THEN  COUNT(isnull(Lea.IDStatus,0)) END
        
      WHEN 'Licenza matrimoniale' THEN 
CASE Lea.IDStatus WHEN 50 THEN  COUNT(isnull(Lea.IDStatus,0)) 
WHEN 90 THEN  COUNT(isnull(Lea.IDStatus,0)) END
      
      WHEN 'Visita medica' THEN 
CASE Lea.IDStatus WHEN 50 THEN  COUNT(isnull(Lea.IDStatus,0)) 
WHEN 90 THEN  COUNT(isnull(Lea.IDStatus,0)) END

END
        
FROM [BSPF_GLOB].[dbo].[leaveRequest] Lea INNER JOIN [BSPF_GLOB].[dbo].[leaveType] Let ON Lea.IDLeaveType = Let.IDLeaveType
WHERE Lea.IDUser =69 
Group By Let.leaTitle,Lea.IDStatus