Rivian Interview Question

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