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