please suggest a syntax or query to solve the problem

I have been trying to folow all the steps shown in the video but got struck here from two days could you look at the screeshot and sugget or comment a query to solve this so that I could finish my project