Hey i want some sql queries with their optimized queries

Question

hi friends,
i want some sql queries with their optimized queries, means two queries should retrieve same result from sql 2005 database but one query performance should be more than the other
i need such type of pairs of sql queries can any one please help me on this
here i am attaching ont ppt file , in this optimized queries r there for the oracle database but i want this type of optimized queries for the sqlserver 2005 database, see the ppt file