Advanced analytics -technology and tools – advanced sql and madlib”
After reading Chapter 11a and Chapter 11b Lecture (see the attachments), “Advanced Analytics -Technology and Tools – Advanced SQL and MADlib” • Describe how the following code will work: SELECT dt, region, revenue, count(*) OVER (twdw) AS moving_count, avg(revenue) OVER (twdw) AS moving_average FROM moving_average_data mad WINDOW twdw AS (PARTITION BY region ORDER BY dt RANGE BETWEEN ‘7 days’::interval PRECEDING AND […]
