Interview Guides
You are given daily operational data with gaps and need to backfill missing dates before analyzing the trend. Write a PostgreSQL query that returns every calendar day in the analysis window, the operational metric for that day, and a backfilled value that carries forward the most recent known metric when a day is missing. Use the provided calendar and metrics tables, and keep days with no recorded metric in the output.
