Brillio interview question

SQL joins , Apti reasoning