79524781

Date: 2025-03-21 07:32:39
Score: 1
Natty:
Report link

If I were you, I would try using the MAX() window function for the size attribute.

SELECT state
      ,COUNT(DISTINCT(file))
      ,MAX(size) OVER(PARTITION BY state, file) AS size
 FROM mytable
GROUP BY state
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Дмитрий Песков