how can handles this query

[hagersaleh]

how can handles this query
SELECT a.id, (SELECT MAX(created) FROM posts WHERE author_id = a.id) AS latest_post FROM authors a