How to use `not` to avoid returning results where ID is in a specific join table?

SELECT * FROM drills WHERE organization_id = 1 AND id NOT IN (SELECT drill_id FROM practice_drills WHERE team_id = 2)

SELECT * FROM drills WHERE organization_id = 1 AND id NOT IN (SELECT drill_id FROM practice_drills WHERE team_id = 2)

    const subQuery = db
      .select({ drillId: practiceDrills.drillId })
      .from(practiceDrills)
      .where(eq(practiceDrills.teamPracticeId, params.teamPracticeId));

    const data = await db.query.drills.findMany({
      where: and(eq(drills.organizationId, params.organizationId), not(eq(drills.id, subQuery))),
    });

    const subQuery = db
      .select({ drillId: practiceDrills.drillId })
      .from(practiceDrills)
      .where(eq(practiceDrills.teamPracticeId, params.teamPracticeId));

    const data = await db.query.drills.findMany({
      where: and(eq(drills.organizationId, params.organizationId), not(eq(drills.id, subQuery))),
    });

more than one row returned by a subquery used as an expression

more than one row returned by a subquery used as an expression