Advanced Analytics -Technology and Tools - Advanced SQL and MADlib”

profileursMahesh_

 

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

Tags: urgent
  • 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 …