select
    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 asc,
    cost asc;