I have summarized everything for my request as follows: thank you
Looks like homework or a test. You need to take a stab at it and post your attempt.
This definitely looks like homework. I can walk you thru the process of creating a query, but I can't just write it for you.
Have you used CROSS APPLY or OUTER APPLY in class? Have you used LEFT OUTER JOIN or just INNER JOIN?
Apologies. incorrect post