分组求最大值，最小值 使用开窗函数经验总结

select distinct TT.prod_id, tt.creteTime, tt.inspection_time, tt.cnt

from (select s.prod_id,
min(s.datetime_created) over(partition by s.prod_id) as creteTime,
max(s.inspection_time) over(partition by s.prod_id) as inspection_time,

sum(s.complete_count) over(partition by s.prod_id) as cnt

FROM qms.oqc_inspection_sample s
WHERE length(s.prod_id) = 14 and s.prod_id like ‘6%‘
and s.inspection_result = ‘合格‘
and s.status in (‘已检验‘, ‘已生成报告‘)) tt