Selecting Unique Rows Based on Column by Least Group Count

Eager Loading with Foreign Keys: Populating Multiple Fields in a Single Query