Indium Software interview question

sql joins based problem they asked to solve