We discuss the question asked in ugc net 2021 based on sql which consists of student and course relation and various queries based on group by and natural join. It can be used to understand how natural join works and nested queries can be used with aggregation operators.