超过5本.sql

1.写出建立BORROW表的SQL语句

 SELECT BORROW.CNO,QUANTITY FROM BOOKS,BORROW
 WHERE BOOKS.BNO=BORROW.BNO AND BORROW.CNO IN
(SELECT DISTINCT CNO FROM BORROW
 GROUP BY CNO
 HAVING COUNT(*)>5)