- 搜标题
- 搜题干
- 搜选项
问答题
查询图书“神曲”的销售总量及销售总额。语句如下：
查询图书“神曲”的销售总量及销售总额。语句如下：
SELECT BookName AS 书名, Sum(Amount) AS 销售总量, Sum(TotalPrice) AS 销售总额
FROM Book JOIN OrderDetail ON Book.BookCode=OrderDetail.BookCode
JOIN [Order] ON OrderDetail.OrderCode=[Order].OrderCode
GROUP BY BookName
HAVING _________
答案：
BookName='神曲'或BookName = '神曲'或bookname='神曲'或BOOKNAME='神曲'
