*I need help with Extra Practice for the Reddit question 5.
Now let’s join the data from the different tables to find out some more information.
LEFT JOIN with the
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 what I have so far:
SELECT users.username, COUNT(*) AS ‘posts_made’
LEFT JOIN posts
ON users.id = posts.id
GROUP BY users.id
ORDER BY 2 DESC;
I am not getting any results