Answer to Question #171898 in Databases | SQL | Oracle | MS Access for Maryam

Question

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”)<o:p></o:p>

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.

Example: [e-mail]

 

 

Answer 1

Dear Maryam, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order