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;```
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;