Help me in solving SQLP30 problem

[anya2111]

My issue

I couldn’t able to understand sub query part.

Learning course: SQL Practice Queries
Problem Link: Rearrange query - 2 Practice Problem in SQL Practice Queries