i’m wondering why this code:
WITH popular_post AS (
SELECT MAX(posts.score) AS ‘top_scorer’
FROM posts
GROUP BY posts.subreddit_id
)
SELECT *
FROM subreddits
JOIN popular_post
ON subreddits.id = posts.subreddit_id;
do not return the same result of the code suggested by the hint:
SELECT
posts.title,
subreddits.name AS ‘subreddit_name’,
MAX(posts.score) AS ‘highest_score’
FROM posts
INNER JOIN subreddits
ON posts.subreddit_id = subreddits.id
GROUP BY subreddits.id;
Could you either edit your answer or add a reply with your full query (part of it seems to have gone walkabouts 
). Ideally please format your code too as per the guidance linked below-
Struggling with this step, too. Are we supposed to save the results from the previous step? I’ve tried both and neither works.
The bottom have of your code is all you need. Remove everything before the third SELECT.
The question is asking to get the order the results by each popular post’s score in descending order. Using “Order by” instead of “group by”
I paste my code, hope this helps
WITH popular_posts AS (
SELECT *
FROM posts
WHERE score >= 5000
)
SELECT subreddits.name, popular_posts.title , popular_posts.score
FROM subreddits
INNER JOIN popular_posts
ON subreddits.id = popular_posts.subreddit_id
ORDER BY popular_posts.score DESC;