Hi, you can find more information about the purpose of the suggestion flag over there : suggestion .

Your last return isn't where it should be. (And please say the language you use next time you ask for help.)

You should probably study data structures and algorithms, and a bit of mathematics (especially number theory, codewars' authors love number theory ^^).

This might help you:

members who have spent over $1000 in department_s_ that have brought in more than $10000 total ordered by the members id

(And please flag your comment as a spoiler next time you post not trivial code.)

Thanks!

approved and improved ;)

The suggestion flag is intended to be used when someone proposes an improvement of the kata's description, or has made a fork to fix a bug, or wants a review of a translation in a new language, etc.

thank you for your kind words!

I was in favour of 5 kyu when we discussed the ranking of this kata on discord. I will certainly discard the outliers next time.

Thanks for all your SQL katas, they are really useful exercises.

Came up with the technical task first, then created a story to fit it.

Nice kata. Where does the idea of the lore come from ?

thanks, something along those lines worked

try:
    from solution import NHI
except:
    from solution import nhi
    nhi = NHI

There could be a better way to do it but that works with the current tests.