What are the full names of all the faculty?
select fname, lname from faculty
Of those, which are a part of department 520?
select t1.fname, t1.lname from faculty as t1 join member_of as t2 on t1.facid = t2.facid where t2.dno = 520