#查询出每个供应商提供的质量评分高于 80 且成本低于 50 的零部件名称、质量评分和成本
#查询出来的数据先按照供应商 ID 升序排列，再按照成本升序排列。
select a.supplier_id,supplier_name,component_name,quality_score,cost
from suppliers as a
inner join supply_quality_cost as b
on a.supplier_id = b.supplier_id
inner join components as c
on b.component_id = c.component_id
where quality_score > 80 and cost < 50
order by a.supplier_id,cost