题解 | 评估不同供应商提供的零部件质量和成本情况

SELECT
    s.supplier_id,
    s.supplier_name,
    c.component_name,
    sq.quality_score,
    sq.cost
FROM
    suppliers AS s
    INNER JOIN
    supply_quality_cost AS sq ON s.supplier_id=sq.supplier_id
    INNER JOIN
    components AS c ON sq.component_id=c.component_id
WHERE
    sq.quality_score>80 AND sq.cost<50
ORDER BY
    s.supplier_id,
    sq.cost;