I suspect there's a need to keep the design simple, but the source table schema should probably be more prominent. I suspect most people try to guess the names

I suspect there's a need to keep the design simple, but the source table schema should probably be more prominent. I suspect most people try to guess the names of the columns before they ever click "Show table schema". Nice quiz, by the way, and I like the topic. In my experience, too few devs / dbas make good use of window functions.