select 
    s1.supplier_id,
    supplier_name,
    component_name,
    quality_score,
    cost
from supply_quality_cost s1
join components c using(component_id)
join suppliers s2 using(supplier_id)
where quality_score>80 and cost<50
order by s1.supplier_id,cost;