查询使用零件数量最多的项目编号和零件数。
SELECT MAX(a.JNO) AS JNO,MAX(total_qty) FROM (SELECT JNO, SUM(QTY) AS total_qty FROM SPJ GROUP BY JNO) as a ;
查询每个城市供应的零件总数。
SELECT CITY,SUM(QTY) FROM SPJ,S WHERE SPJ.SNO IN (SELECT GROUP_CONCAT(SNO) AS SNO_List FROM S GROUP BY CITY) GROUP by CITY;