Aging of Accounts in SQL SERVER

Two things.

 

First you will need to add account id (whatever that column is) in your query (and you will also need to add it to group by clause, too!)

 

Second, taking this result in sub query or table variable or cte or physical table or temp table, you will need to use pivot clause to have these values appear in 4 distinct columns for each account.

 

Google the key words for details.

 

Should you need any further help in any specific area, please do not hesitate to ask for.