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