sql求上个月的月份和得分

Question

问题是现在是2022年5月份，我想求2022年4月份的月份和得分，通过4月份的得分，求出来3月份的得分和数据，如何写sql

上面这张是表结构

这张是我想要求出来的效果

Answer 1

日期改一下就可以了
select T1.mxid,
LAG(T1.YF,0)OVER(PARTITION BY T1.YF ORDER BY T1.YF DESC ),
LAG(T1.FS,0)OVER(PARTITION BY T1.YF ORDER BY T1.YF DESC ),
T2.DTYF,
T2.DTFS
FROM zzz T1
LEFT JOIN (select mxid AS mxidT2,
LAG(YF,0)OVER(PARTITION BY YF ORDER BY YF DESC ) DTYF,
LAG(FS,0)OVER(PARTITION BY YF ORDER BY YF DESC ) DTFS 
FROM zzz 
WHERE YF = '202203') T2 
ON T1.MXID = T2.mxidT2
WHERE YF = '202204'