This statement creates a temporary named column and uses that column in a WHERE clause.
SELECT Name,((Salary + (YrsExp * 200))/12) AS Projection FROM Employee WHERE DeptNo = 600 AND Projection < 2500;
This statement creates a temporary named column and uses that column in a WHERE clause.
SELECT Name,((Salary + (YrsExp * 200))/12) AS Projection FROM Employee WHERE DeptNo = 600 AND Projection < 2500;