Brillio Interview Question

SQL joins , Apti reasoning