我相信你想要这个：
SELECt to_char(revision_timestamp, 'YYYY-MM'), count(b.id)FROM package aJOIN package_revision b ON a.revision_id = b.revision_idWHERe revision_timestamp > date_trunc('month', CURRENT_DATE) - INTERVAL '1 year'GROUP BY 1
我相信你想要这个：
SELECt to_char(revision_timestamp, 'YYYY-MM'), count(b.id)FROM package aJOIN package_revision b ON a.revision_id = b.revision_idWHERe revision_timestamp > date_trunc('month', CURRENT_DATE) - INTERVAL '1 year'GROUP BY 1名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
