Advanced analytics -technology and tools – advanced sql and madlib”

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Order a Similar Paper HERE Order a Different Paper HERE

 

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

   ‘0 days’::interval FOLLOWING)

ORDER BY region, dt