CIST 1220: SQL – Assign #11 (40 Points) [Simple SubQueries – Chap…

Question Answered step-by-step CIST 1220: SQL – Assign #11 (40 Points) [Simple SubQueries – Chap… CIST 1220: SQL – Assign #11(40 Points) [Simple SubQueries – Chap 11] Using the NEW database provided(“Employee.accdb” à See Blackboard to download this DB), write SELECT statements to get the following information(most answers should use Sub-Queries):           One More Join(Self Join) 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 QueriesWho(give their name) makes the most money in each building? List all the employees, fname, lname and dept  who make more money than the avg? Give the person, lname and fname, and their account number, who has the most money in their Retirement Account. 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.Give a list of all employees(fname, lname and eid) who have their RetirementAccounts in Stocks. 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)! Give the employee(fname and lname) that make the most money in each dept.        Computer Science Engineering & Technology MYSQL CIST 1220 Share QuestionEmailCopy link Comments (0)