Infosys interview question

SQL query using every concept of queries.