Domanda di colloquio di Rivian

Project you worked on? Explain the SQL you wrote. Rank vs dense rank