Vivek Kumar interview question

sql query about joins and tables