You are working with Azure Synapse Analytics and need to transform data using Transact-SQL (T-SQL). The task involves joining two large tables, 'Orders' and 'Customers', on the 'CustomerID' field and then filtering the results to include only orders placed in the last year. Which T-SQL query would be most efficient for this task, considering the size of the tables and the need for performance optimization?

Simulated

SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID WHERE OrderDate >= DATEADD(year, -1, GETDATE());*

100.0%

SELECT * FROM Orders, Customers WHERE Orders.CustomerID = Customers.CustomerID AND OrderDate >= DATEADD(year, -1, GETDATE());*

0.0%

SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;*

0.0%

SELECT * FROM Orders WHERE OrderDate >= DATEADD(year, -1, GETDATE());*

0.0%

Microsoft Azure Data Engineer Associate - DP-203