See the below tables and solve the given queries.

Table: Employee

 

 

Table: Incentives

 

 

Questions

1. Get First_Name from employee table in upper case.
2. Get First_Name from employee table in lower case.
3. Get unique DEPARTMENT from employee table.
4. Select first 3 characters of FIRST_NAME from EMPLOYEE.
5. Get position of 'o' in name 'John' from employee table.
6. Get FIRST_NAME from employee table after removing white spaces from right side.
7. Get FIRST_NAME from employee table after removing white spaces from left side.
8. Get length of FIRST_NAME from employee table.
9. Get First_Name from employee table after replacing 'o' with '$'.
10. Get First_Name and Last_Name as single column from employee table separated by a '_'.
11. Get FIRST_NAME, Joining year, Joining Month and Joining Date from employee table.
12. Get Joining Date and Time from employee table.
13. Get Joining Date, Time including milliseconds from employee table.
14. Get difference between JOINING_DATE and INCENTIVE_DATE from employee and incentives table.
15. Get database date.
16. Get names of employees from employee table who has '%' in Last_Name. (Tip: Escape character for special characters in a query).
17. Get department wise average salary from employee table order by salary ascending.
18. Get department wise maximum salary from employee table order by salary ascending.
19. Get department wise minimum salary from employee table order by salary ascending.
20. Select no of employees joined with respect to year and month from employee table.

Note:

1. Upload screenshots containing query and its output in either jpg or png format.
2. Name of screenshot file name must be Question No. i.e. 1.jpg or 1.png.
3. Optional questions are not required to submit.