/**
   * returns an array of user id, username, and the number of accepted problems of the user, sorted by the number of accepted problems
   * @param code
   */
  async getRoomRankings(code: string) {
    Submission;
    User;
    const qb = this.roomRepository
      .createQueryBuilder('room')
      .where('room.code = :code', { code })
      .innerJoin('room.joinedUsers', 'roomUser')
      .innerJoin('roomUser.user', 'user')
      .innerJoin(
        'room.submissions',
        'submission',
        'submission.status = :status AND submission.user_id = user.id AND submission.alreadyAccepted = false',
        {
          status: Status.ACCEPTED,
        },
      )
      .select('user.id', 'userId')
      .addSelect('user.username', 'username')
      .addSelect('COUNT(submission.id)', 'acceptedCount')
      .addSelect('MAX(submission.submittedAt)', 'lastAcceptedAt')
      .groupBy('user.id')
      .orderBy('acceptedCount', 'DESC')
      .addOrderBy('lastAcceptedAt', 'ASC');

    const data = await qb.getRawMany();
    return { data };
  }