—#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 nom, fonction, campus.nom_camp from equipe INNER join campus on equipe.id_camp = campus.id_camp where equipe.fonction = "Assistant" and (campus.nom_camp = "La Comté" or campus.nom_camp = "Lorien")

—#4
select nom, date_embauche from equipe where fonction != 'Assistant' and date_embauche like '2017%'

--#5
select nom from equipe where nom like '%R%' and nom like '%A%'

—#6
select nom from equipe where nom LIKE '%A%%A%'

—#7
select nom from equipe where campus_mgr is null

—#8
select nom, id_eqp, fonction, date_embauche from equipe order by date_embauche asc
select nom, id_eqp, fonction, date_embauche from equipe order by fonction asc
select nom, id_eqp, fonction, date_embauche from equipe order by id_camp asc