难住了！Teradata SQL。如何从历史表中为每个随时间重复的组更改拉取最小/最大值？

SELECT group_id, time, MIN(value) OVER (PARTITION BY group_id, time) AS min_value
FROM history_table;

SELECT group_id, time, min_value
FROM (
  SELECT group_id, time, MIN(value) OVER (PARTITION BY group_id, time) AS min_value
  FROM history_table
) t
WHERE (group_id, time, min_value) IN (
  SELECT group_id, time, MIN(min_value)
  FROM (
    SELECT group_id, time, MIN(value) OVER (PARTITION BY group_id, time) AS min_value
    FROM history_table
  ) t
  GROUP BY group_id, time
);