diff options
author | emkael <emkael@tlen.pl> | 2015-02-19 09:18:35 +0100 |
---|---|---|
committer | emkael <emkael@tlen.pl> | 2015-02-19 09:18:35 +0100 |
commit | da8c51b97eeb4a011646d470c3797a608782d512 (patch) | |
tree | 434dbcea39c53a2ea42a4cf75ddaad136b72ffad /views/full_season_drivers.sql | |
parent | 383dcafe64d92b04ffe7a6739559f0928ab206df (diff) |
* forcing view recreation
Diffstat (limited to 'views/full_season_drivers.sql')
-rw-r--r-- | views/full_season_drivers.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/views/full_season_drivers.sql b/views/full_season_drivers.sql index ae36cc8..0ad0bbd 100644 --- a/views/full_season_drivers.sql +++ b/views/full_season_drivers.sql @@ -1,11 +1,13 @@ -- view holds distinct driver-race entries -- (eliminating duplicate race entries from shared drives) +DROP VIEW IF EXISTS driver_races; CREATE VIEW driver_races AS SELECT driverId, raceId FROM results GROUP BY driverId, raceId; -- view aggregates races by season for each driver +DROP VIEW IF EXISTS driver_season_races; CREATE VIEW driver_season_races AS SELECT driver_races.driverId, races.year, GROUP_CONCAT(driver_races.raceId @@ -16,12 +18,14 @@ CREATE VIEW driver_season_races AS GROUP BY driver_races.driverId, races.year; -- view aggregates races by season +DROP VIEW IF EXISTS season_races; CREATE VIEW season_races AS SELECT year, GROUP_CONCAT(raceId ORDER BY raceId ASC) AS races FROM races GROUP BY year; -- selecting only driver-season pairs with all races in a season +DROP VIEW IF EXISTS full_season_drivers; CREATE VIEW full_season_drivers AS SELECT driver_season_races.driverId, driver_season_races.year FROM season_races |