You are working on the new internal web system that requires that you use your expertise search from the database to provide adequate feedback to your supervisor. The company has centralized database which lets you organise and manage all the employee data from a single point. With this finest employee database, the end user can easily track the Projects, Leaves, Attendances, Timesheets, Salaries, Expenses, and more from employee. Keep the log of employee lifecycle and examine the improvements in your workforce over the period with this employee database management system. Use the Company_XYZ database to write the SQL queries that solve the questions below. Perform an SQL request to search in the database for each department that has more than five employees, search for department number, working hours and the number of its employees who are earning at least R40,000 and ordered by last name.
You are working on the new internal web system that requires that you use your expertise
search from the
centralized database which lets you organise and manage all the employee data from a single
point. With this finest employee database, the end user can easily track the Projects, Leaves,
Attendances, Timesheets, Salaries, Expenses, and more from employee. Keep the log of
employee lifecycle and examine the improvements in your workforce over the period with this
employee database management system. Use the Company_XYZ database to write the SQL
queries that solve the questions below.
Perform an SQL request to search in the database for each department that has more
than five employees, search for department number, working hours and the number of
its employees who are earning at least R40,000 and ordered by last name.
Step by step
Solved in 4 steps