TechnoNext Interview Question

SQL joining query (2-3 table)