Query to compare execution performance metrics for the three most recent months
You might want to use Common Table Expression or Should use meaningful table alias in Join.

You might also want to use indexes on your date column with &lt;= and >= operator instead of between.

Surround your column names in [] instead of single quotes.