Exercise 3 (Retrieving Data)

1. Select maximum, minimum salary in employee table.

2. Select minimum salary,commission in employee table for deptno 20.

3. Select employee number, employee name, department number whose sum of salary and commission greater than 2500.

4.Select employee number, employee name, employee age from employee table.

5. Selectemployee number , employee name born in the month of july.

6.Select employee name ,DOB in the format of "2nd of july 1997" for deptno 10 and 20.

7.Display employee names in lower case whose salary is greater than 2000 and less than 2800.

8.Select the number of employees who has no commission .

9.Select employee name whose job is Manager or Clerk and Salary greater than 1000 and commission greater than 100 and deptno is either 10 or 20.

10.Select employee names in an alphabetical order.