Equijoin conditions in WHERE

Which of the following is the appropriate result of executing the SQL statement that is given below on the “Student” table and the “Department” table? SELECT Name FROM Student, Department WHERE Affiliation = DepartmentName AND Department.Address = 'Shinjuku' Student Department Name Affiliation Address DepartmentName Address Tomoko Goda Science Shinjuku Science Shinjuku Shunsuke Aoki Engineering Shibuya Engineering Shinjuku Satoshi Kawauchi Humanities Shibuya Humanities Shibuya Yuko Sakaguchi Economics Shinjuku Economics Shibuya Editorial accessible table transcription: Student columns are Name, Affiliation, Address. Rows: Tomoko Goda, Science, Shinjuku; Shunsuke Aoki, Engineering, Shibuya; Satoshi Kawauchi, Humanities, Shibuya; Yuko Sakaguchi, Economics, Shinjuku. Department columns are DepartmentName, Address. Rows: Science, Shinjuku; Engineering, Shinjuku; Humanities, Shibuya; Economics, Shibuya. Original answer tables are separately transcribed below.

The original image above preserves the complete textbook wording and layout.