Question of sql server

Question

One question that is asked in almost every interview about the steps involved in execution of sql query with example?

 

Thanks in advance.