Coding Assignment

Use the following tables to answer the following questions:

1. Get all employee details from the employee table 2. Get First_Name,Last_Name from employee table 3. Get First_Name from employee table using alias name “Employee Name” 4. Get First_Name from employee table in upper case 5. Get First_Name from employee table in lower case 6. Get unique DEPARTMENT from employee table 7. Select first 3 characters of FIRST_NAME from EMPLOYEE 8. Get position of 'o' in name 'Jhon' from employee table 9. Get FIRST_NAME from employee table after removing white spaces from right side