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