Convert Three MSSQL Queries to Oracle

I have three MS SQL SQL queries that I need to convert to Oracle. Please see the attached files. I need the queries to work with all versions of Oracle. If there is going to be any issues doing that, I need to know upfront before the project starts and specify the versions the code will work for. This project will not be signed off on until I personally test code on various versions of Oracle. You will need to be patient as I do that - it will take some time to test. I may have some questions during the process which you will need to answer. I must be 100% satisfied with the results. Including the phrase dbguru in your bid will help you win the project. I am also a programmer. I know how long it takes to write a few queries. Please do not overbid. Thanks!