力扣SQL50 平均售价 ifnull SUM 连表查询
Problem: 1251. 平均售价
👨🏫 参考题解(题目数据增强,代码只能过90%的点)
🍻 AC code
SELECT p.product_id, ROUND(ifnull(SUM(units * price) / SUM(units), 0),2) AS average_price FROM prices as p LEFT JOIN unitsSold as u ON p.product_id = u.product_id WHERE u.purchase_date BETWEEN p.start_date AND p.end_date or u.product_id is null GROUP BY p.product_id
文章版权声明:除非注明,否则均为主机测评原创文章,转载或复制请以超链接形式并注明出处。