SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 5) ExpressionList (children 4) Identifier p_brand Identifier p_type Identifier p_size Function countDistinct (alias supplier_cnt) (children 1) ExpressionList (children 1) Identifier ps_suppkey TablesInSelectQuery (children 2) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier partsupp TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier part TableJoin Function and (children 1) ExpressionList (children 5) Function equals (children 1) ExpressionList (children 2) Identifier p_partkey Identifier ps_partkey Function notEquals (children 1) ExpressionList (children 2) Identifier p_brand Literal \'Brand#45\' Function notLike (children 1) ExpressionList (children 2) Identifier p_type Literal \'MEDIUM POLISHED%\' Function in (children 1) ExpressionList (children 2) Identifier p_size Literal Tuple_(UInt64_49, UInt64_14, UInt64_23, UInt64_45, UInt64_19, UInt64_3, UInt64_36, UInt64_9) Function notIn (children 1) ExpressionList (children 2) Identifier ps_suppkey Subquery (children 1) SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 3) ExpressionList (children 1) Identifier s_suppkey TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier supplier Function like (children 1) ExpressionList (children 2) Identifier s_comment Literal \'%Customer%Complaints%\' ExpressionList (children 3) Identifier p_brand Identifier p_type Identifier p_size ExpressionList (children 4) OrderByElement (children 1) Identifier supplier_cnt OrderByElement (children 1) Identifier p_brand OrderByElement (children 1) Identifier p_type OrderByElement (children 1) Identifier p_size