Subject - Database management

Q1. (a) Display all departments sorted by their location in descending order. When multiple departments are located at the same location ID, show their names in alphabetical order. Columns to show: Location ID and Department Name.

(b) Display all Employees who were hired in 2008. Columns to show: Employee ID, First and Last name, and the hire date. Order the result by oldest hire date to newest.

(c) Display all Departments without managers whose name contains the word "Sales". Columns to show: Department Name. The results should be displayed by Department name in reverse alphabetical order

(d) Display all Employees (if any) whose last name starts with the first letter of your last name. Columns to show: Employee ID, First and Last name. The results should be displayed by first name in alphabetical ordering.

c.ca/d21/le/content/272343/viewContent/4964767/View Our Oracle HR Database ERD at a Employees HPK employee id -Altached first name last name Jobs Manages email Job_History employee Id. IEKI HPK job ld PK phone_number Hired Detailed PK start date hire_date job_jd [FR] salary job_title min_salary max_salary end_date department_id IFK1 job id [FKI commission pct manager_id (FK department_id [FK1 Departments OH PK department.id Ho Associated Locations department_name manager_id [FK) location_id [FR] Heads -OHPK location id O-Located street address Countries postal_code city PK country_id Ho Resides Regions PK region.id state province +O -Grouped country_name region_id [FK] country_id IFK) region_name e Portfolio Download Print