SQL Query , sorting out the data using column values, with conditions involved

I am new to Data analysis, and just starting out at my new job. The database is Oracle 11g and query tool i am using is SQL Developer. Any tips would be greatly appreciated. I have attached a link excel file as I couldn't make table here. I am having a hard time figuring out the logic for this one. Please have a look and Thank you in advance. enter image description here