Firstly, count the employee in the R&D department;
Secondly, count how many employees of Sales department is more than that of the R&D department;
Thirdly, find out the discrepancy in the average employee ages between the R&D and Marketing departments.
SQL solution:
esProc Solution:
No comments:
Post a Comment