Feedback

If you have any comments, suggestions or feature requests please add them here. Problems and errata can be reported on Bug Reports page.

254 Responses to “Feedback”

  1. Miguel Bento says:

    I think the second update statement was truncated. Here goes both statements again:

    update results
    set (fastestLap,fastestLapTime) = (select lap, time from (select l.lap, l.time, min(l.milliseconds) from laptimes l where l.raceId=results.raceId and l.driverId=results.driverId))
    where raceId in (select raceId from races where year between 1996 and 2003);

    update results
    set rank=(select count(*)+1 from results r where r.raceId = results.raceId and r.fastestLapTime 0 and raceId in (select raceId from races where year between 1996 and 2003);

  2. Miguel Bento says:

    Harrrg, it’s the ‘less than’ and ‘greater than’ signs!

    Let’s try again the 2 statements:

    update results
    set (fastestLap,fastestLapTime) = (select lap, time from (select l.lap, l.time, min(l.milliseconds) from laptimes l where l.raceId=results.raceId and l.driverId=results.driverId))
    where raceId in (select raceId from races where year between 1996 and 2003);

    update results
    set rank=(select count(*)+1 from results r where r.raceId = results.raceId and r.fastestLapTime < results.fastestLapTime)
    where laps > 0 and raceId in (select raceId from races where year between 1996 and 2003);

  3. Admin says:

    Hi Miguel,
    Many thanks. I may try this offline initially.
    Chris

  4. Daniel Johnson says:

    Hi Chris,

    Just wanted to drop you a line to say hi and to let you know I’m working on a React frontend for the API as a portfolio project. I’ll be getting docker going and putting the API on my local, but in case you were wondering about the increased requests that’s me. Feel free to email me with any questions/concerns, thanks!

    Best,
    Dan

Add a Comment: