SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 4) ExpressionList (children 1) Asterisk TablesInSelectQuery (children 1) TablesInSelectQueryElement (children 1) TableExpression (children 1) Subquery (alias t) (children 1) SelectWithUnionQuery (children 1) ExpressionList (children 1) SelectQuery (children 2) ExpressionList (children 5) Identifier product_name Identifier group_name Identifier price Function min (alias min_price) (children 1) ExpressionList (children 1) Identifier price Function dense_rank (alias r) (children 1) ExpressionList TablesInSelectQuery (children 2) TablesInSelectQueryElement (children 1) TableExpression (children 1) TableIdentifier products TablesInSelectQueryElement (children 2) TableExpression (children 1) TableIdentifier product_groups TableJoin (children 1) ExpressionList (children 1) Identifier group_id Function greater (children 1) ExpressionList (children 2) Identifier min_price Literal UInt64_160 ExpressionList (children 3) OrderByElement (children 1) Identifier group_name OrderByElement (children 1) Identifier r OrderByElement (children 1) Identifier product_name