Allow for complex subtables by or connected queries.
Shortened average to exclude extreme values.