请问，这题为什么选 D，是答案错了吗？请帮着分析一下

[listhome]

You are tasked to analyze blocking behavior of the following query:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
WITH Customers AS (
SELECT *
FROM Customer ),
SalesTotal AS (
SELECT CustomerId, SUM(OrderTotal) AS AllOrderTotal
FROM SalesOrder)
SELECT CustomerId, AllOrderTotal
FROM SalesTotal
WHERE AllOrderTotal > 10000.00;
You need to determine if other queries that are using the Customer table will be blocked by this query. You
also need to determine if this query will be blocked by other queries that are using the Customer table.
What behavior should you expect?
A. The other queries will be blocked by this query. The safer , easier way to help you pass any IT exams.
48 / 80
This query will be blocked by the other queries.
B. The other queries will be blocked by this query.
This query will not be blocked by the other queries.
C. The other queries will not be blocked by this query.
This query will be blocked by the other queries.
D. The other queries will not be blocked by this query.
This query will not be blocked by the other queries

[listhome]

有人理我吗

[geniuswjt]

就是共用表达式是否会引起阻塞么？
跟普通查询没啥大的区别吧，不会引起阻塞。

[listhome]

我感觉和CTE没有关系，注意当年的事务级别是
SERIALIZABLE

[listhome]

没人理我阿

[勿勿]

跟cte公用表达式没关系吧

[thq002lyq7]

啥字啊咋看不懂啊

[叶子]

--You are tasked to analyze blocking behavior of the following query: 
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE 
WITH    Customers
          AS ( SELECT   *
               FROM     Customer
             ),
        SalesTotal
          AS ( SELECT   CustomerId ,
                        SUM(OrderTotal) AS AllOrderTotal
               FROM     SalesOrder
             )
    SELECT  CustomerId ,
            AllOrderTotal
    FROM    SalesTotal
    WHERE   AllOrderTotal > 10000.00 ; 

--You need to determine 
--if other queries that are using the Customer table will be blocked by this query. You 
--also need to determine 
--if this query will be blocked by other queries that are using the Customer table. 

/*
What behavior should you expect? 
A. The other queries will be blocked by this query. 
The safer , easier way to help you pass any IT exams. 48 / 80 
This query will be blocked by the other queries. 
B. The other queries will be blocked by this query. 
This query will not be blocked by the other queries. 
C. The other queries will not be blocked by this query. 
This query will be blocked by the other queries. 
D. The other queries will not be blocked by this query. 
This query will not be blocked by the other queries
*/

我也认为应该选择D，这种情况不会发生堵塞。