Queries Required:
- Employees with salary greater than 10,000 but not including the AD_PRES or AD_VP. Please make sure to provide employee_id, first_name, last_name.
- Department employee counts in descending order.
- Count of employees by JOB_ID and details about their JOB_ID. This should include JOB_TITLE, MIN_SALARY and MAX_SALARY.
- Employees who have had previous roles within the company and the count of them. Please make sure to provide employee_id, first_name, last_name.
- Employee count by location.
- Salary average by location.
- Salary average by Region.
Part 2
Assignment:
1. Create a grades table with Student ID, Section ID and Grade.
2. When a student registers for a class, add a record to the GRADE table. This record should
include the student ID and the section ID with no grade or null.
3. When a student is removed from the student table. All classes in which they were registered
and have not received a grade should be marked as “D” or deletedre)
0 comments