Indium Software Interview Question

sql joins based problem they asked to solve