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
- Measurement of performance