Camping World Interview Question

SQL: explain joins, rank vs dense rank