dog

DELIMITER $$
CREATE PROCEDURE `sales_average`()
 SELECT Product.product_name, Product.Price, SUM(Quantity) as total_order , AVG(Quantity) as average_order FROM `orderdetails` JOIN Product on orderdetails.product = product.PID group by product$$
DELIMITER ;

DELIMITER $$
CREATE PROCEDURE `order_average`()
SELECT Product.product_name, Product.Price, SUM(Quantity) as total_order , AVG(Quantity) as average_order FROM `orderdetails` JOIN Product on orderdetails.product = product.PID group by product$$
DELIMITER ;