-- #1
SELECT id_camp, localite FROM `campus`
-- #2
SELECT nom, nom_camp FROM equipe INNER JOIN campus ON equipe.id_camp = campus.id_camp
-- #3
SELECT * FROM `equipe` WHERE fonction = "assistant" AND id_camp IN (130, 140)
-- #4
SELECT * FROM `equipe` WHERE fonction != "assistant" AND date_embauche BETWEEN "2017-01-01" AND "2017-12-31"
-- #5
SELECT nom FROM `equipe` WHERE nom LIKE "%A%R%"
-- #6
SELECT nom FROM `equipe` WHERE nom LIKE "%A%A%"
-- #7
SELECT * FROM `equipe` WHERE campus_mgr IS NULL
-- #8
SELECT nom, id_eqp, fonction, date_embauche FROM `equipe` ORDER BY date_embauche DESC
SELECT nom, id_eqp, fonction, date_embauche FROM `equipe` ORDER BY fonction
SELECT nom, id_eqp, fonction, date_embauche, id_camp FROM `equipe` ORDER BY id_camp