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