SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 6) ExpressionList (children 5) Identifier WatchID Identifier ClientIP Function count (alias c) (children 1) ExpressionList Function sum (children 1) ExpressionList (children 1) Identifier Refresh Function avg (children 1) ExpressionList (children 1) Identifier ResolutionWidth TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier test.hits_s3 Function notEquals (children 1) ExpressionList (children 2) Identifier SearchPhrase Literal \'\' ExpressionList (children 2) Identifier WatchID Identifier ClientIP ExpressionList (children 2) OrderByElement (children 1) Identifier c OrderByElement (children 1) Identifier WatchID Literal UInt64_10