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_averageFROM moving_average_data madWINDOW twdw AS (PARTITION BY regionORDER BY dt RANGE BETWEEN’7 days’::interval PRECEDING AND’0 days’::interval FOLLOWING)ORDER BY region, dt