Help me in solving SQLP50 problem

[oo005]

My issue

explain solution

Learning course: SQL: 80 Topic wise Practice Queries
Problem Link: Group users Practice Problem in SQL: 80 Topic wise Practice Queries