有谁知道为什么我无法在此查询中对TotalSales进行分组，如果可以，我该如何解决:selectcoalesce(Author_ID,'AllAuthors')asAuthor_ID,casewhenAuthor_IDisnullthen''elsecoalesce(Book_ID,'AllBooks')endasBook_ID,TotalQuantity,coalesce(TotalSales,'NoSales')asTotalSalesfrom(selectauthor_idasAuthor_ID,book_idasBook_ID,sum(quantity)asTotalQuan