API that gets a list of all posts, with post title, author name, and category
And a SORT post should be ordered by the date they were added, most recent first
p. title,
p. user_id,
p. name,
p. publication_date,
u. first_name,
c. label,
FROM Posts p
JOIN Users u
ON p. user_id = u. id
JOIN Categories c
ON c. id = p. category_id
API that gets a list of all posts, with post title, author name, and category
And a SORT post should be ordered by the date they were added, most recent first
p. title,
p. user_id,
p. name,
p. publication_date,
u. first_name,
c. label,
FROM Posts p
JOIN Users u
ON p. user_id = u. id
JOIN Categories c
ON c. id = p. category_id