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