CTS interview question

Basics on SQL. Join Queires