Tricky & Advanced SQL Queries

This is a collection of Tricky & Advanced SQL Queries, usually asked in the interviews. Some of the questions have been taken from other websites and the original links have been provided. The sole purpose is to provide a collection of queries in one place.The solutions will work in ORACLE" database. It may or may not work in other databases, depending on the portability of the SQL queries.
Topic Title