SELECT
P.STUDENT_NAME STUDENT_NAME, P.STUDENT_NO STUDENT_NO, F.ADDRESS ADDRESS
FROM(
SELECT
G.GRADE_NO GRADE_NO, A.ADDRESS
FROM
GRADE G, ADDRESS A
WHERE
G.GRADE_NO = A.GRADE_NO
) F LEFT JOIN
(
SELECT
S.STUDENT_NO STUDENT_NO, S.STUDENT_NAME STUDENT_NAME
FROM
STUDENT S
WHERE
S.YEAR = '2016'
)P ON P.STUDENT_NO = F.STUDENT_NO