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