The Art of Writing Good SQL -- By David Aldridge

This is a good article by Mr. David Aldridge and the original source is here. http://oraclesponge.blogspot.com).
My sincere apologies for not getting the author's name right and i was so careless and lazy that i pasted the entire article here without the orginal source link.

The article was really a comprehensive one and pls do read it at the above link.

Anways here is what the aricle outlines.

-- Excerpts from the above orginal source...
"
Writing Good SQL

I think that there are at least five elements to consider. In no particular order:

• Understanding what you are trying to do
• Knowledge of SQL syntax
• Appreciation of the data and the structure
• Optimization
• Measurement of performance

SourceID:NT0000368E

"