SQL Server: Short Code Doesn’t Mean Smart Code

TSQL is a powerful query language.A single query can be written by several ways. With new functions and keywords, query with multiple lines now can be written very shortly and effectively BUT every time and SHORT code doesn't mean SMART (well performing)code. How? here is a proof.