Dronapay Interview Question

Two SQL problem on joins