$supp = mysql_query("DROP VIEW  nbreheure");
$reqcorrectif = mysql_query("CREATE VIEW nbreheure AS SELECT date_appel, d.id, idCorrectif, intervention_id, SUM(TIMESTAMPDIFF(SECOND,debut_inter,fin_inter)) AS travail, SUM(TIME_TO_SEC(tps_acces_signature)) AS acces
	FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id LEFT JOIN work_times AS w ON intervention_id=c.id_appel
	WHERE MONTH(date_appel)=$mois AND YEAR(date_appel)=$annee AND debut_inter IS NOT NULL AND fin_inter IS NOT NULL AND type_inter = 'Correctif' AND statut='Cloturé' GROUP BY idCorrectif");
$correctif = mysql_query("SELECT idCorrectif,travail, acces,AVG (travail-acces) AS moyenne FROM nbreheure");

$reqcorrectif = mysql_query("CREATE VIEW nbreheure AS SELECT date_appel, d.id, idCorrectif, intervention_id, TIMESTAMPDIFF(SECOND,debut_inter,fin_inter) AS travail, TIME_TO_SEC(tps_acces_signature) AS acces
	FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id LEFT JOIN work_times AS w ON intervention_id=c.id_appel
	WHERE MONTH(date_appel)=$mois AND YEAR(date_appel)=$annee AND debut_inter IS NOT NULL AND fin_inter IS NOT NULL AND type_inter = 'Correctif' AND statut='Cloturé'");
$correctif = mysql_query("SELECT AVG (travail-acces) AS moyenne FROM nbreheure");

SELECT (
SUM( TIMESTAMPDIFF(
MINUTE , debut_inter, fin_inter ) ) + SUM( temps_acces )
) / COUNT( id ) AS total_inter
FROM test

SELECT date_appel, d.id, idCorrectif, intervention_id, AVG(SUM((TIMESTAMPDIFF(SECOND,debut_inter,fin_inter)) - (TIME_TO_SEC(tps_acces_signature)))) AS moyenne
	FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id LEFT JOIN work_times AS w ON intervention_id=c.id_appel
	WHERE MONTH(date_appel)=$mois AND YEAR(date_appel)=$annee  AND type_inter = 'Correctif' AND statut='Cloturé'

SELECT date_appel, d.id, idCorrectif, intervention_id, AVG((SUM(TIMESTAMPDIFF(SECOND,debut_inter,fin_inter))) - (SUM(TIME_TO_SEC(tps_acces_signature)))) AS moyenne
	FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id LEFT JOIN work_times AS w ON intervention_id=c.id_appel
	WHERE MONTH(date_appel)=$mois AND YEAR(date_appel)=$annee AND type_inter = 'Correctif' AND statut='Cloturé'

SELECT date_appel, d.id, idCorrectif, intervention_id, AVG((SUM(TIMESTAMPDIFF(SECOND,debut_inter,fin_inter))) - (SUM(TIME_TO_SEC(tps_acces_signature)))) AS moyenne
	FROM correctif AS c LEFT JOIN demande AS d ON c.id_appel = d.id LEFT JOIN work_times AS w ON intervention_id=c.id_appel
	WHERE MONTH(date_appel)=6 AND YEAR(date_appel)=2012 AND type_inter = 'Correctif' AND statut='Cloturé'

SELECT SUM(avg(TIMESTAMPDIFF(SECOND,debut_inter,fin_inter) - TIME_TO_SEC(tps_acces_signature))) AS total_duree_inter;

SELECT SUM(duree) FROM duree_inter