题解 | 评估不同供应商提供的零部件质量和成本情况
评估不同供应商提供的零部件质量和成本情况
https://www.nowcoder.com/practice/dc44fdd330e8429db8271efc38ce1922
select s1.supplier_id,supplier_name,component_name,quality_score,cost from suppliers s1 join supply_quality_cost s2 on s1.supplier_id = s2.supplier_id join components c on s2.component_id = c.component_id where quality_score > 80 and cost < 50 order by supplier_id,cost

查看28道真题和解析