Advanced SQL and The Power of the SQL Rewrite – by Tony Andrews

This covers the many different ways to write queries obtaining the same result.
Performance on each is described.
Great advanced SQL examples throughout