Sql query performance

Question

Hi, I want two sql queries build against sql north wind database, for both queries the result should be same

But for one query time taken to execute should be more when compared to the other one

can any one please frame and give me such type of queries atleast one pair or more