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