SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 7) ExpressionList (children 3) Identifier CounterID Function avg (alias l) (children 1) ExpressionList (children 1) Function length (children 1) ExpressionList (children 1) Identifier URL Function count (alias c) (children 1) ExpressionList TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier test.hits_s3 Function notEquals (children 1) ExpressionList (children 2) Identifier URL Literal \'\' ExpressionList (children 1) Identifier CounterID Function greater (children 1) ExpressionList (children 2) Identifier c Literal UInt64_100000 ExpressionList (children 1) OrderByElement (children 1) Identifier l Literal UInt64_25