Postgres: Selecting Distinct On A Column Is Not Returning Distinct Results With Joins

I'm building a system in which there are the following tables: Song Broadcast Station Follow User A user follows stations, which have songs on them through broadcasts. I'm buildi

Solution 1:

Remove "broadcasts"."created_at" from the DISTINCT predicate because it is returning non-unique values, hence duplicate songs. If you need to use this information to sort please create a new question.