calculate number of days between two or more dates

[Carlaf_93]

good morning,

i've got a table like this

LORI	01/01/2023	10
LORI	02/01/2023	50

i would like to get the number of days between the two days.

Ho can i do it?

thanks

C.

[Gabbar]

Lets Name these Columns as 
Name, Date , Number respectively.

Try this:
A:
Load Name,Date,Number From source.

Noconcatenate
B:
Load *, if(Name=previous(Name),previous(Date)-Date,null()) as Number Of Days
resident A order by Name asc, Date Desc;
Drop Table A;