Struggling writing a complicated RLS policy (with a cool chatgpt test)

select * from (
    select (
      select count(*) 
      from projects
      where projects.team_id = '21bf170f-f37b-4bf9-838d-f66c5d10b385'
    ) as team_projects,
    *
    from teams
    join team_members on team_members.team_id = teams.id
    join (
      select *
      from plans
      where id = 'basic'
    ) plans on plans.id = teams.plan_id
    where user_id = auth.uid()
    and teams.id = '21bf170f-f37b-4bf9-838d-f66c5d10b385'
    and owner = true) as yo
  where team_projects < allowed_projects

CREATE POLICY project_creation_policy
ON projects
AS RESTRICTIVE
FOR INSERT
USING (
  -- Check if the user is an owner of the team specified in the new project
  EXISTS (
    SELECT 1
    FROM teams
    WHERE teams.id = '21bf170f-f37b-4bf9-838d-f66c5d10b385'
    AND teams.owner_id = auth.uid()
  )
  AND (
    -- Check if the team has available projects as determined by its plan
    SELECT count(*)
    FROM projects
    WHERE projects.team_id = '21bf170f-f37b-4bf9-838d-f66c5d10b385'
  ) < (
    SELECT plans.allowed_projects
    FROM plans
    WHERE plans.id = (
      SELECT teams.plan_id
      FROM teams
      WHERE teams.id = '21bf170f-f37b-4bf9-838d-f66c5d10b385'
    )
  )
)