SELECT nom
FROM notes
WHERE
(test = 'francais' AND note >= 11) OR
(test = 'anglais' AND note >= 12)
GROUP BY
nom
HAVING COUNT(*) > 1