Convert 5 moderately complex PL/SQL queries to T-SQL. -- 2

Convert PL/SQL to T-SQL. I have 5 moderately complex Oracle PL/SQL select queries that must be converted to Microsoft T-SQL. These queries are Select statements only (no data inserts or updates), but they include nested queries, aliases, and limiting/ordering statements. Experience in PL/SQL and T-SQL is REQUIRED. These are not simple statements, and there is no way to Google your way through these. I will provide you with the 5 functional PL/SQL statements, and I must receive 5 functional T-SQL statements that return the same dataset, with the same formats. I should be able to drop the queries into MS SSMS and run the queries immediately and without additional modifications.

Microsoft SQL Server Oracle

Project ID: #11504325

About the project