获取具有父表行的最新子行

两个表格张贴和评论。帖子有很多评论(评论有post\ id外键到posts id主键)

posts

id | content
------------

comments

id | post_id | text | created_at  
-------------------------------

我需要所有的职位,其内容,和最新的评论(基于max(创建于),及其文本。

with comment_latest as (select 
   post_id, 
   max(created_at) as latest_commented_at 
from comments 
group by 1)

select 
    posts.id, 
    posts.content, 
    comment_latest.latest_commented_at 
from posts 
left join comment_latest on comment_latest.post_id = posts.id
order by posts.id desc 
limit 10

但我也想要评论的文本。