kysely join select query

const query = db
    .selectFrom("Anime")
    .leftJoin("VoteAnime", "Anime.id", "votedForId")
    .select([
      "Anime.id",
      "Anime.name",
      "Anime.imageUrl",
      count("VoteAnime.votedForId").as("VoteFor"),
      count("VoteAnime.votedAgainstId").as("VoteAgainst"),
    ])
    .groupBy("Anime.id")
    .execute();