The Lemmy documentation explains the different sort options pretty well: https://join-lemmy.org/docs/users/03-votes-and-ranking.html

The difference between "Hot" and "Active" is probably the most confusing to most users.