From 55f10a6e7cead3513600569fb418d571ae88ba57 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Thu, 19 Feb 2015 09:19:08 +0100
Subject:  * new lines converted

---
 views/podiums.sql | 82 +++++++++++++++++++++++++++----------------------------
 1 file changed, 41 insertions(+), 41 deletions(-)

diff --git a/views/podiums.sql b/views/podiums.sql
index f9576f4..ec0bf63 100644
--- a/views/podiums.sql
+++ b/views/podiums.sql
@@ -1,41 +1,41 @@
--- podium for each race, in order of finishing position
-DROP VIEW IF EXISTS podium_sequences;
-CREATE VIEW podium_sequences AS
-   SELECT races.*,
-      GROUP_CONCAT(CONCAT(drivers.forename, " ", drivers.surname)
-         ORDER BY results.position ASC, results.driverId ASC)
-      AS podium
-   FROM results
-   JOIN races ON results.raceId = races.raceId
-   JOIN drivers ON results.driverId = drivers.driverId
-   WHERE results.position IN (1,2,3)
-   GROUP BY results.raceId;
-
--- podium for each race, in alphabetical order
-DROP VIEW IF EXISTS podium_sets;
-CREATE VIEW podium_sets AS
-   SELECT races.*,
-      GROUP_CONCAT(CONCAT(drivers.forename, " ", drivers.surname)
-         ORDER BY drivers.surname ASC, drivers.forename ASC,
-            drivers.driverRef ASC)
-      AS podium
-   FROM results
-   JOIN races ON results.raceId = races.raceId
-   JOIN drivers ON results.driverId = drivers.driverId
-   WHERE results.position IN (1,2,3)
-   GROUP BY results.raceId;
-
--- races in which the entire podium consisted of driver of nationality
--- yet to produce a drivers' world champion
-DROP VIEW IF EXISTS non_champion_nationality_podiums;
-CREATE VIEW non_champion_nationality_podiums AS
-   SELECT raceId, year, name, podium FROM podium_sequences
-   WHERE raceId NOT IN (
-      SELECT results.raceId FROM results
-         JOIN drivers ON drivers.driverId = results.driverId
-         JOIN races ON races.raceId = results.raceId
-         WHERE drivers.nationality IN (
-            SELECT nationality FROM world_drivers_champions
-            WHERE year < races.year
-         ) AND position IN (1,2,3)
-   );
+-- podium for each race, in order of finishing position
+DROP VIEW IF EXISTS podium_sequences;
+CREATE VIEW podium_sequences AS
+   SELECT races.*,
+      GROUP_CONCAT(CONCAT(drivers.forename, " ", drivers.surname)
+         ORDER BY results.position ASC, results.driverId ASC)
+      AS podium
+   FROM results
+   JOIN races ON results.raceId = races.raceId
+   JOIN drivers ON results.driverId = drivers.driverId
+   WHERE results.position IN (1,2,3)
+   GROUP BY results.raceId;
+
+-- podium for each race, in alphabetical order
+DROP VIEW IF EXISTS podium_sets;
+CREATE VIEW podium_sets AS
+   SELECT races.*,
+      GROUP_CONCAT(CONCAT(drivers.forename, " ", drivers.surname)
+         ORDER BY drivers.surname ASC, drivers.forename ASC,
+            drivers.driverRef ASC)
+      AS podium
+   FROM results
+   JOIN races ON results.raceId = races.raceId
+   JOIN drivers ON results.driverId = drivers.driverId
+   WHERE results.position IN (1,2,3)
+   GROUP BY results.raceId;
+
+-- races in which the entire podium consisted of driver of nationality
+-- yet to produce a drivers' world champion
+DROP VIEW IF EXISTS non_champion_nationality_podiums;
+CREATE VIEW non_champion_nationality_podiums AS
+   SELECT raceId, year, name, podium FROM podium_sequences
+   WHERE raceId NOT IN (
+      SELECT results.raceId FROM results
+         JOIN drivers ON drivers.driverId = results.driverId
+         JOIN races ON races.raceId = results.raceId
+         WHERE drivers.nationality IN (
+            SELECT nationality FROM world_drivers_champions
+            WHERE year < races.year
+         ) AND position IN (1,2,3)
+   );
-- 
cgit v1.2.3