MySQL 8.0

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

CREATE TABLE data (
    INITIAL INT NOT NULL,
    BETWIXT INT NOT NULL,
    ENDING VARCHAR(20)
);

INSERT 
    INTO data(data.INITIAL,data.BETWIXT,data.ENDING) 
    VALUES
    (30,40,"N0"), 
    (60,80,"N1"), 
    (90,120,"N2"),
    (120,160,"N3"),
    (150,200,"N4");
select * from data;


INITIAL
BETWIXT
ENDING


30
40
N0

60
80
N1

90
120
N2

120
160
N3

150
200
N4


select initial,BETWIXT,ending,lead(ending) over (order by initial) hi from data;


initial
BETWIXT
ending
hi


30
40
N0
N1

60
80
N1
N2

90
120
N2
N3

120
160
N3
N4

150
200
N4
null