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