htsql (www.htsql.org) is a business reporting language -- one line in htsql can generate 5 or 6 lines of SQL. This query could be condensed considerably if rew

htsql (www.htsql.org) is a business reporting language -- one line in htsql can generate 5 or 6 lines of SQL. This query could be condensed considerably if rewritten in htsql. (htsql automatically generates SQL code that covers all corner cases and executes faster than hand-crafted SQL.)