Pergunta de entrevista da empresa Shiftkey

What “SQL construct would you use to solve this” —- this is NOT the right question they were asking about functions and more specifically window functions.