Exercise 2 (Retrieving Data)

1. Select employee names who born in 1971.

2. Select employee names who works in deptno 20 and born in 1972.

3. Select employee names who born between 1950 and 1974.

4. Select empno, employee name, addition of salary and commission for deptno 40.

5. Select number of records in employee table.

6. Select number of records in deptno table where deptno is less than 20.

7. Select all the departments in Dallas.

8. Select all the departments where department name starts with A.

9. Select different department numbers in employee table.

10. Select number of rows in employee address who lives in Dallas.