Itzik Ben-gan T-sql Fundamentals High Quality

: Understand the exact order in which SQL Server evaluates clauses (e.g., why you can't use an alias from the SELECT clause in the WHERE clause) .

Here’s my honest, in-depth take after working through it. itzik ben-gan t-sql fundamentals