VeloxColumnarToRow
  TakeOrderedAndProjectExecTransformer [rnk,best_performing,worst_performing]
    WholeStageCodegenTransformer (11)
      ProjectExecTransformer [rnk,i_product_name,i_product_name]
        BroadcastHashJoinExecTransformer [item_sk,i_item_sk]
          ProjectExecTransformer [rnk,item_sk,i_product_name]
            BroadcastHashJoinExecTransformer [item_sk,i_item_sk]
              ProjectExecTransformer [item_sk,rnk,item_sk]
                ShuffledHashJoinExecTransformer [rnk,rnk]
                  InputIteratorTransformer
                    InputAdapter
                      ColumnarExchange [rnk,item_sk] #1
                        VeloxResizeBatches
                          WholeStageCodegenTransformer (4)
                            ProjectExecTransformer [rnk,item_sk]
                              FilterExecTransformer [rnk,item_sk]
                                WindowExecTransformer [rank_col]
                                  SortExecTransformer [rank_col]
                                    WindowGroupLimitExecTransformer [rank_col]
                                      FilterExecTransformer [rank_col]
                                        Subquery #1
                                          VeloxColumnarToRow
                                            WholeStageCodegenTransformer (2)
                                              ProjectExecTransformer [avg(UnscaledValue(ss_net_profit))]
                                                RegularHashAggregateExecTransformer [ss_store_sk,sum,count] [avg(UnscaledValue(ss_net_profit)),sum,count]
                                                  InputIteratorTransformer
                                                    InputAdapter
                                                      ColumnarExchange [ss_store_sk,sum,count] #3
                                                        VeloxResizeBatches
                                                          WholeStageCodegenTransformer (1)
                                                            ProjectExecTransformer [ss_store_sk,sum,count]
                                                              FlushableHashAggregateExecTransformer [ss_store_sk,_pre_x] [sum,count,sum,count,sum,count]
                                                                ProjectExecTransformer [ss_store_sk,ss_net_profit]
                                                                  FilterExecTransformer [ss_store_sk,ss_addr_sk]
                                                                    FileSourceScanExecTransformer parquet spark_catalog.default.store_sales [ss_addr_sk,ss_store_sk,ss_net_profit,ss_sold_date_sk]
                                        ProjectExecTransformer [ss_item_sk,avg(UnscaledValue(ss_net_profit))]
                                          RegularHashAggregateExecTransformer [ss_item_sk,sum,count] [avg(UnscaledValue(ss_net_profit)),sum,count]
                                            InputIteratorTransformer
                                              InputAdapter
                                                ColumnarExchange [ss_item_sk,sum,count] #2
                                                  VeloxResizeBatches
                                                    WholeStageCodegenTransformer (3)
                                                      ProjectExecTransformer [ss_item_sk,sum,count]
                                                        FlushableHashAggregateExecTransformer [ss_item_sk,_pre_x] [sum,count,sum,count,sum,count]
                                                          ProjectExecTransformer [ss_item_sk,ss_net_profit]
                                                            FilterExecTransformer [ss_store_sk]
                                                              FileSourceScanExecTransformer parquet spark_catalog.default.store_sales [ss_item_sk,ss_store_sk,ss_net_profit,ss_sold_date_sk]
                  InputIteratorTransformer
                    InputAdapter
                      ColumnarExchange [rnk,item_sk] #4
                        VeloxResizeBatches
                          WholeStageCodegenTransformer (8)
                            ProjectExecTransformer [rnk,item_sk]
                              FilterExecTransformer [rnk,item_sk]
                                WindowExecTransformer [rank_col]
                                  SortExecTransformer [rank_col]
                                    WindowGroupLimitExecTransformer [rank_col]
                                      FilterExecTransformer [rank_col]
                                        ReusedSubquery [rank_col] #1
                                        ProjectExecTransformer [ss_item_sk,avg(UnscaledValue(ss_net_profit))]
                                          RegularHashAggregateExecTransformer [ss_item_sk,sum,count] [avg(UnscaledValue(ss_net_profit)),sum,count]
                                            InputIteratorTransformer
                                              InputAdapter
                                                ReusedExchange [ss_item_sk,sum,count] #2
              InputIteratorTransformer
                InputAdapter
                  ColumnarBroadcastExchange #5
                    WholeStageCodegenTransformer (9)
                      FilterExecTransformer [i_item_sk]
                        FileSourceScanExecTransformer parquet spark_catalog.default.item [i_item_sk,i_product_name]
          InputIteratorTransformer
            InputAdapter
              ReusedExchange [i_item_sk,i_product_name] #5
