Multiple tables with reddit

i’m wondering why this code:

WITH popular_post AS (
SELECT MAX(posts.score) AS ‘top_scorer’
FROM posts
GROUP BY posts.subreddit_id
FROM subreddits
JOIN popular_post
ON = posts.subreddit_id;
do not return the same result of the code suggested by the hint:
posts.title, AS ‘subreddit_name’,
MAX(posts.score) AS ‘highest_score’
FROM posts
INNER JOIN subreddits
ON posts.subreddit_id =

Could you either edit your answer or add a reply with your full query (part of it seems to have gone walkabouts :upside_down_face:). 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 (


FROM posts

WHERE score >= 5000


SELECT, popular_posts.title , popular_posts.score

FROM subreddits

INNER JOIN popular_posts

ON = popular_posts.subreddit_id

ORDER BY popular_posts.score DESC;

1 Like