Collection, set or list columns - What are the differences/similarities?

The nodes "GroupBy" and "Create Collection Column" deal with list, set and collection columns. Is there any simple explanation about differences and similarities of these column types?

a collection is the supertype. Hence set and list are both collections.

A List contains duplicate entries, as it saves all elements in the same order.

A Set doesn't contain duplicates.