基于SQL的数据库课程设计1.图书销售统计CreateViewOrderStatasSelectTOP10Book.ISBN,Lib.bName,Book.bClass,Book.bAuthor,Book.bPress,Lib.lNumberFromBook,LibWhereLib.bName=Book.bNameOrderbyLib.lNumberDESC2.图书退货统计CreateviewRefundStatasSelectTOP10Book.ISBN,Lib.bName,Book.bClass,Book.bAuthor,Book.bPress,Refund.rNumberFrom