When writing raw SQL, I tend to test my queries against the database first with sample queries, then carry them into code once all the logic has been figured out.