Skip to content

Minor issue with Correct Running Total Exercise #24

@dmcmurchy

Description

@dmcmurchy

First off - thank you very much for putting this together as I've found it very useful and informative on my SQL data analyst journey.

From: http://www.windowfunctions.com/questions/over/3
The question states to Order by: weight desc

If taken as the column weight; the results won't appear in the correct order in the output. Oscar and Smokey will swap positions as will the running_total_weight values 12.2 and 6.1 (in that order).

It becomes obvious after seeing the answer that the challenger should order by running_total_weight after the FROM.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions