-
Notifications
You must be signed in to change notification settings - Fork 0
/
TeamMerchandise Insertion.sql
120 lines (120 loc) · 6.8 KB
/
TeamMerchandise Insertion.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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Boston Celtics Hat', 21);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Boston Celtics Shirt', 22);
INSERT INTO TeamMerchandise VALUES(21);
INSERT INTO TeamMerchandise VALUES(22);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Dallas Mavericks Hat', 23);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Dallas Mavericks Shirt', 24);
INSERT INTO TeamMerchandise VALUES(23);
INSERT INTO TeamMerchandise VALUES(24);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Brooklyn Nets Hat', 25);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Brooklyn Nets Shirt', 26);
INSERT INTO TeamMerchandise VALUES(25);
INSERT INTO TeamMerchandise VALUES(26);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Houston Rockets Hat', 27);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Houston Rockets Shirt', 28);
INSERT INTO TeamMerchandise VALUES(27);
INSERT INTO TeamMerchandise VALUES(28);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'New York Knicks Hat', 29);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'New York Knicks Shirt', 30);
INSERT INTO TeamMerchandise VALUES(29);
INSERT INTO TeamMerchandise VALUES(30);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Memphis Grizzlies Hat', 31);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Memphis Grizzlies Shirt', 32);
INSERT INTO TeamMerchandise VALUES(31);
INSERT INTO TeamMerchandise VALUES(32);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Philadelphia 76ers Hat', 33);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Philadelphia 76ers Shirt', 34);
INSERT INTO TeamMerchandise VALUES(33);
INSERT INTO TeamMerchandise VALUES(34);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'New Orleans Pelicans Hat', 35);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'New Orleans Pelicans Shirt', 36);
INSERT INTO TeamMerchandise VALUES(35);
INSERT INTO TeamMerchandise VALUES(36);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Toronto Raptors Hat', 37);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Toronto Raptors Shirt', 38);
INSERT INTO TeamMerchandise VALUES(37);
INSERT INTO TeamMerchandise VALUES(38);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'San Antonio Spurs Hat', 39);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'San Antonio Spurs Shirt', 40);
INSERT INTO TeamMerchandise VALUES(39);
INSERT INTO TeamMerchandise VALUES(40);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Chicago Bulls Hat', 41);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Chicago Bulls Shirt', 42);
INSERT INTO TeamMerchandise VALUES(41);
INSERT INTO TeamMerchandise VALUES(42);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Denver Nuggets Hat', 43);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Denver Nuggets Shirt', 44);
INSERT INTO TeamMerchandise VALUES(43);
INSERT INTO TeamMerchandise VALUES(44);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Cleveland Cavaliers Hat', 45);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Cleveland Cavaliers Shirt', 46);
INSERT INTO TeamMerchandise VALUES(45);
INSERT INTO TeamMerchandise VALUES(46);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Minnesota Timberwolves Hat', 47);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Minnesota Timberwolves Shirt', 48);
INSERT INTO TeamMerchandise VALUES(47);
INSERT INTO TeamMerchandise VALUES(48);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Detroit Pistons Hat', 49);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Detroit Pistons Shirt', 50);
INSERT INTO TeamMerchandise VALUES(49);
INSERT INTO TeamMerchandise VALUES(50);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Oklahoma City Thunder Hat', 51);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Oklahoma City Thunder Shirt', 52);
INSERT INTO TeamMerchandise VALUES(51);
INSERT INTO TeamMerchandise VALUES(52);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Indiana Pacers Hat', 53);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Indiana Pacers Shirt', 54);
INSERT INTO TeamMerchandise VALUES(53);
INSERT INTO TeamMerchandise VALUES(54);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Portland Trail Blazers Hat', 55);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Portland Trail Blazers Shirt', 56);
INSERT INTO TeamMerchandise VALUES(55);
INSERT INTO TeamMerchandise VALUES(56);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Milwaukee Bucks Hat', 57);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Milwaukee Bucks Shirt', 58);
INSERT INTO TeamMerchandise VALUES(57);
INSERT INTO TeamMerchandise VALUES(58);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Utah Jazz Hat', 59);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Utah Jazz Shirt', 60);
INSERT INTO TeamMerchandise VALUES(59);
INSERT INTO TeamMerchandise VALUES(60);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Atlanta Hawks Hat', 61);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Atlanta Hawks Shirt', 62);
INSERT INTO TeamMerchandise VALUES(61);
INSERT INTO TeamMerchandise VALUES(62);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Golden State Warriors Hat', 63);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Golden State Warriors Shirt', 64);
INSERT INTO TeamMerchandise VALUES(63);
INSERT INTO TeamMerchandise VALUES(64);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Charlotte Hornets Hat', 65);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Charlotte Hornets Shirt', 66);
INSERT INTO TeamMerchandise VALUES(65);
INSERT INTO TeamMerchandise VALUES(66);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Los Angeles Clippers Hat', 67);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Los Angeles Clippers Shirt', 68);
INSERT INTO TeamMerchandise VALUES(67);
INSERT INTO TeamMerchandise VALUES(68);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Miami Heat Hat', 69);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Miami Heat Shirt', 70);
INSERT INTO TeamMerchandise VALUES(69);
INSERT INTO TeamMerchandise VALUES(70);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Los Angeles Lakers Hat', 71);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Los Angeles Lakers Shirt', 72);
INSERT INTO TeamMerchandise VALUES(71);
INSERT INTO TeamMerchandise VALUES(72);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Orlando Magic Hat', 73);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Orlando Magic Shirt', 74);
INSERT INTO TeamMerchandise VALUES(73);
INSERT INTO TeamMerchandise VALUES(74);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Phoenix Suns Hat', 75);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Phoenix Suns Shirt', 76);
INSERT INTO TeamMerchandise VALUES(75);
INSERT INTO TeamMerchandise VALUES(76);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Washington Wizards Hat', 77);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Washington Wizards Shirt', 78);
INSERT INTO TeamMerchandise VALUES(77);
INSERT INTO TeamMerchandise VALUES(78);
INSERT INTO Product VALUES(8.99, 24.99, 0.10, 'Sacramento Kings Hat', 79);
INSERT INTO Product VALUES(3.99, 13.99, 0.15, 'Sacramento Kings Shirt', 80);
INSERT INTO TeamMerchandise VALUES(79);
INSERT INTO TeamMerchandise VALUES(80);