CREATE TABLE MEMBER_OF (FacID VARCHAR2, DNO VARCHAR2)
CREATE TABLE FACULTY (Fname VARCHAR2, Lname VARCHAR2, FacID VARCHAR2)

Find the full names of faculties who are members of department with 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
SELECT "T1"."Fname", "T1"."Lname" FROM "FACULTY" "T1" JOIN "MEMBER_OF" "T2" ON "T1"."FacID" = "T2"."FacID" AND "T2"."DNO" = 520