sql报错： Every derived table must have its own alias

用的是mysql数据库

UPDATE tb_cr_circulate_gtsc 
set path_status='A06'
where
order_id='Ph800601211123155507'
and
receive_role='21075116-001'
and
receive_role_name='024722cd-b197-462f-bdc2-f0423d88e580&Z&11caea25-4996-4682-aa3c-ea698e5140cc&21075116-001&四川省川东农药化工有限公司'
and 
( 
(SELECT statusSum from   (select COUNT(path_status)  as statusSum FROM tb_cr_circulate_gtsc  where order_id='Ph800601211123155507' and path_status='A04' and is_current_point='1' ) )
<  
(SELECT statusSum from  (select COUNT(path_status)  as statusSum  FROM tb_cr_circulate_gtsc where order_id='Ph800601211123155507' and is_current_point='1') )
)

报错提示：每一个派生出来的表都必须有一个自己的别名

解决方式：在新产生表的地方加上别名

( 
(SELECT statusSum from   (select COUNT(path_status)  as statusSum FROM tb_cr_circulate_gtsc  where order_id='Ph800601211123155507' and path_status='A04' and is_current_point='1' ) as a)
<  
(SELECT statusSum from  (select COUNT(path_status)  as statusSum  FROM tb_cr_circulate_gtsc where order_id='Ph800601211123155507' and is_current_point='1') as a )
)