SQL Case Study

Hi there!

I wish you first a happy new year 2021!! :slight_smile:

Have anyone done the final case study of the SQL for Data Analysis Course?
I can not make the first question asking to compute the daily sum of the daily sales.
This is the result of my request that I put into a new table then called bat_sales_growth:

Here is my final code:

select *
, sum(count) over(order by sales_transaction_date)
into bat_sales_growth
from bat_sales_daily;

Thank you by advance!! :slight_smile:

Cheers!

Jacques