Answer to Question #241051 in Databases | SQL | Oracle | MS Access for MKD

Question

1) Find the manager who manages most employees but also being managed by someone else .

2) Find the artist name who is the most profitable commercially ? (his/her tracks have been sold the most)

ER-Diagram for this questions

https://i.stack.imgur.com/CX01i.png

Answer 1

SELECT ReportsTo
FROM Employees
WHERE Employees.ReportsTo = Employees.ReportsTo.max() AND COUNT(Employees.ReportsTo.max()) > 0