You have been hired as a database developer to rewrite the legacy HRMS system that is very
Question:
You have been hired as a database developer to rewrite the legacy HRMS system that is very slow and lacks flexibility. The database schema consists of a single table containing 100,000 rows. The name of the table is COMPANY and contains the following columns: -NAME VARCHAR(100) -DEPARTMENT_NAME -MANAGER_NAME -HIRE_DATE DATETIME -SALARY INT
With the parameters provided, please answer the questions accordingly via SQL statements. Find all employees that started this year
Find all employees that have a first name beginning with T and whose last name is Smith Count and display all unique department names Look for the highest paid employee Look for the employee with the longest tenure in the organization How many employees are in the database? Why do you think indexing a field/column in a table is important?