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;
SELECT * FROM collated;
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;