Help me in solving SQLP30 problem

[rcp_231106066]

My issue

after trying lot of time my answer is not right please provide some help

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