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();
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();