← Amazon questions
CodingReported in a candidate post, Mar 2021

Find percentage difference between 4 month and 6 month running average

Filed under Amazon

Given a dataset of monthly values, write a SQL query to find the percentage difference between a 4-month running average and a 6-month running average. Use window functions with 'ROWS PRECEDING' to…

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Amazon questions

Collected from public candidate posts and coding forums. Updated Nov 2026.