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

2. SELECT CASE WHEN campus.nom_camp = 'Lorien' THEN '#####' ELSE equipe.nom END, campus.nom_camp FROM equipe JOIN campus ON equipe.id_camp = campus.id_camp;

3. SELECT nom, SUBSTRING(date_embauche,6, 2) FROM equipe;

4. SELECT nom , ROUND(DATEDIFF('2017-12-31', date_embauche) /30) FROM equipe;

5. SELECT equipe.nom, equipe.fonction, equipe.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 notmgr.nom, notmgr.date_embauche FROM equipe as notmgr JOIN equipe as manager ON notmgr.campus_mgr = manager.id_eqp WHERE notmgr.date_embauche < manager.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');