I am currently interviewing junior engineers (recent graduates with little experience) and among them about 50% say, "oh, I know this has something to do with w

I am currently interviewing junior engineers (recent graduates with little experience) and among them about 50% say, "oh, I know this has something to do with window functions", but I usually warn them it can be solved without them. About two thirds of this group the solve it via a subquery vs about one third of the other group. Practically no one so junior can do it via a window function.