5. Give a list of all the managers(fname, lname and dept). [Hint: Self Join] 6.

ID: 3698466 • Letter: 5

Question

5. Give a list of all the managers(fname, lname and dept). [Hint: Self Join]

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

7. 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)!

8. Give the employee(fname and lname) that make the most money in each dept.

Table Tools Employees (1): Database- CUsers A Loner DownloadsEmployees (1).accdb (Access 2007 - 2016 file forma... carlos rosas ? File Home Create External Dato Database Tools Fields abe Tell me what you want to do Employees All Tables Employees EID FNAME LNAME DEPTM ANAGE SALARY BUIL DRETIREACCTRETIREACCTNUM RETIREAMOUN- Click to Add Employees Table $14,000.00 mutualfunds mutualfunds mutualfunds Davis $42,000.00 WolfGuy. (#botcom mands) topinvites Record: ? ? 7 of 16 ? ?! No Filter Search Datasheet View 10:06 AM O Type here to search 3/29/2018

Explanation / Answer

1. Selct distinct fname,lname,dept from Employees emp1 inner join Employees emp2 on emp1.EID == emp2.MANAGE

2. Selct distinct fname,lname,dept from Employees where RetireAcctNum = 'stocks'

4. Select fname,lname,dept, max(salary) from employees groupby dept,salary

Navigate

5. Give a function f(y) so that f is polynomial and y\' = f(y) has a stable equi

5. Give the ordinary generating function for the sequence rn in which rn is the

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.

5. Give a list of all the managers(fname, lname and dept). [Hint: Self Join] 6.

Question

Explanation / Answer

Related Questions

Navigate