1 2 3 4 5 6 7 8 9
| SELECT e.CD_SERVICE as Service, u.PRENOM as prenom_d_assistante, $var = date_debut , 100 - 100. * COUNT(e.date_debut ) / NULLIF(COUNT(*),0) AS Pourcentage
FROM ELEMENT e, UTILISATEUR u
WHERE CD_SERVICE IN ('FI','FC','RI') AND u.ID_UTIL = e.ID_UTIL_ASSIST AND u.PRENOM IN ('x','y','z')
GROUP BY e.CD_SERVICE, u.PRENOM
UNION
SELECT e.CD_SERVICE as Service2, u.PRENOM as prenom_d_assistante2, 100 - 100. * COUNT(e.IND_RECONDUITE ) / NULLIF(COUNT(*),0) AS Pourcentage
FROM ELEMENT e, UTILISATEUR u
WHERE CD_SERVICE IN ('FI','FC','RI') AND u.ID_UTIL = e.ID_UTIL_ASSIST AND u.PRENOM IN ('x','y','z')
GROUP BY e.CD_SERVICE, u.PRENOM; |
Partager