THIS IS THE TASK IN QUESTION
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 THE HINT
SELECT users.username, COUNT() AS ‘posts_made’
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