Employee Table (emp) for March 24 SQL Lecture
| EMPNO |
ENAME |
JOB |
SAL |
COMM |
DEPTNO |
MGR |
HIREDATE |
| 7934 |
Miller |
Clerk |
1300.00 |
|
10 |
7782 |
1/23/1982 |
| 7782 |
Clark |
Manager |
2450.00 |
|
10 |
7839 |
10/20/1985 |
| 7839 |
King |
President |
5000.00 |
|
10 |
|
11/17/1981 |
| 7788 |
Scott |
Analyst |
3000.00 |
|
20 |
7902 |
12/9/1982 |
| 7876 |
Adams |
Clerk |
1100.00 |
|
20 |
7902 |
1/12/1983 |
| 7369 |
Smith |
Clerk |
1000.00 |
|
20 |
7902 |
5/20/1980 |
| 7902 |
Ford |
Manager |
3000.00 |
|
20 |
7839 |
12/3/1981 |
| 7566 |
Jones |
Manager |
2975.00 |
|
20 |
7839 |
4/21/1981 |
| 7900 |
James |
Clerk |
950.00 |
|
30 |
7698 |
12/3/1981 |
| 7698 |
Blake |
Manager |
2850.00 |
|
30 |
7839 |
10/5/1990 |
| 7499 |
Allen |
Salesman |
1600.00 |
|
30 |
7698 |
6/7/1987 |
| 7654 |
Martin |
Salesman |
1250.00 |
|
30 |
7698 |
9/28/1981 |
| 7844 |
Turner |
Salesman |
1500.00 |
0 |
30 |
7698 |
9/21/1985 |
| 7521 |
Ward |
Salesman |
1250.00 |
|
30 |
7698 |
6/7/1988 |
| 7182 |
Reinor |
Designer |
2000.00 |
|
50 |
7839 |
7/25/1986 |
| 7215 |
Bright |
WebMaster |
3000.00 |
|
50 |
7182 |
9/4/1980 |