-- #1 SELECT `nom`,`salaire`,
      FLOOR(`salaire`/1000)*1000
      FROM `equipe`;

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

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

-- #4 SELECT `nom`, FLOOR(DATEDIFF('2017-12-31', `date_embauche`)/30)
      FROM `equipe`;

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

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

-- #7 SELECT equipe.nom, equipe.date_embauche
      FROM `equipe` AS equipe
      INNER JOIN equipe AS manager
      ON manager.id_eqp = equipe.campus_mgr
      WHERE equipe.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
      INNER JOIN campus
      ON equipe.id_camp = campus.id_camp
      WHERE nom_camp = 'Anfalas');