SELECT ProductID, ProductName, SUM(Amount) AS TotalAmount FROM Staging.Sales WHERE DATEPART(YEAR, SaleDate) = '2023' GROUP BY ProductID, ProductName HAVING SUM(Amount) > 10000

SELECT ProductID, ProductName, SUM(Amount) AS TotalAmount FROM Staging.Sales GROUP BY ProductID, ProductName HAVING SUM(Amount) > 10000 AND DATEPART(YEAR, SaleDate) = '2023'

SELECT ProductID, ProductName, SUM(Amount) AS TotalAmount WHERE DATEPART(YEAR, SaleDate) = '2023' AND SUM(Amount) > 10000 GROUP BY ProductID, ProductName FROM Staging.Sales

SELECT ProductID, ProductName, SUM(Amount) AS TotalAmount FROM Staging.Sales WHERE YEAR(SaleDate) = '2023' GROUP BY ProductID, ProductName HAVING TotalAmount > 10000