how query executes in Sql server

Published --