【简答题】查询图书“神曲”的销售总量及销售总额。语句如下:SELECT BookName AS 书名, Sum(Amount) AS 销售总量, Sum(TotalPrice) AS 销售总额FROM Book JOIN OrderDetail ON Book.BookCode=OrderDetail.BookCode JOIN [Order] ON OrderDetail.OrderCode=[Order...
【多选题】BookStore 数据库关系图如下: 查询图书“神曲”的销售总量及销售总额。 SQL 语句: SELECT BookName As 书名 , SUM(Amount) As 销售总量 , SUM(TotalPrice) As 销售总额 FROM ________ 。
A.
Book JOIN OrderDetail ON Book.BookCode=OrderDetail.BookCode JOIN [Order] ON OrderDetail.OrderCode=[Order].OrderCode GROUP BY BookName HAVING BookName=' 神曲'
B.
Book JOIN OrderDetail JOIN [Order] ON OrderDetail.OrderCode=[Order].OrderCode ON Book.BookCode=OrderDetail.BookCode GROUP BY BookName HAVING BookName=' 神曲'
C.
Book ,OrderDetail,[Order] WHERE OrderDetail.OrderCode=[Order].OrderCode AND Book.BookCode=OrderDetail.BookCode GROUP BY BookName HAVING BookName=' 神曲'
D.
Book ,OrderDetail,[Order] ON OrderDetail.OrderCode=[Order].OrderCode AND Book.BookCode=OrderDetail.BookCode GROUP BY BookName HAVING BookName=' 神曲'