Curriculum Associates Interview Question

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