← All practice problems

MA2 vs MA3 ratio of daily revenue

working · sql🔒Walkthroughs

NEW

MA2 vs MA3 ratio of daily revenue

Aggregate PAID order revenue per day. Compute TWO rolling averages over the daily series: - ma2 = trailing 2-row average - ma3 = trailing 3-row average

Then add their ratio ma2 / ma3. The ratio is a momentum indicator — values > 1 mean recent revenue is running hotter than the 3-day baseline.

Round all three to 2 decimals.

Columns: day, ma2, ma3, ratio. Sort by day ascending. Compute the ratio from RAW averages (not from the rounded display values) so precision propagates correctly.

Tables & sample data

orders

Loading preview…

query.sql

Loading…

Loading editor…