Adding tests of code managing multiple where, order by and join clauses.