我试图在sql notebook中使用以下语法创建一个表，但不断出现如下错误：“expected list item:”my code:

create table
   player_info as 
( 
select distinct id,
         name,
         sex,
         age,
         case(when height is NULL then floor(avg(height)) else height end) as Hght,
         case(when weight is NULL then floor(avg(weight)) else weight end ) as Wght,
         team as country,
         city
from athlete_events
group by id,
         name,
         sex,
         age
)

例如，我想从主数据集中使用select子句中提到的字段创建一个表，以便删除空值。预期的输出应该是一个表，其中age、height和weight列中没有空值。
编辑：我找到了解决这个问题的方法，实际上是括号，它是case语句和select子句的问题，它不应该包含在括号中，它认为它是子查询的一部分。考虑到条件，我使用“na”作为该列的数据类型的还有文本。代码如下所示：

create table
   player_info as 
select distinct id,
         name,
         sex,
         age,
         (case when height ='NA' then floor(avg(height)) else height end) as Hght,
         (case when weight ='NA' then floor(avg(weight)) else weight end ) as Wght,
         team as country,
         city
from athlete_events
group by id,
         name,
         sex,
         age