In which situations would you use a three level subquery?

What will be an ideal response?

When three tables are involved, and result from one table’s query can be used by query
based on second table, and subsequently, result of the second query is used in query
based on third table.
SELECT Building, RoomNo FROM location
WHERE Roomid =
(SELECT RoomId FROM faculty

WHERE FacultyId =

(SELECT FacultyId FROM student
WHERE StudentId = ‘00101’));