Loading...Loading chart...
1SELECT
2 new_datasets,
3 new_tables,
4 rows_added,
5 MAKE_DATE(year, month, 1) as date,
6 SUM(new_datasets) OVER (ORDER BY MAKE_DATE(year, month, 1)) as datasets,
7 SUM(new_tables) OVER (ORDER BY MAKE_DATE(year, month, 1)) as tables,
8 SUM(rows_added) OVER (ORDER BY MAKE_DATE(year, month, 1)) as rows
9FROM "@adlrocha.sandbox.baselight_monthly_stats"
10ORDER BY date;