图书销售管理系统（SQL）课程设计

基于SQL的数据库课程设计 1.图书销售统计 Create View OrderStat as Select TOP 10 Book.ISBN , Lib.bName , Book.bClass , Book.bAuthor , Book.bPress , Lib.lNumber From Book,Lib Where Lib.bName=Book.bName Order by Lib.lNumber DESC 2.图书退货统计 Create view RefundStat as Select TOP 10 Book.ISBN,Lib.bName,Book.bClass,Book.bAuthor,Book.bPress,Refund.rNumber From Book,Lib,Refund Where Lib.bName=Book.bName and Refund.bName=Book.bName Order by Refund.rNumber DESC 3.图书体日销售量统计 Create view DayStat as select TOP 10 Orders.oDate as 日期 ,SUM(Orders.oNumber) as 数量 From Orders,Lib,Book Where Lib.bName=Book.bName and Orders.bName=Book.bName Group by Orders.oDate Order by Orders.oDate ASC 4.库存信息量 Create view LibStat as Select Book.ISBN,Lib.bName,Book.bClass,Book.bAuthor,Book.bPress,Lib.lNumber From Lib,Book Where Lib.bName=Book.bName