How to union two list fields in the same Database?

Can you provide some example use cases that need intersect or diff. It’s always interesting to hear what people want to achieve.