Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
How do you return the whole table if there are no results for the
sale price > 98
condition, I have been looking at usingconditional 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 resultsI 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?