CTS Interview Question

Basics on SQL. Join Queires