jz11 wrote: ↑15 Apr 2018, 14:05
any statistics out there with how many races Lewis won while qualifying let's say out of top3?
I'll be seriously disappointed if RIC doesn't get a championship contesting car in the near future...
Using the ergast db, from grid starts outside top 3:
q=paste0('SELECT COUNT(d.driverId) AS wins FROM drivers d JOIN results rs JOIN races r WHEre r.raceId=rs.raceId AND position=1 AND d.driverRef="hamilton" AND d.driverId=rs.driverId AND rs.grid>3 ')
> dbGetQuery(ergastdb, q)
wins
4
And from official qualifying out of top 3 (penalties may have meant time was actually in top 3...)
q=paste0('SELECT COUNT(d.driverId) AS wins FROM drivers d JOIN results rs JOIN races r JOIN qualifying q WHEre r.raceId=rs.raceId AND r.raceId=q.raceId AND rs.position=1 AND d.driverRef="hamilton" AND d.driverId=rs.driverId AND d.driverId=q.driverId AND q.position>3 ')
> dbGetQuery(ergastdb, q)
wins
4
I hope to start adding more things like that to trivia sections of f1dj reviews. Latest report for Chinese GP here:
https://chn2018gp.f1datajunkie.com/