One More Join$($Self Join$)$

$1.)$ Give a list of all the employees, include their

manager's first and last names. $($So include emp

fname, lname and dept and their manager's fname and

lname$).[$Hint: Self Join$]$

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, Iname 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

$5.)$ Give a list of all employees$($fname$,$ lname and eid$)$

who have their RetirementAccounts in Stocks.

$6.)$ Give me the person$($fname and lname$)$ that makes the

most $$ and the person that makes the least. Use only

one query$(2$ sub$-$queries$)!$

$7.)$ Give the employee$($fname and lname$)$ that make the

most money in each dept.