sql subqueries nested in select and from

There is this video under "SQL subqueries nested in select and from" which makes me feel so confused and lost. I watched it many times however I did not get where the question is coming from. How did the instructor realize he should include the dept code? I saw everyone in the Q&A section wrote the code and I even could not find the question itself.