Calculate a running total
Business intelligence is the lifeblood of the business role. There is a saying: "if you can't measure it, you can't sell it."
As a marketing analyst, you want to create a graph of cumulative views of articles over the period of time.
Bu egzersiz, kursun bir parçasıdır
Time Series Analysis in PostgreSQL
Egzersiz talimatları
- Calculate a running total of the article
views.
Uygulamalı etkileşimli egzersiz
Bu egzersizi bu örnek kodu tamamlayarak deneyin.
-- Calculate the running total for views
SELECT
id,
views,
ts,
___ AS running_total
FROM dc_news_fact;