disregard my earlier question

can you do an update statement inside that cte?

This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial transactions. This is not a very complicated challenge and there are different ways to solve this. The key here is to see som

Is it already too late to submit to this challenge? If not, i have one question pertaining column value. For missing and unknown columns: if there is no value, is null acceptable? I'm using stuff xml path. Appreciate some reply here. Thanks much.

Ok, thanks for the reply dishy. To recap, i don't have to worry about changing it to lower or upper. Got it.

Got a question, in regards to this statement: Colors will appear case-insensitive, i.e. if you have 'Orange' you will not have 'ORANGE' or 'orange' or any other variant in the data. Is it matter if the color text change to all lower case or all upper cas