SELECT a.supplier_id,b.supplier_name,c.component_name,a.quality_score,a.cost
FROM supply_quality_cost AS a
JOIN suppliers AS b ON a.supplier_id = b.supplier_id
JOIN components AS c ON a.component_id = c.component_ID
WHERE a.quality_score > 80 AND a.cost < 50
ORDER BY a.supplier_id ASC,a.cost ASC

此题ez，使用JOIN进行表的连接然后用WHERE语句筛选出来符合条件的，最后ORDER BY 就ok了