Pergunta de entrevista da empresa RampUp

SQL joints windows function and asked me to write some queries based on scenarios