题解 | 评估不同供应商提供的零部件质量和成本情况

select supply_quality_cost.supplier_id
, supplier_name
, component_name
, quality_score 
, cost 
from supply_quality_cost
left join suppliers on supply_quality_cost.supplier_id = suppliers.supplier_id
left join components on supply_quality_cost.component_id = components.component_id
where quality_score >80 and cost < 50
order by 1,4