ixSr7zT1

1DROP TABLE IF EXISTS placering;
2DROP TABLE IF EXISTS rytter;
3DROP TABLE IF EXISTS vm;
4
5create table rytter
6(
7init char(3) not null,
8rytternavn varchar(30),
9primary key (init),
10)
11
12create table vm
13(
14aarstal int not null,
15bynavn varchar(20),
16land varchar(20),
17primary key (aarstal),
18)
19
20create table placering
21(
22aarstal int,
23init char(3),
24plac int,
25primary key (aarstal, init),
26constraint rytterforeign foreign key (init) references rytter(init),
27constraint vmforeign foreign key (aarstal) references vm(aarstal),
28)
29
30insert into rytter values ('OR', 'Ole Ritter')
31insert into rytter values ('LM', 'Leif Mortensen')
32insert into rytter values ('MF', 'Mogens Frey')
33insert into rytter values ('GF', 'Gert Frank')
34insert into rytter values ('JM', 'Jørgen Marcussen')
35insert into rytter values ('KR', 'Kjell Rodian')
36insert into rytter values ('PB', 'Per Bausager')
37insert into rytter values ('FC', 'Finn Clausen')
38insert into rytter values ('NF', 'Niels Fredborg')
39insert into rytter values ('FR', 'Freddy Reimar')
40insert into rytter values ('KGS', 'Kim G. Svendsen')
41insert into rytter values ('JV', 'Jens Veggerby')
42insert into rytter values ('SMP', 'Steen Michael Pedersen')
43insert into rytter values ('JVP', 'Jørgen V. Pedersen')
44insert into rytter values ('KE', 'Kim Eriksen')
45insert into rytter values ('MM', 'Mikael Marcussen')
46insert into rytter values ('JØ', 'Jan Østergaard')
47insert into rytter values ('BB', 'Brian Bistrup')
48insert into rytter values ('JS', 'Jesper Skibby')
49insert into rytter values ('BR', 'Bjarne Riis')
50insert into rytter values ('CMM', 'Claus Michael Møller')
51insert into rytter values ('BHS', 'Brian Holm')
52insert into rytter values ('RS', 'Rolf Sørensen')
53insert into rytter values ('BH', 'Bo Hamburger')
54insert into rytter values ('KA', 'Kim Andersen')
55insert into rytter values ('PM', 'Peter Meinert')
56insert into rytter values ('LMI', 'Lars Michaelsen')
57insert into rytter values ('NBL', 'Nicolai Bo Larsen')
58insert into rytter values ('FH', 'Frank Høj')
59insert into rytter values ('SP', 'Søren Petersen')
60insert into rytter values ('MK', 'Mikael Kyneb')
61insert into rytter values ('MSJ', 'Mark Strange Jacobsen')
62insert into rytter values ('MS', 'Michael Sandstød')
63insert into rytter values ('DJ', 'Danny Jonassen')
64insert into rytter values ('MB', 'Michael Blaudzun')
65insert into rytter values ('SL', 'Søren Lilholt')
66insert into rytter values ('JWE', 'Johnny Weltz')
67insert into rytter values ('MSO', 'Morten Sonne')
68insert into rytter values ('JMA', 'Jimmi Madsen')
69insert into rytter values ('TB', 'Thomas Bay')
70insert into rytter values ('KW', 'Kenneth Weltz')
71insert into rytter values ('JC', 'John Carlsen')
72insert into rytter values ('PP', 'Per Pedersen')
73insert into rytter values ('JW', 'Jesper Worre')
74insert into rytter values ('TJ', 'Thomas Jørgensen')
75insert into rytter values ('AP', 'Alex Petersen')
76insert into rytter values ('AJ', 'Allan Johansen')
77insert into rytter values ('NS', 'Nikki Sørensen')
78insert into rytter values ('JP', 'Jakob Piil')
79insert into rytter values ('TBR', 'Tayeb Braikia')
80insert into rytter values ('BC', 'Bekim Christensen')
81insert into rytter values ('MSK', 'Michael Skelde')
82insert into rytter values ('MR', 'Michael Rasmussen')
83insert into rytter values ('JMR', 'Jakob Moe Rasmussen')
84insert into rytter values ('MSN', 'Michael Steen Nielsen')
85insert into rytter values ('JBP', 'Jørgen Bo Pedersen')
86insert into rytter values ('BN', 'Bjarke Nielsen')
87insert into rytter values ('LB', 'Lars Ytting Bach')
88insert into rytter values ('RJ', 'Rene Jørgensen')
89insert into rytter values ('MBR', 'Matti Breschel')
90insert into rytter values ('CAS', 'Chris Anker Sørensen')
91insert into rytter values ('AL', 'Anders Lund')
92insert into rytter values ('JF', 'Jacob Fuglsang')
93insert into rytter values ('MMØ', 'Michael Mørkæv')
94insert into rytter values ('AR', 'Alex Rasmussen')
95insert into rytter values ('MV', 'Michael Valgren')
96insert into rytter values ('CJJ', 'Christopher Juul-Jensen')
97insert into rytter values ('RG', 'Rasmus Guldhammer')
98
99
100insert into vm values(2015,'Richmond','USA')
101insert into vm values(2014,'Ponferrada','Spanien')
102insert into vm values(2013,'Florence','Italien')
103insert into vm values(2012,'Valkenburg','Holland')
104insert into vm values(2011,'Rudersdal','Danmark')
105insert into vm values(2010,'Melbourne','Australien')
106insert into vm values(2009,'Mendrisio','Schweiz')
107insert into vm values(2008,'Varese','Italien')
108insert into vm values(2007,'Stuttgart','Tyskland')
109insert into vm values(2006,'Saltzburg','Østrig')
110insert into vm values(2005,'Madrid','Spanien')
111insert into vm values(2004,'Verona','Italien')
112insert into vm values(2003,'Hamilton','Canada')
113insert into vm values(2002,'Zolder','Belgien')
114insert into vm values(2001,'Parc de Monsanto','Portugal')
115insert into vm values(2000,'Plouay','Frankrig')
116insert into vm values(1999,'Verona','Italien')
117insert into vm values(1998,'Valkenburg','Holland')
118insert into vm values(1997,'San Sebastian','Spanien')
119insert into vm values(1996,'Lugano','Schweiz')
120insert into vm values(1995,'Duitama','Colombia')
121insert into vm values(1994,'Agrigento','Italien')
122insert into vm values(1993,'Oslo','Norge')
123insert into vm values(1992,'Benidorm','Spanien')
124insert into vm values(1991,'Stuttgart','Tyskland')
125insert into vm values(1990,'Utsunomiya','Japan')
126insert into vm values(1989,'Chambery','Frankrig')
127insert into vm values(1988,'Ronse','Belgien')
128insert into vm values(1987,'Villach','Østrig')
129insert into vm values(1986,'Colorado Springs','USA')
130insert into vm values(1985,'Giavera-Montello','Italien')
131insert into vm values(1984,'Montjuich','Spanien')
132insert into vm values(1983,'Altenrhein','Schweiz')
133insert into vm values(1982,'Goodwood','England')
134insert into vm values(1981,'Prag','Tjekkoslovakiet')
135insert into vm values(1980,'Sallanches','Frankrig')
136insert into vm values(1979,'Valkenburg','Holland')
137insert into vm values(1978,'Nurburgring','Vesttyskland')
138insert into vm values(1977,'San Cristobal','Venezuela')
139insert into vm values(1976,'Ostuni','Italien')
140insert into vm values(1975,'Yvoir','Belgien')
141insert into vm values(1974,'Montreal','Canada')
142insert into vm values(1973,'Montjuich','Spanien')
143insert into vm values(1972,'Gap','Frankrig')
144insert into vm values(1971,'Mendrisio','Schweiz')
145insert into vm values(1970,'Leicester','England')
146insert into vm values(1969,'Zolder','Belgien')
147insert into vm values(1968,'Imola','Italien')
148insert into vm values(1967,'Heerlen','Holland')
149
150insert into placering values (2015,'CJJ',NULL)
151insert into placering values (2015,'RG',NULL)
152insert into placering values (2015,'MMØ',78)
153insert into placering values (2015,'MV',67)
154insert into placering values (2015,'LB',45)
155insert into placering values (2015,'MBR',33)
156insert into placering values (2014,'CJJ',71)
157insert into placering values (2014,'NS',NULL)
158insert into placering values (2014,'MMØ',NULL)
159insert into placering values (2014,'MV',20)
160insert into placering values (2014,'CAS',31)
161insert into placering values (2014,'MBR',4)
162insert into placering values (2013,'JF',21)
163insert into placering values (2013,'CAS',32)
164insert into placering values (2013,'MBR',NULL)
165insert into placering values (2012,'JF',NULL)
166insert into placering values (2012,'CAS',52)
167insert into placering values (2012,'MBR',NULL)
168insert into placering values (2011,'JF',26)
169insert into placering values (2011,'CAS',129)
170insert into placering values (2011,'NS',43)
171insert into placering values (2011,'LB',32)
172insert into placering values (2011,'AL',57)
173insert into placering values (2011,'MMØ',18)
174insert into placering values (2010,'MBR',2)
175insert into placering values (2010,'CAS',23)
176insert into placering values (2010,'AR',NULL)
177insert into placering values (2010,'LB',76)
178insert into placering values (2010,'AL',24)
179insert into placering values (2010,'MMØ',NULL)
180insert into placering values (2009,'MBR',7)
181insert into placering values (2009,'CAS',13)
182insert into placering values (2009,'FH',NULL)
183insert into placering values (2009,'LB',NULL)
184insert into placering values (2009,'AL',NULL)
185insert into placering values (2009,'JF',43)
186insert into placering values (2008,'MBR',3)
187insert into placering values (2008,'CAS',13)
188insert into placering values (2008,'FH',65)
189insert into placering values (2008,'LB',NULL)
190insert into placering values (2008,'AL',NULL)
191insert into placering values (2008,'JF',NULL)
192insert into placering values (2007,'MBR',NULL)
193insert into placering values (2007,'LB',NULL)
194insert into placering values (2007,'CAS',25)
195insert into placering values (2006,'NS',12)
196insert into placering values (2006,'LB',74)
197insert into placering values (2006,'AJ',125)
198insert into placering values (2005,'JP',6)
199insert into placering values (2005,'LB',39)
200insert into placering values (2005,'LMI',NULL)
201insert into placering values (2004,'MR',13)
202insert into placering values (2004,'MSK',NULL)
203insert into placering values (2004,'LB',NULL)
204insert into placering values (2004,'FH',85)
205insert into placering values (2004,'AJ',NULL)
206insert into placering values (2004,'RJ',NULL)
207insert into placering values (2004,'NS',39)
208insert into placering values (2004,'MB',NULL)
209insert into placering values (2003,'BH',6)
210insert into placering values (2003,'MSK',78)
211insert into placering values (2003,'FH',15)
212insert into placering values (2003,'BC',32)
213insert into placering values (2002,'LMI',12)
214insert into placering values (2002,'MSK',60)
215insert into placering values (2002,'LB',125)
216insert into placering values (2002,'FH',24)
217insert into placering values (2002,'AJ',72)
218insert into placering values (2002,'JP',124)
219insert into placering values (2002,'NS',144)
220insert into placering values (2002,'BC',143)
221insert into placering values (2001,'MR',36)
222insert into placering values (2001,'JBP',NULL)
223insert into placering values (2001,'RS',NULL)
224insert into placering values (2001,'MB',NULL)
225insert into placering values (2001,'FH',NULL)
226insert into placering values (2001,'BN',NULL)
227insert into placering values (2001,'MSO',75)
228insert into placering values (2001,'MSK',91)
229insert into placering values (2000,'BH',22)
230insert into placering values (2000,'LMI',NULL)
231insert into placering values (2000,'RS',63)
232insert into placering values (2000,'JMR',NULL)
233insert into placering values (2000,'FH',NULL)
234insert into placering values (2000,'TBR',NULL)
235insert into placering values (2000,'AJ',NULL)
236insert into placering values (2000,'DJ',71)
237insert into placering values (2000,'NS',41)
238insert into placering values (2000,'MSN',62)
239insert into placering values (1999,'BH',NULL)
240insert into placering values (1999,'LMI',NULL)
241insert into placering values (1999,'MSO',NULL)
242insert into placering values (1999,'RS',13)
243insert into placering values (1999,'MB',NULL)
244insert into placering values (1999,'FH',NULL)
245insert into placering values (1999,'MK',NULL)
246insert into placering values (1999,'AJ',NULL)
247insert into placering values (1999,'DJ',NULL)
248insert into placering values (1999,'NS',44)
249insert into placering values (1999,'SP',NULL)
250insert into placering values (1998,'BH',NULL)
251insert into placering values (1998,'LMI',NULL)
252insert into placering values (1998,'CMM',40)
253insert into placering values (1998,'RS',50)
254insert into placering values (1998,'PM',NULL)
255insert into placering values (1998,'BHS',NULL)
256insert into placering values (1998,'FH',NULL)
257insert into placering values (1998,'MK',27)
258insert into placering values (1998,'AJ',NULL)
259insert into placering values (1998,'DJ',NULL)
260insert into placering values (1998,'JS',NULL)
261insert into placering values (1998,'NBL',NULL)
262insert into placering values (1997,'BH',2)
263insert into placering values (1997,'LMI',22)
264insert into placering values (1997,'CMM',48)
265insert into placering values (1997,'BR',59)
266insert into placering values (1997,'SP',79)
267insert into placering values (1997,'BHS',82)
268insert into placering values (1997,'FH',83)
269insert into placering values (1997,'MK',NULL)
270insert into placering values (1997,'MS',NULL)
271insert into placering values (1997,'DJ',NULL)
272insert into placering values (1997,'MSJ',NULL)
273insert into placering values (1997,'NBL',NULL)
274insert into placering values (1996,'BR',10)
275insert into placering values (1996,'CMM',30)
276insert into placering values (1996,'PM',33)
277insert into placering values (1996,'BH',37)
278insert into placering values (1996,'JS',NULL)
279insert into placering values (1996,'BHS',NULL)
280insert into placering values (1996,'MB',NULL)
281insert into placering values (1996,'NBL',NULL)
282insert into placering values (1996,'MSO',NULL)
283insert into placering values (1996,'MK',NULL)
284insert into placering values (1996,'FH',NULL)
285insert into placering values (1996,'LMI',NULL)
286insert into placering values (1995,'RS',9)
287insert into placering values (1995,'MB',NULL)
288insert into placering values (1995,'BHS',NULL)
289insert into placering values (1995,'CMM',NULL)
290insert into placering values (1994,'RS',6)
291insert into placering values (1994,'BR',9)
292insert into placering values (1994,'BH',47)
293insert into placering values (1994,'JWE',NULL)
294insert into placering values (1994,'JMA',NULL)
295insert into placering values (1994,'PM',NULL)
296insert into placering values (1994,'BHS',NULL)
297insert into placering values (1994,'JS',NULL)
298insert into placering values (1994,'LMI',NULL)
299insert into placering values (1993,'BR',9)
300insert into placering values (1993,'RS',35) 
301insert into placering values (1993,'BH',18)
302insert into placering values (1993,'PM',36)
303insert into placering values (1993,'TB',61)
304insert into placering values (1993,'BHS',NULL)
305insert into placering values (1993,'JS',NULL)
306insert into placering values (1993,'KW',NULL)
307insert into placering values (1992,'TJ',NULL)
308insert into placering values (1992,'BHS',NULL)
309insert into placering values (1992,'JS',NULL)
310insert into placering values (1992,'JW',NULL)
311insert into placering values (1992,'BH',NULL)
312insert into placering values (1992,'TB',NULL)
313insert into placering values (1992,'RS',18)
314insert into placering values (1992,'JWE',27)
315insert into placering values (1992,'PP',55)
316insert into placering values (1992,'BR',59)
317insert into placering values (1992,'KA',78)
318insert into placering values (1992,'KW',89)
319insert into placering values (1991,'PM',NULL)
320insert into placering values (1991,'BHS',45)
321insert into placering values (1991,'JS',NULL)
322insert into placering values (1991,'JW',NULL)
323insert into placering values (1991,'BH',15)
324insert into placering values (1991,'JC',NULL)
325insert into placering values (1991,'RS',NULL)
326insert into placering values (1991,'JWE',49)
327insert into placering values (1991,'SL',NULL)
328insert into placering values (1991,'BR',6)
329insert into placering values (1991,'KA',38)
330insert into placering values (1991,'KW',NULL)
331insert into placering values (1990,'JS',NULL)
332insert into placering values (1990,'RS',NULL)
333insert into placering values (1990,'JWE',7)
334insert into placering values (1990,'AP',35)
335insert into placering values (1990,'KA',NULL)
336insert into placering values (1990,'KW',NULL)
337insert into placering values (1989,'PP',NULL)
338insert into placering values (1989,'BHS',NULL)
339insert into placering values (1989,'JS',NULL)
340insert into placering values (1989,'KE',NULL)
341insert into placering values (1989,'JØ',NULL)
342insert into placering values (1989,'JC',NULL)
343insert into placering values (1989,'RS',9)
344insert into placering values (1989,'JWE',38)
345insert into placering values (1989,'SL',NULL)
346insert into placering values (1989,'BR',NULL)
347insert into placering values (1989,'KA',NULL)
348insert into placering values (1989,'BB',NULL)
349insert into placering values (1988,'PP',NULL)
350insert into placering values (1988,'BHS',27)
351insert into placering values (1988,'JS',NULL)
352insert into placering values (1988,'KE',NULL)
353insert into placering values (1988,'JVP',NULL)
354insert into placering values (1988,'JW',NULL)
355insert into placering values (1988,'RS',17)
356insert into placering values (1988,'JWE',34)
357insert into placering values (1988,'SL',44)
358insert into placering values (1988,'AP',NULL)
359insert into placering values (1988,'JM',NULL)
360insert into placering values (1988,'JV',76)
361insert into placering values (1987,'PP',NULL)
362insert into placering values (1987,'BHS',NULL)
363insert into placering values (1987,'JS',NULL)
364insert into placering values (1987,'SMP',NULL)
365insert into placering values (1987,'JVP',NULL)
366insert into placering values (1987,'JW',NULL)
367insert into placering values (1987,'RS',8)
368insert into placering values (1987,'JWE',NULL)
369insert into placering values (1987,'SL',NULL)
370insert into placering values (1987,'KA',30)
371insert into placering values (1987,'JM',39)
372insert into placering values (1987,'JV',NULL)
373insert into placering values (1986,'JS',44)
374insert into placering values (1986,'JVP',NULL)
375insert into placering values (1986,'JW',8)
376insert into placering values (1986,'RS',27)
377insert into placering values (1986,'MM',NULL)
378insert into placering values (1986,'KE',NULL)
379insert into placering values (1986,'JM',38)
380insert into placering values (1986,'JV',NULL)
381insert into placering values (1985,'SMP',49)
382insert into placering values (1985,'JVP',51)
383insert into placering values (1985,'JW',43)
384insert into placering values (1985,'KA',14)
385insert into placering values (1985,'KE',NULL)
386insert into placering values (1985,'JM',23)
387insert into placering values (1985,'JV',55)
388insert into placering values (1984,'SMP',NULL)
389insert into placering values (1984,'PB',NULL)
390insert into placering values (1984,'JW',NULL)
391insert into placering values (1984,'KA',NULL)
392insert into placering values (1984,'JM',NULL)
393insert into placering values (1984,'JV',NULL)
394insert into placering values (1983,'PB',NULL)
395insert into placering values (1983,'JW',12)
396insert into placering values (1983,'KA',NULL)
397insert into placering values (1983,'JM',34)
398insert into placering values (1982,'PB',39)
399insert into placering values (1982,'JW',38)
400insert into placering values (1982,'KA',15)
401insert into placering values (1982,'JM',13)
402insert into placering values (1981,'PB',43)
403insert into placering values (1981,'FR',NULL)
404insert into placering values (1981,'JM',NULL)
405insert into placering values (1980,'PB',NULL)
406insert into placering values (1980,'KA',NULL)
407insert into placering values (1980,'JM',8)
408insert into placering values (1979,'PB',35)
409insert into placering values (1979,'FR',NULL)
410insert into placering values (1979,'JM',39)
411insert into placering values (1979,'FC',NULL)
412insert into placering values (1978,'PB',NULL)
413insert into placering values (1978,'FR',NULL)
414insert into placering values (1978,'JM',3)
415insert into placering values (1978,'FC',NULL)
416insert into placering values (1978,'NF',NULL)
417insert into placering values (1978,'GF',NULL)
418insert into placering values (1978,'KGS',NULL)
419insert into placering values (1977,'PB',NULL)
420insert into placering values (1977,'JM',27)
421insert into placering values (1977,'KR',NULL)
422insert into placering values (1977,'GF',NULL)
423insert into placering values (1976,'JM',17)
424insert into placering values (1975,'OR',NULL)
425insert into placering values (1974,'OR',NULL)
426insert into placering values (1973,'MF',NULL)
427insert into placering values (1973,'LM',17)
428insert into placering values (1973,'OR',13)
429insert into placering values (1972,'LM',7)
430insert into placering values (1972,'OR',NULL)
431insert into placering values (1971,'LM',6)
432insert into placering values (1971,'OR',9)
433insert into placering values (1970,'MF',NULL)
434insert into placering values (1970,'LM',2)
435insert into placering values (1970,'OR',40)
436insert into placering values (1968,'OR',NULL)
437insert into placering values (1967,'OR',43)
438go