CODE EXAMPLE FOR SQL

postgres first_value in gropby

try using "DISTINCT" instead of "GROUP BY", then use the "PARTITION BY"
clause inside the first_value.