Suppose in a blog application there are authors and posts. A post belongs to an author, while author has many posts. The app needs to show a list of all the authors along with a number of posts that they have written. For this, we need to join author and posts table with "left outer join". More about "left outer join" here, here and here . In Rails 4.x, we need to write the SQL for left outer join
![Support for left outer join in Rails 5](https://cdn-ak-scissors.b.st-hatena.com/image/square/df7dcf3e382d2d4b018ba79fc6642260e3fa7070/height=288;version=1;width=512/https%3A%2F%2Fres.cloudinary.com%2Fdpc4i4bdx%2Fimage%2Fupload%2Fbigbinary_blogs%2Fdefault_blog_image.png)