Im curious to know, what the difference is between the following 2 answers Q9,Q10
SELECT posts.title, subreddits.___ AS 'subreddit_name', MAX(___) AS 'highest_score' FROM posts INNER JOIN ___ ON posts.___ = subreddits.___ GROUP BY subreddits.id;
SELECT subreddits.___, AVG(posts.___) AS 'average_score' FROM ___ INNER JOIN posts ON subreddits.id = posts.subreddit_id GROUP BY subreddits.name ORDER BY 2 DESC;
Why is the first group by made with ID while the second group by is with NAME?
Arent both the same?