Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Minor issue with Correct Running Total Exercise #24

Open
dmcmurchy opened this issue Apr 25, 2023 · 0 comments
Open

Minor issue with Correct Running Total Exercise #24

dmcmurchy opened this issue Apr 25, 2023 · 0 comments

Comments

@dmcmurchy
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant