Real Time SQL Interview Queries|| Running Sum Scenario
Вставка
- Опубліковано 19 вер 2024
- Adding DDL and DML Commands:
---Create Table------
create table Runs( Player_Name varchar(50), Innings_Date date, Run_Scored int)
--Insert Data--------
Insert into Runs('Travis Head','2024-01-01',20)
Insert into Runs('Travis Head','2024-01-04',70)
Insert into Runs('Travis Head','2024-01-07',55)
Insert into Runs('Travis Head','2024-01-10',35)
Insert into Runs('Travis Head','2024-01-13',60)
Insert into Runs('Ben Duckett','2024-01-01',40)
Insert into Runs('Ben Duckett','2024-01-04',20)
Insert into Runs('Ben Duckett','2024-01-07',25)
Insert into Runs('Ben Duckett','2024-01-10',80)
Insert into Runs('Ben Duckett','2024-01-13',20)
Insert into Runs('Shaun Marsh','2024-01-01',10)
Insert into Runs('Shaun Marsh','2024-01-04',30)
Insert into Runs('Shaun Marsh','2024-01-07',20)
Insert into Runs('Shaun Marsh','2024-01-10',15)
Insert into Runs('Shaun Marsh','2024-01-13',40)
Insert into Runs('Phil Salt','2024-01-01',80)
Insert into Runs('Phil Salt','2024-01-04',90)
Insert into Runs('Phil Salt','2024-01-07',40)
Insert into Runs('Phil Salt','2024-01-10',10)
Insert into Runs('Phil Salt','2024-01-13',50)
