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