Please, explain the steps for processing the following query using the

algorithm discussed in the classes:

Make a list of all the project numbers for projects that involve an employee

whose last name is $$Smith$,$ either as a worker or as a manager of the

department that controls the project.

$($Draw an initial query tree and then show how an initial query tree

is optimized by the algorithm discussed in the class.$)$