Skip to content

Instantly share code, notes, and snippets.

@PradalCyril
Created January 10, 2019 14:19
Show Gist options
  • Save PradalCyril/0984b281a98b82fd35a1e0d81285bb6b to your computer and use it in GitHub Desktop.
Save PradalCyril/0984b281a98b82fd35a1e0d81285bb6b to your computer and use it in GitHub Desktop.
-- #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