typeORMでのAVGの使用

検索

async hi(user_id: number) {
  const result = await getRepository(User)
    .createQueryBuilder('u')
    .leftJoinAndSelect('u.review_receiver', 'review')
    .select([
      'u.user_no',
    ])
    // 소수점 둘째 자리까지
    .addSelect('AVG(review.review_score)::numeric(10,2)', 'reviewAvg')
    .where(`u.user_no = ${user_id}`)
    .groupBy('u.user_no')
    .getRawOne();
  return result;
}