S.S. Rana & Co. interview question

Query based on join and view .