题解 | 评估不同供应商提供的零部件质量和成本情况
评估不同供应商提供的零部件质量和成本情况
https://www.nowcoder.com/practice/dc44fdd330e8429db8271efc38ce1922
select s.supplier_id, supplier_name, component_name, quality_score, cost from supply_quality_cost sqc join suppliers s using (supplier_id) join components c using (component_id) where quality_score>80 and cost<50 order by s.supplier_id, cost
查看19道真题和解析