diff options
Diffstat (limited to 'views')
| -rw-r--r-- | views/career_length.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/views/career_length.sql b/views/career_length.sql new file mode 100644 index 0000000..e950f32 --- /dev/null +++ b/views/career_length.sql @@ -0,0 +1,10 @@ +CREATE VIEW career_length AS + SELECT drivers.driverId, + COUNT(DISTINCT(results.raceId)) AS career_races, + DATEDIFF(MAX(races.date), MIN(races.date)) + 1 AS career_days, + DATEDIFF(MIN(races.date), drivers.dob) AS first_race_age, + DATEDIFF(MAX(races.date), drivers.dob) AS last_race_age + FROM results + JOIN races ON races.raceId = results.raceId + JOIN drivers ON drivers.driverId = results.driverId + GROUP BY results.driverId; |