SQL Server Logical Phases of Query Processing

Here is how SQL Server process clauses in your SELECT statement;