select supplier_id,supplier_name,component_name,quality_score,cost
from supply_quality_cost
join components using(component_id)
join suppliers using(supplier_id)
where quality_score>80 and cost<50
order by supplier_id asc ,cost asc