Impetus Technologies interview question

SQL in-depth questions, scenario based