SELECT COUNT(t.id_treballador)
FROM Treballador AS t, Colabora AS c
WHERE t.id_treballador=c.id_treballador AND c.es_cap=true
AND
c.id_projecte IN (SELECT e.id_projecte FROM Entregable AS e WHERE (e.percentatge_complert>60 AND e.versio>3);
AND
c.id_projecte IN (SELECT e2.id_projecte FROM Entregable AS e2 WHERE (e2.percentatge_complert<40 AND e2.versio<2))
GROUP BY t.nacionalitat;