SELECT p.product_name, AVG(o.quantity) AS average_quantity FROM orders o JOIN products p ON o.product_id = p.product_id WHERE DATEDIFF(CURRENT_DATE, o.order_date) <= 30 GROUP BY p.product_name;
点赞 1

相关推荐

牛客网
牛客企业服务