-- #1
SELECT nom, ROUND(salaire) FROM equipe WHERE campus_mgr IS NULL;

-- #2
SELECT (CASE WHEN campus.nom_camp = "Lorien" THEN "#####" ELSE equipe.nom END) AS nom, campus.nom_camp FROM equipe JOIN campus ON equipe.id_camp = campus.id_camp;

-- #3
SELECT nom, MONTH(date_embauche) FROM equipe;

-- #4
SELECT nom, 12-MONTH(date_embauche) FROM equipe;

-- #5
SELECT nom, fonction, date_embauche, campus.id_camp, campus.nom_camp FROM equipe JOIN campus ON equipe.id_camp = campus.id_camp WHERE campus.nom_camp = "Nurn";

-- #6
SELECT nom, date_embauche FROM equipe WHERE date_embauche < (SELECT date_embauche FROM equipe WHERE nom = "Gimli");

-- #7
SELECT equipe1.nom, equipe1.date_embauche FROM equipe as equipe1 JOIN equipe as equipe2 ON equipe1.campus_mgr = equipe2.id_eqp WHERE equipe1.date_embauche < equipe2.date_embauche;

-- #8
SELECT nom, date_embauche from equipe WHERE DAY(date_embauche) = (SELECT DAY(date_embauche) FROM equipe WHERE nom = "Pippin") and nom != "Pippin";

-- #9
SELECT nom, date_embauche FROM equipe WHERE date_embauche < (SELECT MIN(date_embauche) FROM equipe JOIN campus ON equipe.id_camp = campus.id_camp WHERE campus.nom_camp = "Anfalas");