Infosys Interview Question

SQL query using every concept of queries.