SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select sqlite_version();


sqlite_version()


3.39.1


CREATE TABLE mytable ( 
   Fiscal Week  CHAR(7),
   Quantity     FLOAT);

✓
INSERT INTO  mytable  VALUES
   ('2024011',1000),
   ('2024012',2000),
   ('2024013',0),
   ('2024014',3000),
   ('2024015',0);
✓
-- OFFSET=1
select m1.Fiscal, m1.Quantity, COALESCE(m2.Quantity,0) as Current_quantity 
from mytable m1 
left join mytable m2 on m1.Fiscal = m2.Fiscal+1;


Fiscal
Quantity
Current_quantity


2024011
1000
0

2024012
2000
1000

2024013
0
2000

2024014
3000
0

2024015
0
3000


-- OFFSET=2
select m1.Fiscal, m1.Quantity, COALESCE(m2.Quantity,0) as Current_quantity 
from mytable m1 
left join mytable m2 on m1.Fiscal = m2.Fiscal+2;


Fiscal
Quantity
Current_quantity


2024011
1000
0

2024012
2000
0

2024013
0
1000

2024014
3000
2000

2024015
0
0

Fiscal	Quantity	Current_quantity
2024011	1000	0
2024012	2000	1000
2024013	0	2000
2024014	3000	0
2024015	0	3000