1) How many male and female employees are there in the organization?
2) Print the name of all departments in the organization?
3) What is the average age of male and female employees?
4) Get the details of highest paid employee in the organization?
5) Get the names of all employees who have joined after 2015?
6) Count the number of employees in each department?
7) What is the average salary of each department?
8) Get the details of youngest male employee in the product development department?
9) Who has the most working experience in the organization?
10) How many male and female employees are there in the sales and marketing team?
11) What is the average salary of male and female employees?
12) List down the names of all employees in each department?
13) What is the average salary and total salary of the whole organization?
14) Separate the employees who are younger or equal to 25 years from those employees who are older than 25 years?
15) Who is the oldest employee in the organization? What is his age and which department he belongs to?
See the Java 8 code at https://javaconceptoftheday.com/solving-real-time-queries-using-java-8-features-employee-management-system/
Top comments (0)