Loading...Loading chart...
1select "year" || '-' || "month" as year_month, new_datasets, new_tables, rows_added,
2 SUM(new_datasets) OVER (ORDER BY "year","month"
3 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS new_datasets_cum,
4 SUM(new_tables) OVER (ORDER BY "year","month"
5 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS new_tables_cum,
6 SUM(rows_added) OVER (ORDER BY "year","month"
7 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS rows_added_cum
8from @blt.catalog_metadata.monthly_catalog_stats
9order by year, month
10