typo in the title: "extenTions" --> "extenSions"

i so overthunk it. please god give me the strength to master 7 kyu's

Fixed.

Approved myself.

This was a horribly written question. Given there is no opportunity for follow on questions the question needs to be rewritten, especially as the SQL syntax to solve is not actually very complicated.

Additionally at least some sort of idea what the expected result set looks like on an apparently "simple" problem would be helpful as this is supposed to be about learning and practice.

0/10 would not recommend.

MAKISE KURISUU!!
You're supposed to be a scientist 😭

Lol i had pretty much a very lame solution too

If you replace names for all clans with [no clan specified] and return only one row it still passes.

sorry, didn't think it was a spoiler.

I figured out the requirement.

It basically means that the member has to have spent $1,000 in total, across departments that have have sales in excess of $10,000.

So, you should only include member sales in departments that have over $10,000 total.

It probably could have been worded better, trying to understand the requirement was 95% of the problem, the solution was quite simple :D

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.)

JS fork

• enabled node 18
• used mocha/chai assertions + lodash for randomness
• all cases are always tested in random tests
• provided input on failure

I just told you in the previous reply??

https://docs.codewars.com/training/troubleshooting/#print-input

the problem is, its random test the ome gets error and I can't see whats the msg is...

You can log the message to console with console.log(msg) to see which tests fail.

The problem is with your regex, but I don't blame you, because these "HTML tags" are not normal at all. (because of how random tests are constructed)