Mastering Active Record's SQL Logic and EXISTS Clause: A Workaround Using Includes

Finding an Associated Table: Oldest Record Filtering by One of Its Attributes

Mastering Union All: Combining Data from Multiple Tables with Active Record Relations in Rails