Hi guys,
I got stuck on Q8 for extra practice Mulpital Talbes with Reddit. I wrote below code but didn’t pass and I couldn’t find any error. Will anyone be a good helper here? Thanks!
WITH popular_posts AS (
SELECT *
FROM posts
WHERE score >= 5000
)
SELECT subreddits.name, popular_posts.title, popular_posts.score
FROM subreddits
JOIN polular_posts
ON subreddits.id = popular_posts.subreddit_id
ORDER BY popular_posts.score DESC;
I have a similar question with my SQL as well. I couldn’t pass and couldn’t find any error. Will anyone be a good helper as well, thanks.
with popular_posts as (
select *
from posts
where score >= 5000
)
select subreddits.name, popular_posts.title, popular_posts.score
from subreddits
inner join popular_posts
on subreddits.score = popular_posts.score
order by popular_posts.score desc;
I just fixed the error. Below code passes.
with popular_posts as (
select *
from posts
where score >= 5000
)
select subreddits.name, popular_posts.title, popular_posts.score
from subreddits
inner join popular_posts
on subreddits.id = popular_posts.subreddit_id
order by popular_posts.score desc;