Get all employee details from the employee table

Question

Homework

Use the following tables to answer the following questions:

Table Name: Employee
EMPLOYEE _ID	FIRST_NAME	LAST_NAME	SAL) JOINING_DATE		DEPARTMENT
1	Jhon	Abraham	1000	01-JAN-13 12.00.00 AM	Banking
2	Michael	Clarke	8000	01-JAN-13 12.00.00 AM	Insurance
3	Roy	Thomas	7000	01-FEB-13 12.00.00 AM	Banking
4	Tom	Jose	6000	01-FEB-13 12.00.00 AM	Insurance
5	Jerry	Pinto	6500	01-FEB-13 12.00.00 AM	Insurance
6	Philip	Mathew	7500	01-JAN-13 12.00.00 AM	Services
7	TestNamel	123	6500	01-JAN-13 12.00.00 AM	Services
8	TestName2	Lname%	6000	01-FEB-13 12.00.00 AM	Insurance

Table Name : Incentives
EMPLOYEE REF ID	INCENTIVE DATE	INCENTIVE AMOUNT
1	01-FEB-13	5000
2	01-FEB-13	3000
3	01-FEB-13	4000
1	01-JAN-13	4500
2	01-JAN-13	3500

a. Get all employee details from the employee table
b. Get First_Name,Last_Name from employee table
c. Get First_Name from employee table using alias name "Employee Name"
d. Get First_Name from employee table in upper case
e. Get First_Name from employee table in lower case
f. Get unique DEPARTMENT from employee table
g. Select first 3 characters of FIRST_NAME from EMPLOYEE
h. Get position of 'o' in name 'Jhon' from employee table
i. Get FIRST_NAME from employee table after removing white spaces from right side

Format your homework according to the give formatting requirements:

a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.

b. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.

c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.