SQL Order of execution

Did you know that SQL Servers internal order of operations does not start with SELECT? Understanding what is going on under the hood will enable T-SQL newbies and those that don't code "all that much" to write better and more efficient code off the bat.