Anonymous
public text v1 · immutableselect avg(b.aantal_besteld * p.prijs_incl_btw) as gemiddelde
from product p, bestelling b
where datum_besteld between '01-JAN-2007' and '30-SEP-2007'
and
where p.product_id = b.product_id;select avg(b.aantal_besteld * p.prijs_incl_btw) as gemiddelde
from product p, bestelling b
where datum_besteld between '01-JAN-2007' and '30-SEP-2007'
and
where p.product_id = b.product_id;