老友网A、(MAX-MIN)Price
B、MAX(Price)-MIN(Price)
C、(MAX-MIN)(Price)
D、MAX:Price-MIN:Price
答案：B
7、【单选题】BookStore数据库中有销售明细表OrderDetail(OrderCode, BookCode, Amount)查询销售总量前20%的图书，并按总销量降序排列。SQL语句： SELECT TOP 20 PERCENT Bookcode As 书号, SUM(Amount)As总销量 ROM OrderDetail GROUP BY Bookcode ORDER BY ________
A、Amount DESC
B、SUM(Amount) DESC
C、COUNT(Amount) DESC
D、ADD(Amount) DESC
答案：B
8、【多选题】BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password) 查询Customer表中所有客户的信息，SQL语句: SELECT ________ FROM Customer
A、*
B、CustomerCode, Name, Hometown, Sex, Email, Telephone, LoginTime, PassWord
C、CustomerCode, Hometown, Telephone, Name, Sex, Email, LoginTime, PassWord
D、CustomerCode ~ PassWord
答案：ABC
9、【多选题】BookStore数据库中有图书表Book(BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, ContentInro, Price, Discount)，其中 PublishTime是datetime类型。 查询2009年出版的少儿类图书,要求显示图书名称(BookName)、作者(Author)、出版时间(PublishTime)、价格(Price)和折扣(Discount),并且字段标题分别为图书名称、作者、内容简介、价格和折扣。SQL语句: SELECT BookName As 图书名称, Author As 作者, convert(char(10), PublishTime, 120) As 出版时间, Price As 价格, Discount As 折扣 FROM Book WHERE BookSort=’少儿’ AND _________
A、PublishTime=2009
B、YEAR(PublishTime)=2009
C、PublishTime>=’2009-1-1′ AND PublishTime<‘2010-1-1’
D、PublishTime>=’2009-1-1′ AND PublishTime<=’2009-12-31′
答案：BCD
10、【多选题】BookStore数据库中有订单表Order(OrderCode, CustomerCode, TotalPrice, Address, OrderTime, OrderStatus) 查询订单总价(TotalPrice)在100到200元之间的订单信息。SQL语句: SELECT OrderCode, TotalPrice, OrderTime, OrderStatus FROM [Order] WHERE ________
A、TotalPrice BETWEEN 100 AND 200
B、TotalPrice NOT BETWEEN 100 AND 200
C、100 <=TotalPrice<=200
D、TotalPrice>=100 And TotalPrice<=200
答案：AD
11、【判断题】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=“%程序%”