Virtusa Interview Question

SQL join query and concat query