SQL tricky Complex Query | (Reset Running Total When negative) / (Reset based on column value)

[@DarrenBroadhead]

This is amazing!! You are a star. Thank you.

[@LearnatKnowstar]

Thank you

[@hbautomation-io]

Thank you SO much. Searched the entire internet for this solution..

[@LearnatKnowstar]

Glad it was helpful

[@designanddecor8964]

These scenarios are very helpful in real life computations. Please share more such scenarios.

[@LearnatKnowstar]

Thank you

[@fatorx495]

wowwww, i love you! I'm from Brazil and i didn't sleep trying to do this!!! THANK YOU!!!!!!!

[@LearnatKnowstar]

Thank you so much for your kind words.

[@kristyowens2284]

This is a nice complex scenario. Thanks for sharing.

[@LearnatKnowstar]

Thank you

[@RanjayKumarSingh-x8l]

Your video is super ... I am struggling since 10 days for this concept but you solved it

[@LearnatKnowstar]

Glad it was helpful.

[@fatorx495]

thank you

[@LearnatKnowstar]

Thank you for your support

[@sravankumar1767]

Nice explanation 👌 👍 👏

[@LearnatKnowstar]

🙏

[@ganeshreddymotakatla6244]

Super explanation...

[@LearnatKnowstar]

Glad it was helpful 🙏

[@harshalpatel3012]

Nice explantion

[@LearnatKnowstar]

Thank You

[@hv0032113]

Very good topic. Thanks.

[@LearnatKnowstar]

🙏

[@riddlex]

I was asked a question where I have to show only those product_id, product_name where there a constant growth in sales_amount each year. If there is a decline in sales in any year, it shouldn't be included in the output. Let's say the data is from 2011 to 2021. Need to know the approach for this question.

[@LearnatKnowstar]

You can first calculate the YoY growth for each product in a CTE. Then you can filter on products for which there is a negative growth in any of the years. In the last step, Select all products where product NOT IN ( the products returned in the negative growth scenario)

[@tusharkumbhar5051]

Can you please help me