A good style guide for SQL is the one by Simon Holywell.
My comments and annotations will follow below.