- Hr Departments Locations Location Id Department Id Department Name Street Address Postal Code Manager Id Location Id Job 1 (200.43 KiB) Viewed 28 times
4/5/6
Please Quickly
sql devloper
HR DEPARTMENTS LOCATIONS location_id department_id department_name street_address postal code manager_id location_id JOB_HISTORY city state province country_id EMPLOYEES employee_id start_date end_date job_id department_id employee_id COUNTRIES first_name last_name email country_id country_name phone_number region_id hire_date job_id JOBS job_id job_title min_salary salary commission_pct REGIONS manager_id region_id max_salary department_id region_name # Question 1. Write an Oracle SQL statement to display the first day of the current year as "FirstDay" and last day of the current year as "Last Day" 2. Write an Oracle SQL query to display the employee information: full name, job_id, department_id for all employees who are working in the department no 30, 40, 50,60. Also the information are displayed for those who are working as 'SA_REP', 'ST_MAN' or 'HR_REP'. 3. Write an Oracle SQL query to display the maximum salary being paid to 'SA_REP'. Name the output column MaxSal 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. 7. Display all information from table jobs 8. Write a query to list the employees who are joined in the year between '01-Jan- 2004' and '31-Dec-2008'. 9. List department names that has only 7 characters.