CREATE VIEW collated AS SELECT a.poster_id, MONTH(a.time_of_post) AS month_in, b.user_id AS post_belonging_to
    FROM comments a, running_activities b
    WHERE a.activity_id = b.activity_id
    AND kudos = 1
    ORDER BY b.user_id, a.poster_id;

DROP VIEW collated;

SELECT poster_id, COUNT(*), month_in, post_belonging_to
    FROM collated a INNER JOIN followers b
    WHERE a.poster_id = b.follower_id
    AND a.post_belonging_to = b.following_id
    GROUP BY month_in, poster_id, post_belonging_to
    HAVING COUNT(*) >= 5;