Calculate support base on previous record

I have a task to join a few tables in SQL Server and here is my final result.

Calculate support base on previous record

I have a task to join a few tables in SQL Server and here is my final result.