I am attempting this extra practice
and wanted to ask about problem 9.
My code is as follows
WITH total_posts AS( SELECT * FROM posts UNION SELECT * FROM posts2 ) SELECT title,score,subreddits.name FROM total_posts JOIN subreddits ON total_posts.subreddit_id = subreddits.id GROUP BY subreddits.id ORDER BY 2 DESC;
However, it doesn’t query the correct results, not unless I use a max(score). So my question is, what is happening. Is it randomly selecting a post from a subreddit?