1) List the name of the division that has more than three employees whose salary is greater...
Fantastic news! We've Found the answer you've been seeking!
Question:
1) List the name of the division that has more than three employees whose salary is greater than his/her divisional average salary.
2) List the name of the division has more man-hours on project 'web development' than man-hours on project 'DB development. Also list the man-hours of both projects (use correlated subquery at both where clause and select clause
3) List the name of the employee that has the lowest salary in his division and list the total number of projects this employee work on (use corelated subquery)
4) List the name of employee in Sam's division who works on a project that Sam does NOT work on.
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: