单选题

根据下面给的表和 SQL 语句，问执行 SQL 语句更新多少条数据？

Question

根据下面给的表和 SQL 语句，问执行 SQL 语句更新多少条数据？sql 语句：
update Books set NumberOfCopies = NumberOfCopies + 1 where AuthorID in select AuthorID from Books group by AuthorID having sum(NumberOfCopies) <= 8
表中数据：
BookID Tittle Category NumberOfCopies AuthorID
1 SQL Server 2008 MS 3 1
2 SharePoint 2007 MS 2 2
3 SharePoint 2010 MS 4 2
5 DB2 IBM 10 3
7 SQL Server 2012 MS 6 1

A. 1

B. 2

C. 3

D. 4

E. 5