ComeçarComece de graça

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.

Este exercício faz parte do curso

Time Series Analysis in PostgreSQL

Ver curso

Instruções do exercício

  • Calculate a running total of the article views.

Exercício interativo prático

Experimente este exercício completando este código de exemplo.

-- Calculate the running total for views
SELECT
    id,
    views,
    ts,
	___ AS running_total
FROM dc_news_fact;
Editar e executar o código