The goal of this exercise is to apply what you have learned by dividing data from one column into two different columns.

Note: Each student may choose either the Oracle or Microsoft Access databases.

Instructions:

List all the rows and columns for the L_employees table. Add a new column that says "Old Timer" for any employee that was hired before the year 2000 and is blank for all oTher employees. Sort this by the employee_id column.

List the last name, first name, and hire date of all the people in the L_employees table. Divide the hire date column into two columns: one called "old timers" for people hired before the year 2000, and one called "newer hires" for people hired after that year. Sort the result table by the last name and then by first name.