Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1)
- SELECT emp.nom FROM emp,equipe,projet
- WHERE projet.id = 8 AND emp.id = id.emp AND id.projet = projet.id
- 2)
- SELECT COUNT (emp.id)
- FROM emp,equipe,projet
- WHERE emp.id = id.emp AND id.projet = projet.id
- GROUP BY projet.id
- 3)
- SELECT skill.nom FROM skill,projet,skillPro
- WHERE projet.id=8 AND projet.id = id.pro AND skill.id = idSkill
- 4)
- SELECT skill.nom FROM skill,eval,emp
- WHERE skill.id=id.skill AND emp.id=id.emp AND niveau>=4 AND emp.nom='x'
- 5)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement