I am working on the Multiple Tables with Reddit and I can’t find my mistake on Q8…
I guess I need a second pair of eyes…
This is my code :
WITH popular_posts AS (
SELECT * FROM posts
SELECT * FROM posts2
WHERE score >= 5000
AND WHERE score IS NOT NULL
SELECT subreddits.name, popular_posts.title, popular_posts.score
ON subreddits.id = popular_posts.subreddit_id
ORDER BY popular_posts.score DESC;
The first part works well when it is not in the WITH clause, but the complete code does not return any result.
I am a REAL beginner, what am I missing ?