You are working on a data transformation project using Transact-SQL (T-SQL) in Azure Synapse Analytics. The project involves joining two large tables, 'Orders' and 'Customers', on the 'CustomerID' field and then performing a series of transformations, including filtering, aggregation, and sorting. Which T-SQL query would you use to achieve this, considering the size of the tables and the need for performance optimization? | Microsoft Azure Data Engineer Associate - DP-203 Quiz