What did you learn? Precomputation trades space for query speed. You spend space to make queries .
Cumulative sums let you compute any range sum by subtraction. Here's the core prefix sum trick.
The offset in prefix arrays simplifies edge cases. means you never special-case the start of the array. This pattern generalizes. Can you extend it to two dimensions?