多项选择题
BookStore数据库中有图书表Book(BookCode, BookName, Author, PublisherCode, PublishTime,BookSort, ISBN, BookPicture, ContentInro, Price, Discount),其中 PublishTime是datetime类型。
将Book表中的所有“外语”类图书的价格降低10%,并将折扣均设为8折。SQL语句:
UPDATE Book SET ________ Where BookSort ='外语'。
A、Price=Price*0.9, Discount=0.8
B、Price=Price*(1-10%), Discount=0.8
C、Price=0.9, Discount=0.8
D、Discount=0.8, Price=Price*0.9