-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathload-northwind-table-employee-territories.sql
53 lines (52 loc) · 3.3 KB
/
load-northwind-table-employee-territories.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
-- Load data into the northwind.employee_territories table
INSERT INTO northwind.employee_territories VALUES (1, '06897');
INSERT INTO northwind.employee_territories VALUES (1, '19713');
INSERT INTO northwind.employee_territories VALUES (2, '01581');
INSERT INTO northwind.employee_territories VALUES (2, '01730');
INSERT INTO northwind.employee_territories VALUES (2, '01833');
INSERT INTO northwind.employee_territories VALUES (2, '02116');
INSERT INTO northwind.employee_territories VALUES (2, '02139');
INSERT INTO northwind.employee_territories VALUES (2, '02184');
INSERT INTO northwind.employee_territories VALUES (2, '40222');
INSERT INTO northwind.employee_territories VALUES (3, '30346');
INSERT INTO northwind.employee_territories VALUES (3, '31406');
INSERT INTO northwind.employee_territories VALUES (3, '32859');
INSERT INTO northwind.employee_territories VALUES (3, '33607');
INSERT INTO northwind.employee_territories VALUES (4, '20852');
INSERT INTO northwind.employee_territories VALUES (4, '27403');
INSERT INTO northwind.employee_territories VALUES (4, '27511');
INSERT INTO northwind.employee_territories VALUES (5, '02903');
INSERT INTO northwind.employee_territories VALUES (5, '07960');
INSERT INTO northwind.employee_territories VALUES (5, '08837');
INSERT INTO northwind.employee_territories VALUES (5, '10019');
INSERT INTO northwind.employee_territories VALUES (5, '10038');
INSERT INTO northwind.employee_territories VALUES (5, '11747');
INSERT INTO northwind.employee_territories VALUES (5, '14450');
INSERT INTO northwind.employee_territories VALUES (6, '85014');
INSERT INTO northwind.employee_territories VALUES (6, '85251');
INSERT INTO northwind.employee_territories VALUES (6, '98004');
INSERT INTO northwind.employee_territories VALUES (6, '98052');
INSERT INTO northwind.employee_territories VALUES (6, '98104');
INSERT INTO northwind.employee_territories VALUES (7, '60179');
INSERT INTO northwind.employee_territories VALUES (7, '60601');
INSERT INTO northwind.employee_territories VALUES (7, '80202');
INSERT INTO northwind.employee_territories VALUES (7, '80909');
INSERT INTO northwind.employee_territories VALUES (7, '90405');
INSERT INTO northwind.employee_territories VALUES (7, '94025');
INSERT INTO northwind.employee_territories VALUES (7, '94105');
INSERT INTO northwind.employee_territories VALUES (7, '95008');
INSERT INTO northwind.employee_territories VALUES (7, '95054');
INSERT INTO northwind.employee_territories VALUES (7, '95060');
INSERT INTO northwind.employee_territories VALUES (8, '19428');
INSERT INTO northwind.employee_territories VALUES (8, '44122');
INSERT INTO northwind.employee_territories VALUES (8, '45839');
INSERT INTO northwind.employee_territories VALUES (8, '53404');
INSERT INTO northwind.employee_territories VALUES (9, '03049');
INSERT INTO northwind.employee_territories VALUES (9, '03801');
INSERT INTO northwind.employee_territories VALUES (9, '48075');
INSERT INTO northwind.employee_territories VALUES (9, '48084');
INSERT INTO northwind.employee_territories VALUES (9, '48304');
INSERT INTO northwind.employee_territories VALUES (9, '55113');
INSERT INTO northwind.employee_territories VALUES (9, '55439');
-- Verify the northwind.employee_territories table was loaded with data correctly
SELECT * FROM northwind.employee_territories;