Multiple Tables with Reddit Q10

Data Science
1

Please help, where is mistake, why query doesn’t execute?

select 
 posts.title, 
 avg(posts,score) as "average_score"
 subreddits.name as "subreddit_name"
from subreddits
inner join posts
on posts.subreddits_id = subreddits.id 
group by subreddits.name;```
2

Is a comma supposed to be there?

avg(posts,score) as "average_score"
1 Like
3

Here is a possible solution, rounding the average score to one digit:

SELECT subreddits.name,
ROUND(AVG (posts.score), 1) AS ‘Average_score’
FROM subreddits
INNER JOIN posts
ON subreddits.id = posts.subreddit_id
GROUP BY 1
ORDER BY 2 DESC;

1 Like