*HARD* Microsoft SQL Interview Question for Data Scientists and Data Analysts (StrataScratch 10300)

[@ZzZzZiggy]

I've watched so many of your videos these past few days that I now see you as a sort of flatmate. 😄 Aaaanyway, thank you for these. Biggst thing I've probably picked up? Use HAVING more. I tend to go for CTE's for some reason but your way seems a lot more efficient. Thanks again!

[@frederikmuller]

using HAVING just feels so clean 👌 have a nice day, flatmate ✌️

[@ayeoh47]

Great video. Such a clear explanation and efficient code. My mind went to subquery but forgot having was a better choice

[@frederikmuller]

Thank you. I just always think about using having when I see that I need to filter on an aggregate function value. I guess you just need to condition your mind to do the same.

[@sumeetpatil4785]

Hi...im really struggling with 'retention rate' in stratascratch SQL..please help..!!