Fix ranking displaying aliased courses that have fewer than 3 reviews

[Nicholas-Sliter]

[Nicholas-Sliter]

Bug occurs only on production and is not replicated in local dev envs

[Nicholas-Sliter]

Query in question

`
export function generateBaseCourseAverages(qb: Knex.QueryBuilder, count: number = 3) {

return qb.with("CourseReview", (qb) => {
    qb.from("Review")
        .where(
            {
                "Review.deleted": false,
                "Review.archived": false
            })
        .select(reviewInfo)
})
    .with("CourseAliases", (qb) => {
        qb.from("Course")
            .joinRaw("LEFT JOIN \"Alias\" ON \"Alias\".\"aliasID\" = \"Course\".\"courseID\"")
            .select({
                courseID: "Course.courseID",
                primaryCourseID: knex.raw("COALESCE(\"Alias\".\"courseID\", \"Course\".\"courseID\")"),
            });
    })
    .from("CourseReview")
    .leftJoin("CourseAliases", "CourseAliases.courseID", "CourseReview.courseID")
    .groupBy("primaryCourseID")
    .havingRaw(`count(*) >= ?`, [count])
    .select(["primaryCourseID as courseID"])
    .avg({
        /* Instructor specific */
        avgInstructorEffectiveness: "CourseReview.instructorEffectiveness",
        avgInstructorAccommodationLevel: "CourseReview.instructorAccommodationLevel",
        avgInstructorEnthusiasm: "CourseReview.instructorEnthusiasm",
        avgInstructorAgain: knex.raw(`CAST("CourseReview"."instructorAgain" = 'True' as int)`),
        avgInstructorEnjoyed: knex.raw(`CAST("CourseReview"."instructorEnjoyed" = 'True' as int)`),
        /* Course specific */
        avgRating: "CourseReview.rating",
        avgValue: "CourseReview.value",
        avgDifficulty: "CourseReview.difficulty",
        avgHours: "CourseReview.hours",
        avgAgain: knex.raw(`CAST("CourseReview"."again" = 'True' as int)`),
        // topTags: knex.raw(`array_agg(DISTINCT(UNNEST("CourseReview"."tags")))`)
    })
    .count({
        numReviews: "CourseReview.reviewID"
    });

}
`