with t1 as 
(
    select
        supplier_id
        ,component_id
        ,quality_score
        ,cost
    from supply_quality_cost
    where quality_score > 80
    and cost < 50
)
select
     t1.supplier_id
     ,supplier_name
    ,component_name
    ,quality_score
    ,cost
from t1
join suppliers s on t1.supplier_id = s.supplier_id
join components c on t1.component_id = c.component_id
order by 1,5