BookStore数据库中有销售明细表OrderDetail(OrderCode, BookCode, Amount)
查询销售总量前20%的图书，并按总销量降序排列。SQL语句：
SELECT TOP 20 PERCENT Bookcode As 书号, SUM(Amount)As总销量
ROM OrderDetail
GROUP BY Bookcode
ORDER BY ________
查询销售总量前20%的图书，并按总销量降序排列。SQL语句：
SELECT TOP 20 PERCENT Bookcode As 书号, SUM(Amount)As总销量
ROM OrderDetail
GROUP BY Bookcode
ORDER BY ________
举一反三
- BookStore数据库中有销售明细表OrderDetail(OrderCode, BookCode, Amount) 在OrderDetail表中添加一条记录：“08110801”、0701、3。SQL语句：________ 。
- BookStore数据库中有销售明细表OrderDetail(OrderCode...701、3。SQL语句：________
- BookStore数据库中有销售明细表OrderDetail(OrderCode...kcodeORDERBY________
- BookStore数据库中有图书表 Book(BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, ContentInro, Price, Discount) 查询图书名称（BookName）含有“程序”的图书信息。SQL语句: SELECT BookCode,BookName,Author,Price,Discount FROM Book WHERE Name=“%程序%”
- BookStore数据库中有图书表Book(BookCode, BookName..._ BookSort FROM Book