$.$ List the manager name and total sales revenue attributable to each manager. $($The list should be in descending order by total sales revenue.$)$Self$-$join!$$

You can FIRST solve the easier alternative: $$List the employees $($EID$,$ Name, City$)$ and their managers $($EID$,$ Name, City$)$ for those employees who are in the same city as their manager$.$ When you get comfortable and get the right result, then approach w the original Question $7.$