SQL query join with nested select

Thank you so much for the help. This looks like it may work. I am tweaking it now.

Thanks,

Karen