Fundamentals — Itzik Ben-gan T-sql

Clarifies why column aliases are not allowed in WHERE but allowed in ORDER BY

Build a solid, practical foundation in T-SQL (Microsoft SQL Server) covering set-based thinking, query tuning basics, and key language features.

If you study Itzik Ben-Gan T-SQL Fundamentals thoroughly, you will dominate in three specific areas where most professionals stumble: itzik ben-gan t-sql fundamentals