Write sub queries

$1.)$ Who$($give their name$)$ makes the most money in each building?

$$

$2.)$ List all the employees, fname, lname and dept$$ who make more money than the avg?

$$

$3.)$ Give the person, lname and fname, and their account number, who has the most money in their Retirement Account.

$$

$4.)$ Give a list of all employees$($fname$,$ lname and dept$)$ who make the least amount of money in their building, but only if they work in building $400,402$ or $405.$

$5.)$ Give a list of all employees$($fname$,$ lname and eid$)$ who have their RetirementAccounts in Stocks.

$1.)$ Who$($give their name$)$ makes the most money in each building?