Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Qüestió 1
- SELECT DISTINCT d.num_dpt, d.nom_dpt
- FROM departaments d, empleats e
- WHERE d.ciutat_dpt = 'MADRID' AND
- d.num_dpt = e.num_dpt AND
- e.sou > 200000;
- -- Qüestió 2
- SELECT d.nom_dpt, p.nom_proj
- FROM departaments d, empleats e, projectes p
- WHERE e.num_empl = 2 AND e.num_proj = p.num_proj AND e.num_dpt = d.num_dpt;
- -- Qüestió 3
- SELECT d.num_dpt, d.nom_dpt, AVG(e.sou)
- FROM departaments d, empleats e
- WHERE d.ciutat_dpt = 'MADRID' AND
- e.num_dpt = d.num_dpt
- GROUP BY d.num_dpt;
- -- JosepRivaille
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement