题解 | 评估不同供应商提供的零部件质量和成本情况
评估不同供应商提供的零部件质量和成本情况
https://www.nowcoder.com/practice/dc44fdd330e8429db8271efc38ce1922
SELECT sq.`supplier_id`, `supplier_name`, `component_name`, `quality_score`, `cost` FROM supply_quality_cost sq JOIN suppliers s ON sq.`supplier_id`=s.`supplier_id` JOIN components c ON sq.`component_id`=c.`component_id` WHERE `quality_score`>80 AND `cost`<50 ORDER BY `supplier_id` ,`cost`;
