Choose a season and see how many points the drivers would have scored with different regulations. (penalties are ignored in this comparison)
URL: http://f1-facts.com/statistics/regulations-comparison index: 2 selbst: Statistik/Reglement Header:
select max(f1_Reglement) from f1_Reglement where f1_Reglement <= 2013
Param: , Saison:2013
select max(f1_Reglement) from f1_Reglement where f1_Reglement <= ""
select f1_Person, upper(f1_Rennen.gpid) as id, tmp_team, f1_Rennen.f1_Rennen, wmpunkte, punkte, k from f1_Rennergebnis left join f1_Rennen using (f1_Rennen) where f1_Saison = 2013 order by f1_Rennen.f1_Rennen, k desc
select vorname, nachname, f1_Person.f1_Person, sum(wmpunkte) as summe, sum(k = 1) as 1p, sum(k = 2) as 2p, sum(k = 3) as 3p, sum(k = 4) as 4p, sum(k = 5) as 5p, sum(k = 6) as 6p, sum(k = 7) as 7p, sum(k = 8) as 8p, sum(k = 9) as 9p, sum(k = 10) as 10p, sum(k = 11) as 11p, sum(k = 12) as 12p from f1_Rennergebnis left join f1_Rennen using(f1_Rennen) left join f1_Person on f1_Person.f1_Person = f1_Rennergebnis.f1_Person where f1_Saison =2013 group by f1_Person.f1_Person order by summe desc, 1p desc, 2p desc, 3p desc, 4p desc, 5p desc, 6p desc, 7p desc, 8p desc, 9p desc, 10p desc, 11p desc, 12p desc