ORA-00979: not a GROUP BY expression

create table tq84_00979 (
    val    number,
    grp_1  varchar2(10),
    grp_2  varchar2(10),
    col    date
);

--
--  Cause ORA-00979
-- (column grp_2 is selected but
--  not part of the group by
--  expression)
--
select
   max(val),
   grp_1,
   grp_2
from
   tq84_00979
group by
   grp_1;

--
-- This one is OK
--
select
   max(val),
   grp_1,
   grp_2
from
   tq84_00979
group by
   grp_1,
   grp_2;

--
-- This one also causes an ORA-00979 because
-- of the col expression in the order by clause
--
select
   max(val),
   grp_1,
   grp_2
from
   tq84_00979
group by
   grp_1,
   grp_2
order by
   col;

drop table tq84_00979;