SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 2) ExpressionList (children 1) Function countIf (alias res) (children 1) ExpressionList (children 1) Function equals (children 1) ExpressionList (children 2) Identifier sym Literal \'Red\' TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) Subquery (children 1) SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 2) ExpressionList (children 1) Function CAST (alias sym) (children 1) ExpressionList (children 2) Function CAST (children 1) ExpressionList (children 2) Function modulo (children 1) ExpressionList (children 2) Identifier number Literal UInt64_5 Literal \'Enum8(\\\'Red\\\' = 0, \\\'Blue\\\' = 1, \\\'Yellow\\\' = 2, \\\'Black\\\' = 3, \\\'White\\\' = 4)\' Literal \'LowCardinality(String)\' TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) Function numbers (children 1) ExpressionList (children 1) Literal UInt64_10