SQL 每日一练(Lag () over (partition by))

SQL 每日一练(SQL每日一练)
@ 题目和答案来源于 wechat：SQL数据库开发

题目：

Carrier_Name	OrderNumber	ReSumCost
A1	JOY03	170.00
A2	JOY03	170.00
A1	JOY04	196.50
A2	JOY04	196.50
A1	JOY05	458.80
A2	JOY05	458.80

OUTPUT

Carrier_Name	OrderNumber	ReSumCost	NewReSumCost
A1	JOY03	170.00	170.00
A2	JOY03	170.00	.00
A1	JOY04	196.50	196.50
A2	JOY04	196.50	.00
A1	JOY05	458.80	458.80
A2