Window Function - Interview question 

Window Function - Interview question
Sum ,Max,Avg
Row_number,Dense_Rank,Rank,Ntile
select * , Sum(Amount) over( partition by Groupid order by id asc) ,
Sum(Amount) over( partition by Groupid order by id desc) [All]
from Sampledata