what is the last names of faculties who are members of computer science department?
select t2.lname from department as t1 join faculty as t2 on t1.dno = t3.dno join member_of as t3 on t2.facid = t3.facid where t1.dname = "Computer Science"
yes
select rank from faculty where lname = "Goodrich"