Question 1: Describe conceptually how an SQL retrieval query will be executed by specifying the conceptual order of executing each of the six clauses?
Question 2: Discuss the various types of join operations (inner vs. outer) with a brief description of where best to use them?