SELECT * FROM posts GROUP BY author