Curriculum Associates interview question

Add an inner join to this SQL that will ....