Created
January 10, 2019 14:19
-
-
Save PradalCyril/0984b281a98b82fd35a1e0d81285bb6b to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- #1 | |
SELECT id_camp, localite from campus | |
-- #2 | |
SELECT equipe.nom, campus.nom_camp from equipe INNER JOIN campus ON campus.id_camp=equipe.id_camp | |
-- #3 | |
SELECT equipe.nom from equipe INNER JOIN campus ON campus.id_camp=equipe.id_camp where equipe.fonction='Assistant' AND (campus.nom_camp='Lorien'or campus.nom_camp='La Comté') | |
-- #4 | |
SELECT equipe.nom from equipe INNER JOIN campus ON campus.id_camp=equipe.id_camp where equipe.fonction!='Assistant' AND 2017= YEAR(equipe.date_embauche) | |
-- #5 | |
SELECT equipe.nom from equipe Where equipe.nom Like '%a%' and equipe.nom like '%r%' | |
-- #6 | |
SELECT equipe.nom from equipe Where equipe.nom Like '%a%' and equipe.nom like '%a%' | |
-- #7 | |
SELECT equipe.nom from equipe Where campus_mgr Is null | |
-- #8 | |
SELECT equipe.nom, equipe.id_eqp, equipe.fonction, equipe.date_embauche from equipe ORDER BY date_embauche DESC; | |
SELECT equipe.nom, equipe.id_eqp, equipe.fonction, equipe.date_embauche from equipe ORDER BY equipe.fonction; | |
SELECT equipe.nom, equipe.id_eqp, equipe.fonction, equipe.date_embauche from equipe ORDER BY id_camp |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment