Bonjour,



SELECT
devoirs.titre,
AVG(notes.note) as moyenne,
MAX(CASE WHEN notes.eleve ='".$eleve."' THEN notes.note END ) AS NoteEleve
FROM devoirs
INNER JOIN notes