-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathhw2.sql
More file actions
87 lines (81 loc) · 6.31 KB
/
hw2.sql
File metadata and controls
87 lines (81 loc) · 6.31 KB
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
INSERT INTO Constructors VALUES('McLaren','British','Mercedes','884','95','180');
INSERT INTO Constructors VALUES('BMW Sauber', 'German','BMW','70','95','180');
INSERT INTO Constructors VALUES('Renault','French','Renault','660','91','175');
INSERT INTO Constructors VALUES('Ferrari','Italian','Ferrari','1010', '93', '180');
INSERT INTO Constructors VALUES('Toyota', 'Japanese','Toyota','1140', '91','175');
INSERT INTO Constructors VALUES('Red Bull', 'Austrian', 'Honda', '304', '91', '175');
INSERT INTO Constructors VALUES('Honda', 'Japanese', 'Honda', '88', '91', '175');
INSERT INTO Constructors VALUES('Toro Rosso', 'Italian', 'Ferrari', '268', '93', '180');
INSERT INTO Constructors VALUES('Jaguar', 'British', 'Cosworth', '85', '93', '178');
SELECT * FROM Constructors;
INSERT INTO Drivers VALUES('hamilton', str_to_date('07/01/1985', '%d/%m/%Y'), 'British', 'McLaren');
INSERT INTO Drivers VALUES('heidfeld', str_to_date('10/05/1977', '%d/%m/%Y'), 'German', 'BMW Sauber');
INSERT INTO Drivers VALUES('alonso', str_to_date('29/07/1981', '%d/%m/%Y'), 'Spanish', 'Renault');
INSERT INTO Drivers VALUES('raikkonen', str_to_date('17/10/1979', '%d/%m/%Y'), 'Finnish', 'Ferrari');
INSERT INTO Drivers VALUES('kubica', str_to_date('07/12/1984', '%d/%m/%Y'), 'Polish', 'BMW Sauber');
INSERT INTO Drivers VALUES('massa', str_to_date('25/04/1981', '%d/%m/%Y'), 'Brazilian', 'Ferrari');
INSERT INTO Drivers VALUES('trulli', str_to_date('13/07/1974', '%d/%m/%Y'), 'Italian', 'Toyota');
INSERT INTO Drivers VALUES('webber', str_to_date('27/08/1976', '%d/%m/%Y'), 'Australian', 'Red Bull');
INSERT INTO Drivers VALUES('button', str_to_date('19/01/1980', '%d/%m/%Y'), 'British', 'Honda');
INSERT INTO Drivers VALUES('vettel', str_to_date('03/07/1987', '%d/%m/%Y'), 'German', 'Toro Rosso');
INSERT INTO Drivers VALUES('barrichello', str_to_date('23/05/1972', '%d/%m/%Y'), 'Brazilian', 'Honda');
INSERT INTO Drivers VALUES('Irvine', str_to_date('10/11/1965', '%d/%m/%Y'), 'British', 'Jaguar');
INSERT INTO Drivers VALUES('Schmacher', str_to_date('03/01/1969', '%d/%m/%Y'), 'German', 'Ferrari');
SELECT * FROM Drivers;
INSERT INTO Races VALUES('Australian Grand Prix','2009-03-29', 'Australia');
INSERT INTO Races VALUES('British Grand Prix','2009-06-21','Europe');
INSERT INTO Races VALUES('German Grand Prix','2009-07-12', 'Europe');
INSERT INTO Races VALUES('European Grand Prix','2009-08-23', 'Europe');
INSERT INTO Races VALUES('Abu Dhabi Grand Prix','2009-11-01', 'Middle East');
INSERT INTO Races VALUES('Malaysian Grand Prix','2008-03-23', 'Asia');
INSERT INTO Races VALUES('Spanish Grand Prix','2008-04-27', 'Europe');
INSERT INTO Races VALUES('Singapore Grand Prix','2008-09-28', 'Asia');
INSERT INTO Races VALUES('Brazilian Grand Prix','2008-11-02', 'South America');
INSERT INTO Races VALUES('Monaco Grand Prix','2007-05-27', 'Africa');
INSERT INTO Races VALUES('Canadian Grand Prix','2007-06-10', 'North America');
INSERT INTO Races VALUES('United States Grand Prix','2007-06-17', 'North America');
INSERT INTO Races VALUES('French Grand Prix','2007-07-01', 'Europe');
INSERT INTO Races VALUES('Italian Grand Prix','2007-09-09', 'Europe');
INSERT INTO Races VALUES('San Marino Grand Prix','2004-04-25', 'Europe');
SELECT * FROM Races;
INSERT INTO Results VALUES('Australian Grand Prix', 'trulli', 'first place');
INSERT INTO Results VALUES('Australian Grand Prix', 'barrichello', 'second place');
INSERT INTO Results VALUES('Australian Grand Prix', 'button', 'third place');
INSERT INTO Results VALUES('British Grand Prix', 'button', 'first place');
INSERT INTO Results VALUES('British Grand Prix', 'barrichello', 'second place');
INSERT INTO Results VALUES('British Grand Prix', 'vettel', 'third place');
INSERT INTO Results VALUES('German Grand Prix', 'button', 'first place');
INSERT INTO Results VALUES('German Grand Prix', 'vettel', 'second place');
INSERT INTO Results VALUES('German Grand Prix', 'webber', 'third place');
INSERT INTO Results VALUES('European Grand Prix', 'button', 'first place');
INSERT INTO Results VALUES('European Grand Prix', 'barrichello', 'second place');
INSERT INTO Results VALUES('European Grand Prix', 'webber', 'third place');
INSERT INTO Results VALUES('Abu Dhabi Grand Prix', 'button', 'first place');
INSERT INTO Results VALUES('Abu Dhabi Grand Prix', 'vettel', 'second place');
INSERT INTO Results VALUES('Abu Dhabi Grand Prix', 'barrichello', 'third place');
INSERT INTO Results VALUES('Malaysian Grand Prix', 'hamilton', 'first place');
INSERT INTO Results VALUES('Malaysian Grand Prix', 'heidfeld', 'second place');
INSERT INTO Results VALUES('Malaysian Grand Prix', 'raikkonen', 'third place');
INSERT INTO Results VALUES('Spanish Grand Prix', 'hamilton', 'second place');
INSERT INTO Results VALUES('Singapore Grand Prix', 'hamilton', 'first place');
INSERT INTO Results VALUES('Singapore Grand Prix', 'massa', 'second place');
INSERT INTO Results VALUES('Singapore Grand Prix', 'kubica', 'third place');
INSERT INTO Results VALUES('Brazilian Grand Prix', 'hamilton', 'first place');
INSERT INTO Results VALUES('Brazilian Grand Prix', 'massa', 'second place');
INSERT INTO Results VALUES('Monaco Grand Prix', 'alonso', 'first place');
INSERT INTO Results VALUES('Monaco Grand Prix', 'hamilton', 'second place');
INSERT INTO Results VALUES('Monaco Grand Prix', 'massa', 'third place');
INSERT INTO Results VALUES('Canadian Grand Prix', 'hamilton', 'first place');
INSERT INTO Results VALUES('Canadian Grand Prix', 'alonso', 'second place');
INSERT INTO Results VALUES('Canadian Grand Prix', 'massa', 'third place');
INSERT INTO Results VALUES('United States Grand Prix', 'hamilton', 'first place');
INSERT INTO Results VALUES('United States Grand Prix', 'alonso', 'second place');
INSERT INTO Results VALUES('United States Grand Prix', 'massa', 'third place');
INSERT INTO Results VALUES('French Grand Prix', 'hamilton', 'first place');
INSERT INTO Results VALUES('French Grand Prix', 'alonso', 'second place');
INSERT INTO Results VALUES('French Grand Prix', 'massa', 'third place');
INSERT INTO Results VALUES('Italian Grand Prix', 'hamilton', 'first place');
INSERT INTO Results VALUES('Italian Grand Prix', 'alonso', 'second place');
INSERT INTO Results VALUES('San Marino Grand Prix', 'Schmacher', 'first place');
INSERT INTO Results VALUES('San Marino Grand Prix', 'barrichello', 'second place');
SELECT * FROM Results;