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, r

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