Rewrite a Teradata Query to Azure Synapse/SQL Server Query -- 2

I have a query in Teradata query language and I want to rewrite it to Azure Synapse/SQL Server query language. The task needs expertise in both Teradata query language and Azure Synapse/SQL Server query language. The query is attached. If underlying tables/views are needed I can also provide them. I also need testing to make sure the new query on Azure Synapse will return the same result as on Teradata for some sample data.

Please answer to these questions in your quote:
1- Are you familiar with Teradata query language?
2- Are you familiar with Azure Synapse/SQL Server query language?
3- Did you do any query rewriting from Teradata query language to Azure Synapse/SQL Server query language before?
4- How you make sure the rewritten query on Azure Synapse is equivalent to the original query on Teradata query language?