>The follow three commands generate different results for certain data.

I'm also finding it hard to get what you're doing, but the second query has a HAVING clause without a GROUP BY. HAVING should never be used without GROUP BY; it works on intermediate results and is meant to let you filter on the results of aggregation. Move that filter into the WHERE clause.

Tamar