Backfilling Historical Data

Problem

You just added a new column calculating customer loyalty scores. You need to write a script that calculates this score for all orders placed over the last 5 years. Write a query that outputs strategy with the value: "Backfilling is the process of running a data pipeline retroactively over historical ranges to populate new columns or table definitions."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution