queries2.sql

来自「ssd7 ex3 答案」· SQL 代码 · 共 23 行

SELECT name,isbn,title4.callnumber
FROM title4,ordered4,purchase_order4
WHERE title4.callnumber=ordered4.callnumber AND
      ordered4.ponum=purchase_order4.ponum
GROUP BY title4.callnumber,title4.name,title4.isbn
HAVING COUNT (*)>1 AND SUM(purchase_order4.qty)>10
ORDER BY SUM(purchase_order4.qty) DESC;