es pal marc

SELECT e.num_dpt, d.nom_dpt, d.ciutat_dpt
FROM empleats e, departaments d
WHERE e.num_dpt = d.num_dpt
GROUP BY e.num_dpt, e.num_proj, d.nom_dpt, d.ciutat_dpt
HAVING COUNT(*) = (SELECT COUNT(*) FROM empleats WHERE
		empleats.num_dpt = e.num_dpt)
ORDER BY e.num_dpt, d.nom_dpt, d.ciutat_dpt;