Strange, it's one of the first questions I'd ask anyone during an interview, from analysts, to data scientists and even data engineers. Usually, something like,

Strange, it's one of the first questions I'd ask anyone during an interview, from analysts, to data scientists and even data engineers. Usually, something like, "describe what a SQL window function does, and provide an example of its usage".