Additional aggregation cols produce exception

[jpullokkaran]

select o_orderstatus as x, cast(o_orderdate as date) as y, count(*) as z
from orderLineItemPartSupplierBase
where o_orderdate <= '1993-06-30'
group by o_orderstatus, cast(o_orderdate as date)
order by x, y, z