Indium Software interview question

Write code on joins subquerys