与Oracle上的INSERT INTO结合使用时，有效的GROUP BY查询不起作用

I'm trying to write an INSERT INTO that does a some DISTINCT/GROUP BY work. The query runs perfectly fine as a select statement, but will not work if it's wrapped into an INSERT INTO.I'm trying to write an INSERT INTO that does a