Write an SQL for the following problem and take a screen shot of the output

Task 2: Conversion Function

1) Display last name, first name and hire date of all employees hired before 2008. Display

the hire date in this format (example: "January 25, 2018)

2) Displays the last names of employees under the manager id 124 or 122. Also generate

an email add from getting the first 4 letters of first name of each employee.