NucleusTeq Interview Question

SQL medium level question on joins