Single Table Queries

Quite recently, I started reading a book about T-SQL. It was written by Itzik Ben-Gan. I'm learning so much that I thought it'd be great to document my journey so here goes... Elements of the SELECT statement THE SELECT statement is used to query ta...