KPIT Technologies interview question

Select query with Joins?