How would you use SQL to compare pre- and post-change performance for a strategy, including joins, aggregations, and date-based filtering?