TechnoNext interview question

SQL joining query (2-3 table)