And, heh... don't get me started on the practice of using leading commas in code.
Oh! Come on Jeff don't be coy now
For the record, when I code SQL I,
Use trailing commas
Aliases when more than one table/subqeury
Aliases always in subqueries
Try to make alias meaningful (ie o for Order, ol or OrderLine etc)
Uppercase SQL keywords
Indent JOIN beneath FROM
Indent ON/AND beneath JOIN (each comparison on separate line)
Indent subqueries and subquery SQL
Far away is close at hand in the images of elsewhere.