I have seen quite a few lectures on window functions + aggregate functions, but this is the first time I have seen such an easy-to-understand lecture! I will take the subquery lecture thoroughly so that I can apply it freely in my work. Thank you so much for providing such a high-quality lecture at a low price!