4. Write an Oracle SQL query to display the department information (id) and number of employees for each department that
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
4. Write an Oracle SQL query to display the department information (id) and number of employees for each department that
4. Write an Oracle SQL query to display the department information (id) and number of employees for each department that has 8 employees or more. sort the output based on department in ascending order 5. Write an Oracle SQL statement to display current date and the number of days that are left in the current year (remark: your query should work no matter what month is it. 6. display the full name of each employee and his job title and his start date and end date of his job.