QuadraMed Interview Question

some coding SQL coding question about joining tables