Examples of real usage of outer joins?

This is more of a general database question, not specific to Java, but
can someone describe an actual realistic use of outer joins? I'm
familiar with how it works, and some trivial examples, but I'm frankly
unsure of why you'd actually need to use it.

.