История изменений

Исправление theNamelessOne, 30.05.22 13:49 (текущая версия) :

select distinct on (user_group) *
  from user_groups_by_types
 order by user_group, change_date desc;

Исходная версия theNamelessOne, 30.05.22 13:48:

select distinct on (user_group) *
  from user_groups_by_types
 order by location, change_date desc;