Multiple Tables with Reddit SQL Project Task 5

[array7286088120]

THIS IS THE TASK IN QUESTION

Now let’s join the data from the different tables to find out some more information.

Use a LEFT JOIN with the users and posts tables to find out how many posts each user has made. Have the users table as the left table and order the data by the number of posts in descending order.

THIS IS THE HINT

SELECT users.username, COUNT() AS ‘posts_made’
FROM users
LEFT JOIN ___
ON users. = posts.___
GROUP BY users.id
ORDER BY 2 DESC;

CAN SOMEONE WRITE THE CORRECT QUERRY SO I CAN FIGURE OUT WHAT IM DOING WRONG. THANK YOU IN ADVANCE

[tgrtim]

Could you please add a link to this specific lesson. There is some great advice about this and how best to set-up your question in general in the following FAQ-

How to ask good questions (and get good answers)

In general, your post will get a good answer if you’ve remembered to do the following: Always search for existing answers first. Provide as much information and context as possible. Format your code. Follow the Community Guidelines. Reference Additional Resources Before Starting a Topic, Search for Existing Answers Before you start a new topic, check existing posts and use Google to see if your questions have already been addressed. This will very often give you an immediate answer! Crypti…

What have you tried so far? With only two tables mentioned the JOIN clause should be fairly obvious and as for ON you’re looking for your foreign key, a column shared between these two datasets. Have you checked the columns available to these two tables and determined if there are any foreign keys?