DatabaseError: Duplicate column name 'id'

hey guys, i have a problem in my query but cannot figure out what is causing it.

  const coursesSq = db
    .select({
      id: Course.id,
      name: Course.name,
      image: Course.image,
      status: Course.status,
      description: Course.description,
      guides: Course.guides,
      price: Course.price,
      moduleCount: sql<number>`COUNT(${Module.id})`.as("moduleCount")
    })
    .from(Course)
    .leftJoin(Module, eq(Course.id, Module.courseId))
    .groupBy(Course.id)
    .as("courses");

  const membersOnCourse = db
    .select({
      memberId: MemberOnCourse.id,
      courseId: MemberOnCourse.courseId,
      memberKind: MemberOnCourse.memberKind,
      user: {
        id: User.id,
        title: User.title,
        firstName: User.firstName,
        lastName: User.lastName,
        image: User.image
      }
    })
    .from(MemberOnCourse)
    .innerJoin(User, eq(MemberOnCourse.userId, User.id))
    .as("membersOnCourse");

  const courses = await db
    .select()
    .from(coursesSq)
    .leftJoin(membersOnCourse, eq(coursesSq.id, membersOnCourse.courseId));

any idea what's going on?