Rivian interview question

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