如何在子查询结果上使用MAX（）？

I am new to Oracle and the SQL world. I have a slight issue with a query that I cannot figure out for the life of me, I have spent a few hours trying different approaches and I cannot get the result I expect. So heres my query:I am new to Oracle and the SQL world. I have a