Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Dec 7th, 2018 62 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  1. —#1
  2. select id_camp, localite from campus
  3.  
  4. —#2
  5. select nom, nom_camp from equipe INNER join campus on equipe.id_camp = campus.id_camp
  6.  
  7. —#3
  8. 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")
  9.  
  10. —#4
  11. select nom, date_embauche from equipe where fonction != 'Assistant' and date_embauche like '2017%'
  12.  
  13. --#5
  14. select nom from equipe where nom like '%R%' and nom like '%A%'
  15.  
  16. —#6
  17. select nom from equipe where nom LIKE '%A%%A%'
  18.  
  19. —#7
  20. select nom from equipe where campus_mgr is null
  21.  
  22. —#8
  23. select nom, id_eqp, fonction, date_embauche from equipe order by date_embauche asc
  24. select nom, id_eqp, fonction, date_embauche from equipe order by fonction asc
  25. select nom, id_eqp, fonction, date_embauche from equipe order by id_camp asc
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top