BookStore数据库中有客户评价表CustomerEvaluation(Cu...uationWHERE_________
举一反三
- BookStore数据库中有客户评价表CustomerEvaluation(CustomerCode, VIPClass, Author, EvaluateDate),其中 PublishTime是datetime类型。 查询用户等级(VIPClass)为“A”的客户编号(CustomerCode)和评价时间(EvaluateDate),要求显示标题分别为“客户编号”和“评价时间”。SQL语句: SELECT CustomerCode As 客户编号, EvaluateDate As 评价时间 FROM CustomerEvaluation WHERE _________
- BookStore数据库中有客户表Customer(CustomerCode, ...______ FROM Customer
- BookStore数据库中有订单表Order(OrderCode, Custom...rder] WHERE ________
- BookStore数据库中有出版社表Publisher(PublisherCod...4391”。SQL语句:________
- BookStore数据库中有图书表Book(BookCode, BookName..._ BookSort FROM Book