Idea Summary
Why we still need group by clause for summary level information? And sql errors can suggest corrected sql.

Use Case
Select dept_no,dept_id, sum(salary),avg(commission) from dept_sales group by dept_no,dept_id;

Preferred Solution (Optional)
Select dept_no,dept_id, sum(salary),avg(commission) /* hint groupby */ from dept_sales ;

before execution query can be modified add group by clause excluding summary columns  .