Help me in solving SQLP41 problem

My issue

EXPLAIN THE QUESTION IN DETAIL

Learning course: SQL: Topic-wise practice
Problem Link: Practice Problem in - CodeChef