daily pastebin goal
46%
SHARE
TWEET

Untitled

a guest Dec 10th, 2018 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- #5
  2. 1. SELECT nom, FLOOR(salaire) FROM equipe WHERE campus_mgr IS NULL;
  3.  
  4. 2. SELECT CASE WHEN campus.nom_camp = 'Lorien' THEN '#####' ELSE equipe.nom END, campus.nom_camp FROM equipe JOIN campus ON equipe.id_camp = campus.id_camp;
  5.  
  6. 3. SELECT nom, SUBSTRING(date_embauche,6, 2) FROM equipe;
  7.  
  8. 4. SELECT nom , ROUND(DATEDIFF('2017-12-31', date_embauche) /30) FROM equipe;
  9.  
  10. 5. SELECT equipe.nom, equipe.fonction, equipe.date_embauche, campus.id_camp, campus.nom_camp FROM equipe JOIN campus ON equipe.id_camp = campus.id_camp WHERE campus.nom_camp = 'Nurn';
  11.  
  12. 6. SELECT nom, date_embauche FROM equipe WHERE date_embauche < (SELECT date_embauche FROM equipe WHERE nom = 'Gimli');
  13.  
  14. 7. SELECT notmgr.nom, notmgr.date_embauche FROM equipe as notmgr JOIN equipe as manager ON notmgr.campus_mgr = manager.id_eqp WHERE notmgr.date_embauche < manager.date_embauche;
  15.  
  16. 8. SELECT nom, date_embauche FROM equipe WHERE DAY( date_embauche) = (SELECT DAY(date_embauche) FROM equipe WHERE nom = 'Pippin') AND nom != 'Pippin';
  17.  
  18. 9. SELECT nom, date_embauche FROM equipe WHERE date_embauche < (SELECT MIN (date_embauche) FROM equipe JOIN campus ON equipe.id_camp = campus.id_camp WHERE campus.nom_camp = 'Anfalas');
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