SQL Problem - Find Running Total of Games Played | SQL Window Functions

[@002anbarasisanthosh9]

Mam could you please provide the table syntax and inserting data too 😢

[@badrilalnagar9232]

There are two bodies in the human body, one is subtle body and the other is causal body.

[@HARSHRAJ-wz2rp]

mam plese provide create and insert into statement

[@Savenature635]

select player_id,event_date,sum(games_played) over(partition by player_id rows between unbounded preceding and current row) as games_played from game_count;

[@SPIKEROCKZ]

how is it ascending order? isnt order by clause by default in desc order?

[@datasciencewithnish]

By default, the ORDER BY clause sorts data in ascending order. If you want to sort it in descending order, you need to specify DESC after the column name.