Writing the query is the easy part. Ensuring you have the correct data under all scenarios is the hard part.