Fix a Problem with Aliasing
We are aware of aliasing in SQL Server , but its impact is huge. You are presented with another grouped query that fails, this time because of an aliasing problem. As in the first exercise, you are provided with instructions on how to fix the query. 1. Clear the query window, type the following query, and execute it. SELECT OrgID, SUM(SaleOrders) AS SaleOrders FROM Sales.Orders WHERE SaleOrders > 20000 ...