Rolling sum concept in SQL

#sql #windowfunctions #DataAnalyst #interview

Create and Insert table statements:
-----------------------------------------------------------
create table employee (empid int, empname varchar(20), department varchar(20), salary)

insert into employee values(1, 'sam', 'Testing', 12000),(2, 'mahesh', 'Development', 1200),(3, 'venkatesh', 'DataAnalytics',1300),
(4, 'bosh', 'Testing', 3000),(5, 'raki', 'Development', 21000),(6, 'ravi', 'DataAnalytics',5100),(7,'Dinesh', 'IT', 3000),(8, 'sam1', 'Testing', 12000)

Here are my medium and github profile links:
----------------------------------------------------------------------------
My medium blogs:   / mahendraee204  
My github: https://github.com/mahendra204