Dronapay interview question

Two SQL problem on joins