Partie SQL

/* A */
SELECT nom, prenom
FROM TECHNICIEN, INTERVENTION, INCENDIE
WHERE idTechnicien = TECHNICIEN.id
AND idIncendie = INCENDIE.id
AND idBorne = "B1"
ORBER BY nom, prenom

/* B */
SELECT INTERVENTION.id, remarques, dateHeure, dateHeureDebut
FROM INTERVENTION, INCENDIE
WHERE idIncendie = INCENDIE.id
AND DATEDIFF("hour", dateHeureDebut, dateHeure) > 24

/* C */
SELECT COUNT(*) AS nbIncendieNonCloture
FROM INCENDIE
WHERE dateHeureCloture IN (
    SELECT dateHeureCloture FROM INCENDIE WHERE dateHeureCloture = NULL
)