05sql

-- #1

SELECT equipe.nom, round(equipe.salaire,3) from equipe WHERE campus_mgr is null

-- #2

SELECT case when campus.nom_camp != 'Lorien' then equipe.nom else '#####' END from equipe INNER JOIN campus ON campus.id_camp = equipe.id_camp
-- #3

SELECT equipe.nom, LPAD(MONTH(date_embauche),2,0) from equipe

-- #4
SELECT equipe.nom, Round(DATEDIFF(CURRENT_DATE, date_embauche)/30,0) from equipe

-- #5

SELECT equipe.nom, equipe.id_eqp, equipe.fonction, equipe.date_embauche, campus.nom_camp from equipe INNER JOIN campus on campus.id_camp =equipe.id_camp where campus.nom_camp="Nurn"

-- #6

SELECT equipe.nom, equipe.date_embauche from equipe where DATEDIFF(equipe.date_embaucheE,(SELECT date_embauche FROM equipe WHERE nom = 'Gimli'))<0

-- #7
SELECT eqi.nom, eqi.date_embauche from equipe as eqi JOIN equipe AS equ ON eqi.campus_mgr=equ.id_eqp where DATEDIFF(eqi.date_embauche,equ.date_embauche)<0

-- #8

SELECT equipe.nom, equipe.date_embauche from equipe where DATEDIFF(equipe.date_embauche,(SELECT date_embauche FROM equipe WHERE nom = 'Pippin'))=0 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');