Getting SQL Right the First Try - Introduction
•To write that clean initial SQL, the developer absolutely does need a precise understanding of the application requirements and the tables.
•There is no point in writing initial SQL that is not a clean, correct spec for what the application needs at that stage in its flow of control!
•Iteration, or trial and error, is a terrible way to write the initial SQL.