-- -- Windows Function -- Aggregate 1 SELECT JMakecost, Gold, SUM(JMakecost) OVER( PARTITION BY Gold ORDER BY JMakecost ) AS "Total", AVG(JMakecost) OVER( PARTITION BY Gold ORDER BY JMakecost ) AS ...