daily pastebin goal
47%
SHARE
TWEET

xavpd

a guest Dec 16th, 2018 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 2)
  2. select  distinct nom_etud, prenom_etud as liste
  3. from etudiant as et, enseignant as e, jury as j, soutenance as s, stage as st
  4. where nom_ens="marchetti" or nom_ens="zertal"
  5. and e.id_ens = j.id_ens_pres
  6. and j.no_jury = s.no_jury
  7. and et.no_etud = st.no_etud
  8. and st.no_stage = s.no_stage
  9.  
  10. 4)
  11. select distinct(nom_entrep)
  12. from entreprise as en, promotion p1, promotion p2, etudiant e1, etudiant e2, stage s1, stage s2
  13. where p1.annee_sortie = "2018"
  14. and p2.annee_sortie = "2018"
  15. and p1.no_promo = e1.no_promo
  16. and p2.no_promo = e2.no_promo
  17. and s1.no_etud = e1.no_etud
  18. and s2.no_etud = e2.no_etud
  19. and s1.no_entrep = s2.no_entrep
  20. and s1.no_stage <> s2.no_stage
  21. and s1.no_entrep = en.no_entrep
  22.  
  23.  
  24.  
  25. 6)
  26. create temporary table t1
  27. select count(no_stage) s1
  28. from promotion as p, etudiant as e, stage s1
  29. where p.annee_sortie = "2018"
  30. and e.no_promo = p.no_promo
  31. and e.no_etud = s1.no_etud
  32. ;
  33. create temporary table t2
  34. select count(no_stage) s2
  35. from promotion as p, etudiant as e, stage s2, jury as j
  36. where p.annee_sortie ="2018"
  37. and p.no_promo = e.no_promo
  38. and e.no_etud = s2.no_etud
  39. and j.id_ens_pres = s2.no_ens_tuteur
  40. ;
  41. select(s2/s1*100)
  42. from t1,t2
  43. ;
  44. drop table t1
  45. ;
  46. drop table t2
  47.  
  48. 8)
  49. select nom_etud, e.no_etud
  50. from etudiant as e, promotion as p, stage as s
  51. where p.annee_sortie ="2018"
  52. and p.no_promo = e.no_promo
  53. and e.no_etud = s.no_etud
  54. and s.no_stage not in(
  55.     select so.no_stage
  56.     from soutenance  as so, stage as s
  57.     where so.no_stage = s.no_stage
  58.     )
  59.  
  60.                                                                                                                                                                                                                                                                                                                                                                                                                                                      
  61. 10)
  62. create temporary table t1
  63. select count(no_stage) s1
  64. from stage s1
  65. ;
  66. create temporary table t2
  67. select count(no_stage) s2
  68. from stage s2, pays as p, entreprise as e  
  69. where e.no_entrep = s2.no_stage
  70. and p.nom_pays = "France"
  71. and p.no_pays = e.no_pays
  72. ;
  73. create temporary table t3
  74. select count(no_stage) s3
  75. from entreprise as e, stage s3, pays as p
  76. where e.no_entrep = s3.no_stage
  77. and p.nom_pays <> "France"
  78. and p.no_pays = e.no_pays
  79. ;
  80. select s2/s1*100 as statfr , s3/s1*100 as statet
  81. from t1, t2, t3
  82. ;
  83. drop table t1
  84. ;
  85. drop table t2
  86. ;
  87. drop table t3
  88.  
  89.  
  90.  
  91. 12)
  92. select distinct s1.no_etud
  93. from stage s1, stage s2, promotion as p, etudiant as e
  94. where p.annee_sortie="2018"
  95. and p.no_promo = e.no_promo
  96. and s1.no_etud = s2.no_etud
  97. and s1.no_stage <> s2.no_stage
  98. and s1.no_etud = e.no_etud
  99. and s2.no_etud = e.no_etud
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