Question d’entretien chez Amazon

Difference between rank and dense rank. How to represent data using different graphs, which graphs to use when. basic questions about joins