I already did this but i got stucked in the middle
please help

SELECT
    o.orderid, 
    AVG(d.qty * d.unitprice) AS avgunitpriceperorder,
    SUM(d.qty * d.unitprice * (1-discount)) AS totalordeamountperorder