title: What are some good examples where SQL's OUTER JOIN is used?
body: <p>I often get asked the questions in an interview that "what is an outer join in SQL"?</p>
  
  <p>While it can be answered, I wonder what might be some classic and good real life examples where a (LEFT) OUTER JOIN is used?</p>