SELECT datenaiss
FROM Eleve
WHERE nom = 'Dos'
AND prenom = 'Hugo';

/* 11. Les bonnes réponses du QCM n°1 (la session avec elv_id = NULL) */

SELECT qu.libelle as question, r.libelle as reponse
FROM Question qu, reponse r
WHERE r.qu_id = qu.id
AND r.id IN (
	SELECT rep_id
	FROM rep_valider
	WHERE ses_id = (
		SELECT id
		FROM Session_
		WHERE elv_id IS NULL
		AND qa_id = (
			SELECT id
			FROM Questionnaire
			WHERE id = (
				SELECT qa_id
				FROM QCM
				WHERE id = 1
			)
		)
	)
)
ORDER BY qu.id ASC;