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!
@frederikmuller8 ай бұрын
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.
@sumeetpatil47859 ай бұрын
Hi...im really struggling with 'retention rate' in stratascratch SQL..please help..!!