Model cumulative booking metrics and first and last booking times

A data engineering round: design the tables and pipeline that report cumulative booking metrics over time, along with each user's (or listing's) first and last booking time. Cover the grain of the fact table, how you update the cumulative numbers each day without recomputing history, late-arriving bookings and cancellations, and the SQL that reads it.