题解 | 评估不同供应商提供的零部件质量和成本情况
评估不同供应商提供的零部件质量和成本情况
https://www.nowcoder.com/practice/dc44fdd330e8429db8271efc38ce1922
select
s.supplier_id,
supplier_name,
component_name,
quality_score,
cost
from
supply_quality_cost s
left join components using(component_id)
left join suppliers using(supplier_id)
where quality_score>80 and cost<50
order by s.supplier_id, cost
网易游戏公司福利 297人发布