图书
12BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime,BookSort,ISBN,BookPicture,ContentInro,Price,Discount)查询图书名称(BookName)含有“程序”的图书信息。SQL语句:SELECTBookCode,BookName,Author,Price,DiscountFROMBookWHEREName=“%程序%” 13BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime,BookSort,ISBN,BookPicture,ContentInro,Price,Discount)查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。SQL语句:SELECTBookName,AuthorFROMBookWHERELenth(Author)=8