[psql lag]

第二步：用 lag() 给每个季度配上“前一个季度”

lag(report_period) over (order by report_period)

period_map as (selectreport_period,lag(report_period) over (order by report_period) as prev_report_periodfrom (select distinct report_periodfrom holdings_agg) t
)