1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT * FROM
//----------------------------------------------Entretien Tel-----------------------------------------------------------------
---------------------------------------------- requete 1-----------------------------
(SELECT count(s.idcandidat), s.Recruteur_Tel AS Contacte_Par FROM candidat AS c, suivi AS s WHERE c.idcandidat=s.idcandidat and s.Commentaire_Tel<>"" and YEAR(s.Date_EntretienTel)='2014' and MONTH(s.Date_EntretienTel)='9' GROUP BY s.Recruteur_Tel) AS CVContacte,
---------------------------------------------- requete 2-----------------------------
(SELECT count(s.idcandidat), s.Recruteur_Tel AS ValideEnTelephone_Par FROM candidat AS c, suivi AS s WHERE c.idcandidat=s.idcandidat and s.Validation_Tel="Validé" and YEAR(s.Date_EntretienTel)='2014' and MONTH(s.Date_EntretienTel)='9' GROUP BY s.Recruteur_Tel) AS CVContacteValide,
//-------------------------------------------------Entretien RH---------------------------------------------------------------------
---------------------------------------------- requete 3-----------------------------
(SELECT count(s.idcandidat) FROM candidat AS c, suivi AS s WHERE c.idcandidat=s.idcandidat and s.Commentaire_RH<>"" and YEAR(s.Date_EntretienRH)='2014' and MONTH(s.Date_EntretienRH)='9') AS EntrRH,
---------------------------------------------- requete 4-----------------------------
(SELECT count(s.idcandidat), s.Recruteur_RH AS ValideEnRH_Par FROM candidat AS c, suivi AS s WHERE c.idcandidat=s.idcandidat and s.Validation_RH="Validé" and YEAR(s.Date_EntretienRH)='2014' and MONTH(s.Date_EntretienRH)='9' GROUP BY s.Recruteur_RH) AS EntrRHValide,
//----------------------------------------------Entretien Technique-----------------------------------------------------------------
---------------------------------------------- requete 5-----------------------------
(SELECT count(s.idcandidat) FROM candidat AS c, suivi AS s WHERE c.idcandidat=s.idcandidat and s.Commentaire_Ops<>"" and YEAR(s.Date_EntretienSM)='2014' and MONTH(s.Date_EntretienSM)='9') AS EntrOPS,
---------------------------------------------- requete 6-----------------------------
(SELECT count(s.idcandidat),s.Recruteur_Tech as valideEnTech_Par FROM candidat AS c, suivi AS s WHERE c.idcandidat=s.idcandidat and s.ValidationSM_Sup="Validé" and YEAR(s.Date_EntretienSM)='2014' and MONTH(s.Date_EntretienSM)='9' group by s.Recruteur_Tech) AS EntrOPSValide; |
Partager