基本上我想运行以下查询：
INSERT INTO historical_car_stats (historical_car_stats_id,year,month,make,model,region,avg_msrp,count)
SELECT
my_seq.nextval,'2010','12','ALL',sum(avg_msrp * count) / sum(count),sum(count)
FROM historical_car_stats
WHERE year = '2010'
AND month = '12'
AND make != 'ALL'
GROUP BY region;
假设您要在按序列生成密钥之前对数据进行分组，那么就像您想要的那样
INSERT INTO HISTORICAL_CAR_STATS (
HISTORICAL_CAR_STATS_ID,YEAR,MONTH,MAKE,MODEL,REGION,AVG_MSRP,CNT)
SELECT MY_SEQ.nextval,cnt
FROM (SELECT '2010' year,'12' month,'ALL' make,'ALL' model,sum(AVG_MSRP*COUNT)/sum(COUNT) avg_msrp,sum(cnt) cnt
FROM HISTORICAL_CAR_STATS
WHERE YEAR = '2010'
AND MONTH = '12'
AND MAKE != 'ALL'
GROUP BY REGION)
