/
w3employeestables.sql
59 lines (56 loc) · 2.45 KB
/
w3employeestables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
/*
Sample table: employees
emp_id | emp_name | job_name | manager_id | hire_date | salary | commission | dep_id
--------+----------+-----------+------------+------------+---------+------------+--------
68319 | KAYLING | PRESIDENT | | 1991-11-18 | 6000.00 | | 1001
66928 | BLAZE | MANAGER | 68319 | 1991-05-01 | 2750.00 | | 3001
67832 | CLARE | MANAGER | 68319 | 1991-06-09 | 2550.00 | | 1001
65646 | JONAS | MANAGER | 68319 | 1991-04-02 | 2957.00 | | 2001
67858 | SCARLET | ANALYST | 65646 | 1997-04-19 | 3100.00 | | 2001
69062 | FRANK | ANALYST | 65646 | 1991-12-03 | 3100.00 | | 2001
63679 | SANDRINE | CLERK | 69062 | 1990-12-18 | 900.00 | | 2001
64989 | ADELYN | SALESMAN | 66928 | 1991-02-20 | 1700.00 | 400.00 | 3001
65271 | WADE | SALESMAN | 66928 | 1991-02-22 | 1350.00 | 600.00 | 3001
66564 | MADDEN | SALESMAN | 66928 | 1991-09-28 | 1350.00 | 1500.00 | 3001
68454 | TUCKER | SALESMAN | 66928 | 1991-09-08 | 1600.00 | 0.00 | 3001
68736 | ADNRES | CLERK | 67858 | 1997-05-23 | 1200.00 | | 2001
69000 | JULIUS | CLERK | 66928 | 1991-12-03 | 1050.00 | | 3001
69324 | MARKER | CLERK | 67832 | 1992-01-23 | 1400.00 | | 1001
(14 rows)
Sample table: department
dep_id | dep_name | dep_location
--------+------------+--------------
1001 | FINANCE | SYDNEY
2001 | AUDIT | MELBOURNE
3001 | MARKETING | PERTH
4001 | PRODUCTION | BRISBANE
(4 rows)
Sample table: salary_grade
grade | min_sal | max_sal
-------+---------+---------
1 | 800 | 1300
2 | 1301 | 1500
3 | 1501 | 2100
4 | 2101 | 3100
5 | 3101 | 9999
(5 rows)
*/
select e.emp_id as "employee id", e.emp_name as "employee name", e.manager_id as "manager id", m.emp_name as "manager name"
from employees e, employees m
where m.emp_id = e.manager_id;
/*
employee id employee name manager id manager name
66928 BLAZE 68319 KAYLING
67832 CLARE 68319 KAYLING
65646 JONAS 68319 KAYLING
64989 ADELYN 66928 BLAZE
65271 WADE 66928 BLAZE
66564 MADDEN 66928 BLAZE
68454 TUCKER 66928 BLAZE
68736 ADNRES 67858 SCARLET
69000 JULIUS 66928 BLAZE
69324 MARKER 67832 CLARE
67858 SCARLET 65646 JONAS
69062 FRANK 65646 JONAS
63679 SANDRINE 69062 FRANK
*/