Deloitte interview question

OOPS Concept SQL Queries on Join Project in detail