Can you please tell me the full names of all faculty who are members of department number 520?
select t1.fname, t1.lname from faculty as t1 join member_of as t2 on t1.facid = t2.facid where t2.dno = 520
What about for department number 600?
select t1.fname, t1.lname from faculty as t1 join member_of as t2 on t1.facid = t2.facid where t2.dno = 600
What is the sex of each of those faculty who are members of the department with department number 600.
select t1.sex from faculty as t1 join member_of as t2 on t1.facid = t2.facid where t2.dno = 600