How do you return the whole table if there are no results for the sale price > 98 condition, I have been looking at using conditional unions eg. link etc. but can't understand a) why you would ever want to do this i.e. return the whole table when the result of the query is empty, and b) why it isn't working - since the feedback from the test-cases doesn't allow you to see all the output only the programmers predefined test results

I am referring to the NOTE: sometimes a department will not not contain a sale over $98 so just resubmit - what does resubmit mean in this case, I assumed it meant return the whole table instead if its empty after the >98 condition?

The wording, instruction, and test-support unfortunately make it very hard to understand what this question is about, and make what is intended to be learnt by it unclear too - this does not lead you on a rabbit hole of complicated ways to do things - but maybe I have missed the point, hard to say when not much was explained

Thank-you for contributing the kata, perhaps it could be tweaked with improvements by the community - or is only the original poster allowed to do that?