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