BookStore数据库中有图书表Book(BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, ContentInro, P 点我阅读全文
BookStore数据库中有销售明细表OrderDetail(OrderCode, BookCode, Amount) 查询销售总量前20%的图书，并按总销量降序排列。SQL语句： SELECT TOP 20 PERCENT Bookcod 点我阅读全文
BookStore数据库中有图书表 Book(BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, ContentInro, 点我阅读全文
C COUNT(Amount) DESC D ADD(Amount) DESC BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, L 点我阅读全文
前3个记录 D 前3个别名 BookStore数据库中有图书表Book(BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, 点我阅读全文
PublisherCode=’21’ D PublisherCode’21’ BookStore数据库中有订单表Order(OrderCode, CustomerCode, TotalPrice, Address, OrderTime, O 点我阅读全文
BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password) 查询Customer表中所有客户的信息， 点我阅读全文
CustomerCode,Name,Hometown,Telephone BookStore数据库中有客户评价表CustomerEvaluation(CustomerCode, VIPClass, Author, EvaluateDate) 点我阅读全文