/* Query 3 (page 172, 233 of the text book) is NOT supported by MS-SQL
   since CONTAINS is not implemented on MS-SQL
   See q3b.sql for another rephrasement of this query.

   Retrieve the name of each employee who works on all projects
  controlled by department number 4.

   The result must be
	Alicia  Zelaya
	Ahmad   Jabbar
*/

select	fname, lname
from	employee e
where	((select	pno
	  from		works_on w
	  where		w.essn = e.ssn)
	 contains
	 (select	pnumber
	  from		project p
	  where		p.dnum = 4))
;