This assignment is based on HR data stored in hr.sql file inside Assignment Data directory.

1. Write a query to display the names (first_name, last_name) using alias name “First Name", "Last Name"
2. Write a query to get unique department ID from employee table.
3. Write a query to get all employee details from the employee table order by first name, descending.
4. Write a query to get the names (first_name, last_name), salary, PF of all the employees (PF is calculated as 12% of salary).
5. Write a query to get the employee ID, names (first_name, last_name), salary in ascending order of salary.
6. Write a query to get the total salaries payable to employees.
7. Write a query to get the maximum and minimum salary from employees table.
8. Write a query to get the average salary and number of employees in the employees table.
9. Write a query to get the number of employees working with the company.
10. Write a query to get the number of jobs available in the employees table.
11. Write a query get all first name from employees table in upper case.
12. Write a query to get the first 3 characters of first name from employees table.
13. Write a query to calculate 171*214+625.
14. Write a query to get the names (for example Ellen Abel, Sundar Ande etc.) of all the employees from employees table.
15. Write a query to get first name from employees table after removing white spaces from both side.
16. Write a query to get the length of the employee names (first_name, last_name) from employees table.
17. Write a query to check if the first_name fields of the employees table contains numbers.
18. Write a query to select first 10 records from a table.
19. Write a query to get monthly salary (round 2 decimal places) of each and every employee.
20. Write a query to display the names (first_name, last_name) and salary for all employees whose salary is not in the range $10,000 through $15,000.
21. Write a query to display the names (first_name, last_name) and department ID of all employees in departments 30 or 100 in ascending alphabetical order by department ID.
22. Write a query to display the names (first_name, last_name) and salary for all employees whose salary is not in the range $10,000 through $15,000 and are in department 30 or 100.
23. Write a query to display the names (first_name, last_name) and hire date for all employees who were hired in 1987.
24. Write a query to display the first_name of all employees who have both "b" and "c" in their first name.
25. Write a query to display the last name, job, and salary for all employees whose job is that of a Programmer or a Shipping Clerk, and whose salary is not equal to $4,500, $10,000, or $15,000.
26. Write a query to display the last names of employees whose names have exactly 6 characters.
27. Write a query to display the last names of employees having 'e' as the third character.
28. Write a query to display the jobs/designations available in the employees table.
29. Write a query to display the names (first_name, last_name), salary and PF (15% of salary) of all employees.
30. Write a query to select all record from employees where last name in 'BLAKE', 'SCOTT', 'KING' and 'FORD'.
31. Write a query to list the number of jobs available in the employees table.
32. Write a query to get the total salaries payable to employees.
33. Write a query to get the minimum salary from employees table.
34. Write a query to get the maximum salary of an employee working as a Programmer.
35. Write a query to get the average salary and number of employees working the department 90.
36. Write a query to get the highest, lowest, sum, and average salary of all employees.
37. Write a query to get the number of employees with the same job.
38. Write a query to get the difference between the highest and lowest salaries.
39. Write a query to find the manager ID and the salary of the lowest-paid employee for that manager.
40. Write a query to get the department ID and the total salary payable in each department.
41. Write a query to get the average salary for each job ID excluding programmer.
42. Write a query to get the total salary, maximum, minimum, average salary of employees (job ID wise), for department ID 90 only.
43. Write a query to get the job ID and maximum salary of the employees where maximum salary is greater than or equal to $4000.
44. Write a query to get the average salary for all departments employing more than 10 employees.
45. Write a query to find the addresses (location_id, street_address, city, state_province, country_name) of all the departments.
46. Write a query to find the names (first_name, last name), department ID and name of all the employees.
47. Find the names (first_name, last_name), job, department number, and department name of the employees who work in London.
48. Write a query to find the employee id, name (last_name) along with their manager_id, manager name (last_name).
49. Find the names (first_name, last_name) and hire date of the employees who were hired after 'Jones'.
50. Write a query to get the department name and number of employees in the department.
51. Find the employee ID, job title, number of days between ending date and starting date for all jobs in department 90 from job history.
52. Write a query to display the department ID, department name and manager first name.
53. Write a query to display the department name, manager name, and city.
54. Write a query to display the job title and average salary of employees.
55. Display job title, employee name, and the difference between salary of the employee and minimum salary for the job.
56. Write a query to display the job history that were done by any employee who is currently drawing more than 10000 of salary.
57. Write a query to display department name, name (first_name, last_name), hire date, salary of the manager for all managers whose experience is more than 15 years.