32. List all orders that are greater than the average of April 10, 1999.
select
*
from
orders
where
ammount > (
select
avg(ammount)
from
orders
where
odate = '10-04-1999'
group by
odate
);
Output:
