Whenever you're ready, walk me through how you'd approach this.
What are the different types of joins?
Explain how the major join types combine rows, how unmatched rows are handled, and when each type is appropriate. Include concise PostgreSQL examples and distinguish standard joins from commonly used join patterns.