Practice Mode • SQL & Data • medium

Rolling Completion Volume

180 points

Produce a rolling completion total for ordered periods.

Problem

You are implementing produce a rolling completion total for ordered periods. The input is one JSON value. Return exactly the JSON or scalar result described by the examples, with stable ordering and no extra logging. Produce an inclusive rolling sum over an ordered metric series. Explain your reasoning and complexity during interview review; the judge evaluates only the returned result.

Input contract

One UTF-8 JSON value matching the structures shown in the examples.

Output contract

One deterministic JSON value or scalar with no explanatory text.

Target complexity

Single ordered window pass

Judge protocol

sql-fixture-json-v1

Examples

Example 1

Input: {"values":[1,2,3,7],"window":2}
Output: [1,3,5,10]

This example demonstrates the core sql data invariant.

Example 2

Input: {"values":[],"window":3}
Output: []

This example covers the empty or minimum boundary.

Constraints

Input is valid UTF-8 JSON and is at most 64 KB.
Output must be deterministic for identical input.
Do not use network access, persistent filesystem writes, subprocesses, or environment secrets.
Handle the empty or minimum boundary shown in the examples.

Progressive hints

Integrity: hidden tests, editorial solutions, and assessment-only cases are never sent to the browser as answer keys. Final execution occurs only in the separately isolated runner.

Execution unavailable until runner deployment and certificationdisabled • pending

Sign in to code

You can review the complete problem publicly. Sign in to save encrypted drafts and submit to the isolated runner.